Social Networking Forum·347 discussions

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

Locked

Tags: Software

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

Reminder to all

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.

Python Pandas and SQLAlchemy

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.

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

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