MSSQL JDBC driver on Talend 8

[User2655868928318021]

I recently installed Talend Open Studio v 8. It seems to miss jdbc driver for mssql. How/where am I supposed to get it?

I already installed sqljdbc_6,

sqljdbc_7, and sqljdbc_9, but still have issues connecting to SQL Server database.

Please note that Talend 8 only works with Java 11.

Thanks,

[Anonymous · Accepted solution]

@Cyrus Leghvan​ What's error are you getting? Does it work with JTDS driver? (this driver jar is available for downloading and installing from studio)

First, make sure you are able to access the port 1433 by running the telnet command from CMD, eg:

>telnet localhost 1433

I have tried to install Microsoft driver and tested the connection, it works well. Below are the steps what I have done:

1 Download mssql-jdbc-9.5.0.jre11-preview. jar (I have Java 11 installation on my machine) from this page.

2 Rename mssql-jdbc-9.5.0.jre11-preview. jar to mssql-jdbc.jar.

3 Open the component tab of tMSSQLInput and click the 'install..' button to install the required jars, browse mssql-jdbc.jar from local file system.

4 Run the job to test the connection.

If you have installed several Microsoft drivers, I would suggest you to remove all of them, and install only one driver jar again. To remove the driver jars, open <studio installation directory>\configuration\.m2\repository\org\talend\libraries and delete the mssql-jdbc folder, then, restart studio.

Regards

Shong

[User2655868928318021]

Thanks a lot Shong! I got it to work.

[Anonymous]

Great, thanks for your feedback!