COnnecting to SQL server from a Docker enabled DSS

UserBird

Hello !

I'm trying Dataiku Enterprise and trying to connect to a SQL server.

I downloaded the driver thanks to https://doc.dataiku.com/dss/latest/installation/jdbc.html

My DSS in installed in a Docker container, following this page https://www.dataiku.com/learn/guide/tips/dss-windows-docker.html

The error message I got is : " Connection failed, driver problem. This page might solve the problem.

Details: Failed to load JDBC driver (com.microsoft.sqlserver.jdbc.SQLServerDriver): com.microsoft.sqlserver.jdbc.SQLServerDriver"

Where can I add this driver to "DSS_DATADIR" please ?

Thanks for your help !

UserBird

You need to put the JDBC driver JAR in DATA_DIR/lib/jdbc. In the docker installation, this would be /home/dataiku/dss/lib/jdbc

To do that you can use the docker cp command:

docker cp jdbc.jar dss_container:/home/dataiku/dss/lib/jdbc