You can translate the question and the replies:

SQLAlchemy Denodo Connection Issues

Hi there, I am trying to use sqlalchemy with denodo but I am running into a few issues. I have the dialect added as per the instructions from your sqlalchemy dialects page, and I can parse the connection string it seems. However, whenever I create a connection it just hangs: ``` engine = create_engine("denodo://{username}:{password}@{host}:9999/{database}") conn = engine.connect() ``` it seems to just freeze when it reaches the assignment of the conn variable. Any code after trying to assign the conn variable just doesn't run and I have to kill the python process. I am using SQLAlchemy-1.3.20 as the newest version of sqlalchemy does not accept the denodo dialect (it says it cannot find it). Any ideas?
17-03-2022 09:40:40 -0400

2 Answers

Never mind, I was using the JDBC port instead of the ODBC port. Working now!
17-03-2022 09:56:15 -0400
Hi, I’m glad that you were able to establish the connection ! Please refer to [Denodo dialect with SQLAlchemy]( if you need more information on this topic. Hope this helps!
Denodo Team
21-03-2022 08:04:19 -0400
You must sign in to add an answer. If you do not have an account, you can register here