Community Conundrum 28: News Engagement is live! Read More

How to access DATA_DIR to add MySQL drivers

Level 1
How to access DATA_DIR to add MySQL drivers
I am trying to establish a connection to a MySQL server which I understand requires that I update the drivers (according to the documentation). I have downloaded the drivers and found the related.jar file, but I cannot for the life of me figure out how to "Copy the driver’s JAR file (and its dependencies, if any) to the DATA_DIR/lib/jdbc folder." I have searched the internet and this forum and have not found anything that has worked so far.

I have tried the following command in my Windows Terminal:

scp -P 2222 dataiku@localhost:/DATA_DIR/lib/JDBC

and I get an error saying "/DATA_DIR/lib/JDBC: No such file or directory"

Any help pointing me in the right direction will be much appreciated.
0 Kudos
2 Replies

"DATA_DIR" is a placeholder that needs to be replaced by the path where Dataiku is installed. You will be able to find this path by going to Administration > Maintenance > System info: "Data directory"

Then replace that in your scp command. For example if your "Data directory" is /home/dataiku/data, you'll want to use:

scp -P 2222 dataiku@localhost:/home/dataiku/data/lib/jdbc

beware, it must be "jdbc" not "JDBC" - Paths on Linux are case sensitive.

Afterwards, you'll need to restart DSS by actually going on the machine:

ssh -P 2222 dataiku@localhost
cd /home/dataiku/data
./bin/dss restart

Hope this helps,
Level 1
Thank you very much for clearingthat up! That solved my problem.
0 Kudos
Labels (2)
A banner prompting to get Dataiku DSS