Skip to main content


How to Connect SQL Server with Talend tool.

Istock 935964092

Step-by-step on How to connect MS SQL Server to Talend Open Studio Using Windows Authentication.

  1. Download the jtds-SQL server JDBC driver from jTDS – SQL Server and Sybase JDBC driver download |, It will download in the form of a zip file; unzip it with the help of 7-zip.
  2. Copy jtds-1.3.1.jar to the ‘plugins’ of the Talend folder.                                                                                                                1st   2nd
  3. Based on your CPU architecture, copy ntlmauth.dll from x64/SSO OR x86/SSO OR IA64/SSO folder to <JDK_HOME>/bin folder.3rd
  4. Copy these DLL file into the below location                                                                  4th
  5. After doing this, open [SQL server 2019 configuration manager] 5th
  6. Next, Open the SQL server network configuration manager and set all the statuses to enable. 6th
  7. Right-click on TCP/IP properties and copy the TCP port Number.7th
  8. And left click on SQL server (SQL 19DEV) and click on the restart, as shown below.8th
  9. Now open Talend and click on metadata and create a new Db connection in that, select DB type as Microsoft SQL server and Db version as Open source JTDS.

9thAfter that, specify your SQL server login and password, the server name as localhost, Port number, Database, and schema, and hit on the test connection.10th You have successfully connected the MS SQL Server with the Talend Open Studio!

Happy Learning!


Thoughts on “How to Connect SQL Server with Talend tool.”

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Prathamesh Wanjari

Prathamesh work as an Associate technical consultant at Perficient in the Nagpur GDC, India. He's working in the data solutions team and have a firm knowledge of Azure data factory, Azure databricks, and Azure synapse analytics.

More from this Author

Follow Us