TechRepublic|Forums|Social Networking

Social Networking

Question

  • Creator
    Topic
  • March 9, 2022 at 6:46 am #3951669

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

    Locked

    by sachinputra88 · about 1 year, 2 months ago

    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?

    Topic is locked This conversation is currently closed to new comments.
  • Creator
    Topic

All Answers

  • Author
    Replies
    • March 9, 2022 at 6:29 pm #3951814
      Avatar photo

      Reminder to all

      by birdmantd · about 1 year, 2 months ago

      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.

    • March 16, 2022 at 9:24 am #3955178

      Python Pandas and SQLAlchemy

      by smmstrategysociall · about 1 year, 2 months ago

      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.

    • December 13, 2022 at 6:19 am #4013332

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

      by Johnharper2020 · about 5 months, 3 weeks ago

      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

  • Author
    Replies
Viewing 2 reply threads