topic New MSSQL DB table not visible in Talend Studio

New MSSQL DB table not visible

Anonymous — Wed, 16 May 2018 06:52:23 GMT

I have created a new table in MSSQL DB, and need to use that table in output. When i checked the "Metadata --> DB Connections --> Table Schema" the new table is not visible.

I don't see the refresh button also.

How can i pull the new table created inside talend?

Re: New MSSQL DB table not visible

manodwhb — Wed, 16 May 2018 07:14:46 GMT

@samisyed80,Right click on the My_Sql connection -->Retrieve Shema -->Next and select the table which you want and click next and Finish.

Re: New MSSQL DB table not visible

Anonymous — Wed, 16 May 2018 07:34:52 GMT

Thanks Manohar. It worked.

Re: New MSSQL DB table not visible

Anonymous — Wed, 16 May 2018 07:35:40 GMT

Awesome table name though in your example 😄

Re: New MSSQL DB table not visible

manodwhb — Wed, 16 May 2018 07:41:26 GMT

@samisyed80,please provide Kudos also

Re: New MSSQL DB table not visible

Anonymous — Wed, 16 May 2018 07:45:33 GMT

Yes, i did now. Thanks again

Re: New MSSQL DB table not visible

manodwhb — Wed, 16 May 2018 07:56:32 GMT

your Welcome.