SQL server connection not allowing to choose schema

Highlighted
Six Stars

SQL server connection not allowing to choose schema

Hi, I am able to connect to MS SQL Server database installed at a remote location, but while making a connection, although 'Check' connection gives a success message, but the 'Next' button is still disabled and I am not able to select any Schema or Tables to work upon.

Kindly suggest.

sqlserver.jpg


Accepted Solutions
Highlighted
Six Stars

Re: SQL server connection not allowing to choose schema

Ya I did. But that was not the issue. Actually I realized that we can do a Retrieve schema by right click on the new connection just formed. So, the issue stands resolved for me.

Thanks.

View solution in original post


All Replies
Highlighted
Seven Stars

Re: SQL server connection not allowing to choose schema

Did you notice the scrollbar in the connection parameters?

-----------------------------------------------------------------------------------------------------------
When you like my answer, please accept it as solution and send some kudos
Highlighted
Six Stars

Re: SQL server connection not allowing to choose schema

Ya I did. But that was not the issue. Actually I realized that we can do a Retrieve schema by right click on the new connection just formed. So, the issue stands resolved for me.

Thanks.

View solution in original post

Highlighted
Moderator

Re: SQL server connection not allowing to choose schema

Hi,

Here is online document about:TalendHelpCenter:Retrieving table schemas

Hope it will be helpful for you.

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog