Join us at the Everyday AI Conference in London, New York & Bengaluru! REGISTER NOW

Installing JDBC driver

Anonymoususer
Level 1
Installing JDBC driver

Where and how do I create a subfolder to copy all the jar files in? 

0 Kudos
3 Replies
AlexT
Dataiker
Dataiker

Hi,

Can you confirm which free version you are using? Are you using the Dataiku Online trial or the installed free version of DSS?

For installed DSS:

To add JDBC drivers you can add them to your DATADIR/lib/jdbc and you must stop and start DSS please see :

https://doc.dataiku.com/dss/latest/installation/custom/jdbc.html

For Dataiku Online supported database connections have the drivers pre-installed please see :
https://knowledge.dataiku.com/latest/kb/dku-online/data-connection.html

Kind Regards,

0 Kudos
mnjenga2
Level 1

@AlexT am trying to connect to an Oarcle db with installed dss.
I have ojdbc11.jar in /DATA_DIR/lib/jdbc/ 
and I have restarted dss but when I try to create connection I get below error.

Failed to load database driver

Failed to load JDBC driver (oracle.jdbc.OracleDriver), caused by: ClassNotFoundException: oracle.jdbc.OracleDriver.

Am I missing out a step?
Thanks.
0 Kudos
AlexT
Dataiker
Dataiker

The steps are those but you either used the wrong Oracle driver version not the JDK version, try using JDK8 drivers  instead

https://download.oracle.com/otn-pub/otn_software/jdbc/215/ojdbc8.jar

And performing the same steps another possibility is the permissions on the uploaded jar don't allow the DSS user to read the driver. 

0 Kudos