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
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:
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?
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:
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:
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!