New MSSQL DB table not visible

Eight Stars

New MSSQL DB table not visible

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?


Accepted Solutions
Thirteen Stars

Re: New MSSQL DB table not visible

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

Untitled.png

 

 

 

 

Manohar B

All Replies
Thirteen Stars

Re: New MSSQL DB table not visible

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

Untitled.png

 

 

 

 

Manohar B
Eight Stars

Re: New MSSQL DB table not visible

Thanks Manohar. It worked.

Eight Stars

Re: New MSSQL DB table not visible

Awesome table name though in your example :-D

Thirteen Stars

Re: New MSSQL DB table not visible

@samisyed80,please provide Kudos also Smiley Happy

Manohar B
Eight Stars

Re: New MSSQL DB table not visible

Yes, i did now. Thanks again

Thirteen Stars

Re: New MSSQL DB table not visible

your Welcome.

Manohar B

Tutorial

Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.