Check out the first Dataiku 8 Deep Dive focusing on Productivity on October 29th Read More

ODBC connection creation

Level 2
Level 2
ODBC connection creation

Hi,

 

We want to create connection using ODBC, Could you please let me know the process for ODBC connections.

 

Thanks.

0 Kudos
2 Replies
Dataiker
Dataiker

Hi,

DSS currently does not support connecting via ODBC right now, only JDBC. Notably, it's important to note that ODBC is primarily used as a connector in a Windows environment, while DSS is Linux-only so it doesn't make much sense to use ODBC through DSS. With that being said, if ODBC is a requirement, there are 3rd party packages and modules out there, such as pyodbc, which would allow you to create your own ODBC connection through Python directly. 

Could you clarify if there's a certain type of database that you're trying to connect to using ODBC where JDBC is not an option (or a JDBC driver isn't available)? 

Best,

Andrew

0 Kudos
Level 7

@sudheer_kumar 

You do not say what database you actually need to connect with.  ODBC is a MS Windows way to connect to a variety of databases.  Dataiku running on Linux and Macintosh OS X is using JDBC drivers to connect to databases.

You may find this documentation about connecting to databases to be helpful.

https://doc.dataiku.com/dss/latest/connecting/sql.html

 

--Tom
0 Kudos