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.
user
27-01-2023 10:11:14 -0500
code

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](https://community.denodo.com/kb/en/view/document/How%20to%20connect%20to%20Denodo%20from%20Python%20-%20a%20starter%20for%20Data%20Scientists#h.rh1em13ag15s) Knowledge Base article. Hope this helps!
Denodo Team
27-01-2023 17:55:20 -0500
code
You must sign in to add an answer. If you do not have an account, you can register here