MySQL database connection

amungase · July 2020

Hi

I am trying to make database connection with MySQL in Dataiku. I have downloaded driver as well but i am using trial/web based version so where exactly I will need to put (which path) my JDBC driver. Is there any option in connection settings to provide driver path? As i am getting error-

Failed to load database driver: Failed to load JDBC driver (com.mysql.jdbc.Driver), caused by: ClassNotFoundException: com.mysql.jdbc.Driver

ATsao · July 2020

Hi Amungase,

If you are referring to the hosted trial, then this is indeed not possible as the hosted trial is a bit limited and only provides access to "out-of-the-box" capabilities. If you wish to use the MySQL connector, or any other of our customers that require a driver to be dropped in, you will need to install DSS locally. You can use either the free Community edition or we also provide a 2-week Enterprise trial license if you are interested. More information can be found in our webpage here:

https://www.dataiku.com/product/get-started/

Thanks,

Andrew

Liev · July 2020

Hi @amungase

You can see a step by step guide here

After you've followed this, you should be able to configure your MySQL connection under Administration.

For more info on MySQL see this section of the docs.

I hope this helps

amungase · July 2020

Thanks for the response.

i dont have Data Science Studio installed but i am using web trail version instead, so where can i put my driver?

amungase · July 2020

Thanks, was able to make connection with free edition.

Sarissa · September 2020

I am having this issue. I just upgraded to DSS 8.0. I have previously installed 7.x on another machine successfully.

I am using ODBC version 8.0.21, rather than version 8.0.19 that worked for version 7.x. Is there a configuration issue using 8.0.21?

ATsao · September 2020

Hi Sarissa,

DSS only supports using JDBC, not ODBC. For more information about setting up a MySQL connection in DSS, please refer to our connector documentation here:

https://doc.dataiku.com/dss/latest/connecting/sql/mysql.html

Thanks,

Andrew

Sarissa · September 2020

So, my issue was a Java problem. Once I download the MySQL-Connector-Java-8.0.21, my Java installation could not find it. Hence the "Failed to load database driver" error. I had to unzip the files from Oracle and drop them into my Java library manually. Here are the steps:

Copy the JDBC .jar file you downloaded to either the system-wide Java Extensions folder (/Library/Java/Extensions) or your user Java Extensions folder (/Users/username/Library/Java/Extensions).
Add the directory containing the JDBC .jar file to the CLASSPATH environment variable (see Modifying the Java CLASSPATH).
Specify the directory containing the JDBC .jar using the -cp argument in the Java command line you use to start your Java command line.

I didn't need the last two steps...it worked just dragging the files into the right place.

Cost me a couple of days. Here's to you not having to fight that battle!

Sarissa · September 2020

FYI, this was the fix for Mac OS Catalina.

Kjeanclaude · November 2021

Thank you very much, the first step worked for me too (after a couple of days too).

Copy the driver’s JAR file (and its dependencies, if any) to the DATA_DIR/lib/jdbc folder

It is now in the documentation : https://doc.dataiku.com/dss/latest/installation/custom/jdbc.html

MySQL database connection

Best Answer

Answers

Categories

Setup Info

Tags