Hi,
I have server, database, username and password for postgreSQL DB.
with pgAdmin no issue it connects immediatelly. (no additional settings)
In TX I tried CData ADO.NET Provider for PostreSQL 2022 (tried 2018 also, same result)
Set SSL False - got error no encryption
Set SSL True - [500] System error: server certificate verification failed. Connection aborted.
should I need any additional configuration, maybe different provider, any ideas?
thanks in advance,
Jakub
+5Hi
There are three ways of connecting to PostgreSQL.
CData has been discontinued.
For ODBC you need to install a PostgreSQL ODBC provider and add it to the Ingest server, like I have done here.
Then in the setup you just point at the DSN name and it should have access.
OleDB seems to be the same.
Azure Data Factory requires just that. If you host PostgreSQL on a server you are required to install a Integration Runtime on it to gain access. If your PostgreSQL server is created in Azure, this isn’t needed.
Here is my ADF setup.
+8Hi,
this error: "Set SSL True - [500] System error: server certificate verification failed. Connection aborted.” seems to indicate you may not have “trust server certificate” set to true or installed the certificate that identifies your Postgres server on your client machine.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
