ETL & SQL MS server

DCIM_Support · ‎2020-07-04

This question was originally posted on DCIM Support by Ali Chams on 2018-04-27

Hi, I'm trying to connect an ETL transformation to an SQL server, and I've got the following error:

Driver sun.jdbc.odbc.JdbcOdbcDriver in not installed. Please note that I'm using Java 8, any suggest solution for this problem?

Thanks

DCIM_Support · ‎2020-07-04

This comment was originally posted on DCIM Support by Greg Sterling on 2018-04-27

Hello Ali. There are some details regarding the driver you need to place on the DCO server and the settings for SQL server here:

ETL export to MS SQL Server

Regards

Greg Sterling

DCIM_Support · ‎2020-07-04

This comment was originally posted on DCIM Support by Ali Chams on 2018-04-27

HI Greg,

Thanks for your quick answer...

I think the problem comes from Java 8, since Oracle has removed this feature, and I got the error event when I tried to test my transformation from spoon...

Cheers.

DCIM_Support · ‎2020-07-04

This answer was originally posted on DCIM Support by Morten Harboe on 2018-04-30

Hi Ali,

You are right about that Odbc drivers are no longer supported from Java 8. Without knowing your setup or what you are trying to achieve I would recommend switching over to JDBC drivers instead as that is the supported way of connecting to MS SQL server.

DCIM_Support · ‎2020-07-04

This comment was originally posted on DCIM Support by Ali Chams on 2018-04-30

HI Morten,

Thanks for your answer...

Well, I'm trying to import data from MS SQL DB to DCO, and we have not succeed to establish the connection with the DB.. I will try with JDBC drivers and let you know.. I do really appreciate if have any recommendation..

Have a great day.

Ali.

DCIM_Support · ‎2020-07-04

This comment was originally posted on DCIM Support by Morten Harboe on 2018-04-30

Hi Ali,

This is how I would connect to the MS SQL database through pentaho. The values are placeholders for the transformation/job parameters and will be replaced under execution if these are specified.

DCIM_Support · ‎2020-07-04

This comment was originally posted on DCIM Support by Ali Chams on 2018-04-30

Hi Morten,

Ok, I will try and let you know...

Cheers.

DCIM_Support · ‎2020-07-04

This comment was originally posted on DCIM Support by Ali Chams on 2018-04-30

Hi,

I've just realised a test, and I'still not having the right driver, since I had this message from spoon :

Error connecting to database (using class net.sourceforge.jtds.jdbc.Driver...

Any idea ?

Cheers.

DCIM_Support · ‎2020-07-04

This comment was originally posted on DCIM Support by Morten Harboe on 2018-05-01

Hi Ali,

I can see that you use the jtds dirvers and not the Microsft jdbc ones. I am not sure which Pentaho version you are working with. But since 7.0 jtds drivers was removed from Pentaho. So you will need to add them yourself before you can connect.

Here is some information about connecting to Microsoft SQL Server from the Pentaho community wiki - https://wiki.pentaho.com/display/EAI/MS+SQL+Server

Here is a Pentaho issue with the same error as yours. It is described in the link where to place the jtds drivers if you decide to go with them. - https://jira.pentaho.com/browse/PDI-15787

My suggestion is that you use the official Microsoft JDBC drivers.

Regards,

Morten Harboe

DCIM_Support · ‎2020-07-04

This comment was originally posted on DCIM Support by Ali Chams on 2018-05-01

Hi Morten,

Thanks for your great help..

I will test the driver and let you know..

Cheers.

DCIM_Support · ‎2020-07-04

This question is closed for comments. You're welcome to start a new topic if you have further comments on this issue.