topic Re: MSSQL JDBC driver on Talend 8 in Installing and Upgrading

MSSQL JDBC driver on Talend 8

User2655868928318021 — Fri, 15 Nov 2024 23:26:12 GMT

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,

Re: MSSQL JDBC driver on Talend 8

Anonymous — Wed, 08 Dec 2021 06:24:01 GMT

@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

Re: MSSQL JDBC driver on Talend 8

User2655868928318021 — Fri, 10 Dec 2021 01:16:07 GMT

Thanks a lot Shong! I got it to work.

Re: MSSQL JDBC driver on Talend 8

Anonymous — Fri, 10 Dec 2021 04:32:22 GMT

Great, thanks for your feedback!