One Star

tMSSQLInput - Missing mssql-jdbc.jar

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
5 REPLIES
Employee

Re: tMSSQLInput - Missing mssql-jdbc.jar

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
One Star

Re: tMSSQLInput - Missing mssql-jdbc.jar

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

Re: tMSSQLInput - Missing mssql-jdbc.jar

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

It did. 
One Star

Re: tMSSQLInput - Missing mssql-jdbc.jar

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?
One Star

Re: tMSSQLInput - Missing mssql-jdbc.jar

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.