Microsoft SQL connection Jaspersoft ETL Community

[gone away]

Microsoft SQL connection Jaspersoft ETL Community

and now ?

Credentials are fine in SSMS.....

 

 

 

[gone away]

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-for-sql-server 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.

[hozawa]

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-MS-SQL-Server-component/td-p/1364

[gone away]

hozawa