You can translate the question and the replies:

python connect to denodo by using PSYCOPG2

I am getting below error port 9999 failed: server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request.
27-01-2023 10:11:14 -0500

1 Answer

Hi, I was able to connect to Denodo from python using **psycopg2**. I followed this URL pattern: denodo://<username>:<password>@<host>:<odbcport>/<database>. The default odbc port in the Denodo platform is: 9996. If you wish to make a JDBC connection from Python to Denodo, you can use the **jaydebeapi** library in Python to connect to Denodo with port 9999. For more details, you can refer to the [How to connect to Denodo from Python - a starter for Data Scientists]( Knowledge Base article. Hope this helps!
Denodo Team
27-01-2023 17:55:20 -0500
You must sign in to add an answer. If you do not have an account, you can register here