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

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

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