Discover this year's submissions to the Dataiku Frontrunner Awards and give kudos to your favorite use cases and success stories!READ MORE

Connecting to odbc

mk
Level 1
Level 1
Connecting to odbc

There is no option to connect with ODBC , we have seen that need to connect with PYODBC in python script. tried with that and still facing issue with connection through python. When I tried with local Jupyter notebook it is working when I tried with DSS Dataiku Notebook I'm unable to make a connection. And the connection is with TALLY Prime software. Can anyone help with it.

0 Kudos
1 Reply
Turribeach
Level 6

In order to use pyodbc you need to have ODBC drivers for the OS where you are running pyodbc. Most ODBC drivers are written for Windows rather than Linux where DSS runs. DSS is Java based so it supports JDBC drivers natively. If your desired data source (ie TALLY Prime) does not provide JDBC drivers then you will need to find ODBC drivers which can run under Linux. CDATA sells such drivers:

https://www.cdata.com/kb/tech/tally-odbc-python-linux.rst

 

0 Kudos