Installing JDBC driver

Anonymoususer

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

Alexandru

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,

mnjenga2

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

Alexandru

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.