Connecting to odbc

mk
mk Partner, Registered Posts: 1 Partner
in Setup & Configuration

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.

· Share on FacebookShare on Twitter

Answers

  • Turribeach
    Turribeach Dataiku DSS Core Designer, Neuron, Dataiku DSS Adv Designer, Registered, Neuron 2023 Posts: 2,160 Neuron

    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

    · Share on FacebookShare on Twitter
Bookmark this topic

Categories

Setup Info
    Tags
      Help me…