Try your hand at analyzing royal sentiment in Dataiku DSS! Learn more

COnnecting to SQL server from a Docker enabled DSS

Dataiker
Dataiker
COnnecting to SQL server from a Docker enabled DSS

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 !

0 Kudos
1 Reply
Dataiker
Dataiker
Author
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
0 Kudos