Microsoft SQL connection Jaspersoft ETL Community
and now ?
Credentials are fine in SSMS.....
3 Answers:
JaspersoftETL / ETL, please correct me if i'm wrong here, doesn't come with a MS SQL server connection installed, well not a working one. so download a JDBC driver from MS web page: https://docs.microsoft.com/en-us/sql/connect/jdbc/microsoft-jdbc-driver-... Recommended to install as a sub-dir of the Program Files folder.
Open Talend and show the "Modules" view, hidden by default ! nice ,one of the icons says, Import external jars, click that and navigate to the .jar file. Rename the file to what Talend expects i.e. mssql-jdbc.jar add new connection selecting db type = Microsoft Sql server and db version = Microsoft (this is in Talend Open Studio Data Integration 6.4..... ) In JaspersoftETL the db version seems to be missing....
As a noobie, just to get a SQL data connection, this is Ridiculous, much easier in Haskell,R or anything else. And I still cant quite accept a your use of the term "URL" being synonymous with "connection string" for a JDBC connection. Will apologize if this offends and if *you* post the link to the document that officially explains how this works? I wont hold my breath.
There's a video on how to setup a MSSQL connection. Jaspersoft ETL is just Talend Open Studio.
https://www.youtube.com/watch?v=jZq1kAafGV0
There may be several reasons for the error. Try checking the following thread to see if any one would solve your problem.
https://community.talend.com/t5/Design-and-Development/Connection-with-M...
Many thanks Hozawa
But my answer above solves my problem in connecting, possibly this could do with the fact that my server is Microsoft SQL server 2008.
But it would be nice to get confirmation, in fact I have a few Cloud based SQL MS SQL databases (2012+) so I will try connecting to them with the default Talend connector.
hozawa
