SQL Server 2016 doesn't return schema to Talend 6.3.1/6.4.1

Talend Version       6.3, 6.4

Summary

SQL Server doesn't return schema to Talend 6.3.1
Additional Versions  
Product Talend Data Integration
Component Studio
Problem Description

Current Behavior:

  1. Create a connection to SQL Server 2016 and create a customized schema and a table.

    In this example, the schema is Test_dinesh and has a table within it.

    User: test

    Database: dinesh1

    1.jpg

     

  2. Map the user to the Test_dinesh schema:

    2.jpg

     

  3. In Studio > Metadata, create a SQL Server connection, but do not provide any schema details, mention only the database details shown below:

    3.jpg

     

  4. Try to retrieve the schema from Studio by clicking Next. Because the Schema field is blank, you cannot see the non-system schema (Test_dinesh).

    4.jpg

     

  5. However, if you explicitly enter the schema name while creating the connection, it then displays the non-system schema as well.

    5.jpg

     

 

This means you have to create a new connection for every non-system schema (n number of creations for n number of schemas).

 

Expected behavior:

If a connection is created to SQL Server without mentioning any schema and database details, all the schemas associated with that user should be shown.

Problem root cause The behavior is a bug in the product and thus Jira ticket TUP-18804 was submitted to address the issue.
Solution or Workaround

You can resolve this issue by changing the Db Version in Metadata > Db Connections > SQL Server from Microsoft to Open Source JTDS.

6.jpg

JIRA ticket number TUP-18804
Version history
Revision #:
5 of 5
Last update:
‎09-29-2018 12:14 AM
Updated by: