Integrating Dataiku with Denodo
Has anyone created an integration with Denodo? If so, did you use a JDBC connection? How did you manage user permissions?
Thanks!
Operating system used: Red Hat
Answers
-
Sergey Dataiker, Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS Core Concepts, Registered Posts: 365 DataikerHi @VickeyC
Yes, you should be able to connect to Denodo with the connection type "Other SQL databases". The driver should be "com.denodo.vdp.jdbc.Driver". You will need to upload the corresponding JDBC driver to DSS_DATA_DIR/lib/jdbc directory:
https://doc.dataiku.com/dss/latest/installation/custom/jdbc.html
-
Do we still need to connect through other SQL Databases or is there any dedicated connector for Denodo integration?
I am using Linux Server hosted in Azure.
-
Sarina Dataiker, Dataiku DSS Core Designer, Dataiku DSS Adv Designer, Registered Posts: 319 DataikerHi @Venkata Durga Sai Krishna, indeed the above is still accurate and you'll use the "Other SQL databases" connection to connect to Denodo.
