All Forums Database
pmehrotr 16 posts Joined 12/13
03 Dec 2013
Why I do not see all the databases in Teradata Studio

I am using Teradata Studio 14.0 on Windows 7.  In database source explorer I do not see all the databases which I have access to, why? In SQL Editor  I can netr query like:
select * from scdb1_v.myview
and see the resuts
But I do not see scdb1_v in data  source explorer when I connect . Is  there any option  to see all the databases whose objects I can access.
 
I am new bie to Teradata, have lots of database experience with Oracle.
 
Thanks.
 
 
 

M.Saeed Khurram 544 posts Joined 09/12
03 Dec 2013

Hi,
it seems that you connection is filtering out some schemas. You can right click on your connection -> go to Properties -> go to default schema filter section and make sure that disable filter check box is marked.
Please let me know if the issue is solved!
 

Khurram

pmehrotr 16 posts Joined 12/13
04 Dec 2013

Thanks. but I do not see poperties like default schema... I am on Tredata Studio 14.0.4...
 
Since I am on windows platform, I also have Tredata SQL Assist.. There also I do not see all schemas. but it has a menu option  called Add  Database ... and then I can add databases.
In TRedata Studio, I  guess I will have to create new Database Connections for each schema...
 

M.Saeed Khurram 544 posts Joined 09/12
04 Dec 2013

No, You do not have to create connection for each schema, But it is possible while making a connection you had specified some default schema, and then only that schema is visible in you database explorer tree. 
Have you tried right click on the Database connection visible in DB Explorer window?
 

Khurram

pmehrotr 16 posts Joined 12/13
04 Dec 2013

My Authentication is LDAP
and I did not sepcify any database (.e. database is BLANK).

M.Saeed Khurram 544 posts Joined 09/12
04 Dec 2013

So you are using JDBC with LDAP?
I have tried changing the authentication mechanism to LDAP, and it is much of the same. 
I think it might be the issue with user you are using, if you are on VM, can you try connecting using DBC?
 

Khurram

pmehrotr 16 posts Joined 12/13
05 Dec 2013

Thanks a lot. What do you mean connecting using DBC. Do you mean do not use LDAP.

M.Saeed Khurram 544 posts Joined 09/12
05 Dec 2013

I meant to login using DBC user. loging in using DBC will confirm either it is an issue with the connection or it is an access rights issue hiding other schemas.
 

Khurram

pmehrotr 16 posts Joined 12/13
09 Dec 2013

I do not have access to DBC. There is something in TREDATA Studio which is different from SQL Assist. When one does LDAP authentication in Terdata Studio, it does not show all the databases I have access to, in SQL Assit it does. My company Tredata Studio, they only access to developers using LDAP, so I am unable to use Tredata Studio instead I have to settle for SQL Assist, tool I am not fond of.

fgrimmer 553 posts Joined 04/09
10 Dec 2013

Is the database you are looking for a child to another database? You can change the Data Source Explorer view to show all the databases in a flat view (not hierarchical) by changing a preference. Go to Window>Preferences>Teradata Datatools Preferences>Data Source Explorer Load Preferences and uncheck the 'Show Databases and Users in Hierarchical Display' option.

pmehrotr 16 posts Joined 12/13
10 Dec 2013

fgrimmer:
 
That was it. Thank  you so much. I can now see all the databases.
 
Prem

M.Saeed Khurram 544 posts Joined 09/12
10 Dec 2013

fgimmer,
Thanks for sharing a great peace of info :)
 

Khurram

vbdcb 14 posts Joined 12/09
10 Sep 2014

Just helped me too. Thanks Fran!

amitjn 1 post Joined 06/11
17 Sep 2014

Excellent info, thanks!

gunn 8 posts Joined 11/14
13 Nov 2014

Thanks! Very useful info!

nghoffman 1 post Joined 10/15
14 Nov 2015

New to Teradata.  Thanks, Francine!

eugen.brlek 6 posts Joined 11/15
03 Dec 2015

Hello,
I have similar problem.
When I create user, and connect with Teradata Studio on newly created user, I can see all other schema/table/users, however i do not won't to see it.
An I need help...
 
1. On first image (01) you can see connection on USER "proba" 
2. On second image (02) you can see connection on USER "proba", and when I set preferences for Teradata Datatools on "Select All VX Viewes" ((you can see this options on image 03)  -> in Teradata Studio, go to meni Windows->Preferences->Teradata Datatools Preferer) the lists of other schema/user etc. is less then before, but I want only to see created USER "proba"
 
And, how to do that? Please explain to me step by step, I would be grateful :)
 
I use version of Teradata: TDExpress 15.00.02_SLES11 over VmWare Player

eugen.brlek 6 posts Joined 11/15
03 Dec 2015

Image 02

eugen.brlek 6 posts Joined 11/15
03 Dec 2015

image 03

eugen.brlek 6 posts Joined 11/15
06 Dec 2015

Anybody? Please help...

Fred 1096 posts Joined 08/04
06 Dec 2015

The "X views" will show you only things for which you have some access rights (including things granted to "PUBLIC", etc.).
If you want more restrictive filtering in Data Source Explorer, you can create your own view(s) and use the "Custom" filter option.

eugen.brlek 6 posts Joined 11/15
07 Dec 2015

Or maybe, i should use LDAP login connection mechanism, but i can't connect with Teradata Studio to Teradata DB.
How to use LDAP?

You must sign in to leave a comment.