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
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
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?
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.
