Installing JDBC driver
Where and how do I create a subfolder to copy all the jar files in?
Answers
-
Alexandru Dataiker, Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 1,209 DataikerOptionsHi,
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.htmlKind Regards,
-
@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 Dataiker, Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 1,209 DataikerOptions
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.
