topic Re: Not able to see tables in Metadata DB Connection in Installing and Upgrading

Not able to see tables in Metadata DB Connection

Anonymous — Tue, 23 Aug 2016 16:28:03 GMT

Good day everyone, looking forward to using this tool.
Upon creating my first MS sql connection, I am not able to see any tables under my desired db.

Any ideas what I can do.

running windows 7 64bit, connecting to ms sql 2008 server db, talend open studio for data quality 6.2.1.20160704_1411

url in connection information is :jdbc:jtds:sqlserver://TCM107:1433/;

thank you for your help.

Re: Not able to see tables in Metadata DB Connection

Anonymous — Wed, 24 Aug 2016 04:08:39 GMT

Hi,
Can you successfully connect your MS SQL DB?
Are you looking for table analyses TalendHelpCenter:Analyzing tables in databases?
Best regards
Sabrina

Re: Not able to see tables in Metadata DB Connection

_AnonymousUser — Fri, 26 Aug 2016 07:11:16 GMT

Hi,
After creating db connection under metadata repository, you will have to select retrieve schema option you get on doing a right mouse click on the connection and then select which all tables/views to be retrieved. If you have already tried this and still do not see the items, then there is some issue with the connection.

Regards,
Praveen