Welcome to the new Schneider Electric Community

It's your place to connect with experts and peers, get continuous support, and share knowledge.

  • Explore the new navigation for even easier access to your community.
  • Bookmark and use our new, easy-to-remember address (community.se.com).
  • Get ready for more content and an improved experience.

Contact SchneiderCommunity.Support@se.com if you have any questions.

Close
Invite a Co-worker
Send a co-worker an invite to the Exchange portal.Just enter their email address and we’ll connect them to register. After joining, they will belong to the same company.
Send Invite Cancel
84315members
353475posts

ETL & SQL MS server

EcoStruxure IT forum

A support forum for Data Center Operation, Data Center Expert, and EcoStruxure IT product users to share knowledge on installation, configuration, and general product use.

DCIM_Support
Picard
Picard
0 Likes
10
475

ETL & SQL MS server

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

(CID:130099956)

10 Replies 10
DCIM_Support
Picard
Picard
0 Likes
0
475

Re: ETL & SQL MS server

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

(CID:130099963)

DCIM_Support
Picard
Picard
0 Likes
0
475

Re: ETL & SQL MS server

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.

(CID:130099971)

DCIM_Support
Picard
Picard
0 Likes
6
475

Re: ETL & SQL MS server

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. 

(CID:130680716)

DCIM_Support
Picard
Picard
0 Likes
0
475

Re: ETL & SQL MS server

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.

(CID:130682464)

DCIM_Support
Picard
Picard
0 Likes
0
475

Re: ETL & SQL MS server

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.

(CID:130682455)

DCIM_Support
Picard
Picard
0 Likes
0
475

Re: ETL & SQL MS server

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.

(CID:130682467)

DCIM_Support
Picard
Picard
0 Likes
0
475

Re: ETL & SQL MS server

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.

(CID:130682460)

DCIM_Support
Picard
Picard
0 Likes
0
475

Re: ETL & SQL MS server

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

 

(CID:130682450)

DCIM_Support
Picard
Picard
0 Likes
0
475

Re: ETL & SQL MS server

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.

 

(CID:130682446)

DCIM_Support
Picard
Picard
0 Likes
0
475

🔒 Closed

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