Social Networking Forum

Question

  • Creator
    Topic
  • #3951669

    How can I connect to Denodo using Python Pandas and SQLAlchemy?

    Locked

    by sachinputra88 ·

    Tags: 

    I’m trying to connect to Denodo using Python SQLAlchemy, and create a DataFrame from a table. My environment is Cloudera Data Science Workbench. Can I use psycopg2 and the PostgreSQL connection string?

All Answers

  • Author
    Replies
    • #3951814
      Avatar photo

      Reminder to all

      by birdmantd ·

      In reply to How can I connect to Denodo using Python Pandas and SQLAlchemy?

      Feel to discuss applications/programs, but leave out all product links as they will be removed as SPAM by the forum moderators.

    • #3955178

      Python Pandas and SQLAlchemy

      by smmstrategysociall ·

      In reply to How can I connect to Denodo using Python Pandas and SQLAlchemy?

      Download Pyodbc library that is compatible with the Python version.
      Add it to the Python interpreter.
      Go to the folder <DENODO_HOME>/tools/client-drivers/odbc and unzip the appropriate ODBC driver.
      Configure DSN using Denodo ODBC driver.
      Use this code to connect to Python to Denodo Platform. cnxn = pyodbc.

    • #4013332

      Reply To: How can I connect to Denodo using Python Pandas and SQLAlchemy?

      by Johnharper2020 ·

      In reply to How can I connect to Denodo using Python Pandas and SQLAlchemy?

      To connect to the Denodo Platform from Python using the JDBC drivers, you can utilize the Python library like jaydebeapi. The relevant parameters such as JDBC driver, username, password can be put into the function connect() to make the connection work.

      Hope this helps,
      John

Viewing 2 reply threads