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?