Connecting to odbc

mk
mk Partner, Registered Posts: 1 Partner

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.

Answers

  • Turribeach
    Turribeach Dataiku DSS Core Designer, Neuron, Dataiku DSS Adv Designer, Registered, Neuron 2023 Posts: 1,973 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

Setup Info
    Tags
      Help me…