topic Re: tMSSQLInput - Missing mssql-jdbc.jar in Talend Studio

tMSSQLInput - Missing mssql-jdbc.jar

Anonymous — Wed, 16 Nov 2016 17:08:55 GMT

Hi All,
I have been banging my head against the wall in regards to finding, downloading and placing the external .jar files in the correct directories to get this component working. I can connect to my MSSQL server and the Output component is successfully extracting data from SFDC and creating tables in SQL.
All I seem to come across is a list of Talend help modules - which do not point you to where you can download the correct one.
Can someone please help me by providing a link and a few instructions as to how and where the .jar should exist.
Thank you.
Chris

Re: tMSSQLInput - Missing mssql-jdbc.jar

Anonymous — Wed, 16 Nov 2016 18:15:59 GMT

Hi,
The mssql-jdbc dependency comes because you have selected the new JDBC Provider as Microsoft in your tMSSQL component / Wizard.
Some external 3rd party libraries can not be downloaded automatically and that's the case here: it's a proprietary driver.
You can download it from : https://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=11774
I personally chose enu\sqljdbc_6.0.7728.100_enu.tar.gz
This will download a tar.gz archive, which contains 4 different drivers in the enu folder
Rename sqljdbc42.jar to mssql-jdbc.jar
Then, to install it in Talend Studio, the simplest solution is : Window -> Show View -> Talend -> Modules -> Click the white bottle / jar and pick-up mssql-jdbc.jar on your hard drive.
Hope this helps

Re: tMSSQLInput - Missing mssql-jdbc.jar

Anonymous — Thu, 17 Nov 2016 10:18:40 GMT

Hi,
Thank you very much for replying so quickly and with such easy, comprehensive instructions. It has been resolved!
Cheers,
Chris

Re: tMSSQLInput - Missing mssql-jdbc.jar

_AnonymousUser — Sun, 04 Dec 2016 13:28:15 GMT

Rename sqljdbc42.jar to mssql-jdbc.jar
Hope this helps

It did.

Re: tMSSQLInput - Missing mssql-jdbc.jar

CRTtech — Sun, 04 Dec 2016 13:32:09 GMT

Rename sqljdbc42.jar to mssql-jdbc.jar
Hope this helps

It did! I couldn't figure out why the install window never went away.
But I am still getting the ClassNotFoundException.
I read someplace about CLASSPATH but it's in my environment variables now and still doesn't locate.
Thoughts?

Re: tMSSQLInput - Missing mssql-jdbc.jar

dgreenx — Fri, 13 Jan 2017 21:16:29 GMT

Anyone know if the sqljdbc42.jar is able to connect with MS SQL Server 2016 and merge data into a table with ColumnStore index? Just wondering if anyone has tried that yet.

Re: tMSSQLInput - Missing mssql-jdbc.jar

Anonymous — Wed, 15 Aug 2018 15:55:01 GMT

This worked immediately, however I had to do it again today once I restarted Talend. Should this be permanent?