Question Locked

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

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
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?

3 replies

by birdmantd edited

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

by smmstrategysociall edited

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.

by Johnharper2020

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

This discussion is closed to new replies.