Microsoft SQL connection Jaspersoft ETL Community

0

Microsoft SQL connection Jaspersoft ETL Community

and now ?

Credentials are fine in SSMS.....

 

 

 

gone away's picture
Joined: Sep 9 2016 - 4:28am
Last seen: 1 month 1 week ago

3 Answers:

0

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.

gone away's picture
Joined: Sep 9 2016 - 4:28am
Last seen: 1 month 1 week ago
0

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

hozawa's picture
14206
Joined: Apr 24 2010 - 4:31pm
Last seen: 10 hours 51 min ago
0

 

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


gone away's picture
Joined: Sep 9 2016 - 4:28am
Last seen: 1 month 1 week ago
Feedback
randomness