We are using Qlik to replicate between IBMi DB2 (source) and PostgreSQL on AWS RDS(target). We installed Qlik on our on-prem 2012 WIN server. We were able to successfully connect to our source DB but when we are trying to test the connection of the PostgreSQL on AWS RDS which is our target endpoint, we are getting the following error, we added the on-prem server’s IP address to the inbound rules of the AWS VPC on which the PostgreSQL is present but still facing the issue:
SYS-E-HTTPFAIL, Cannot connect to ODBC provider.
SYS,GENERAL_EXCEPTION,Cannot connect to ODBC provider,RetCode: SQL_ERROR SqlState: 08001 NativeError: 101 Message: root certificate file "C:\Windows\system32\config\systemprofile\AppData\Roaming/postgresql/root.crt" does not exist Either provide the file or change sslmode to disable server certificate verification.
We tried to disable the SSL certificate validation and then we are getting the following error:
SYS-E-HTTPFAIL, Cannot connect to ODBC provider.
SYS,GENERAL_EXCEPTION,Cannot connect to ODBC provider,RetCode: SQL_ERROR SqlState: 08001 NativeError: 101 Message: FATAL: no pg_hba.conf entry for host "10.179.136.15", user "v-token-pa-break-gl-9TJjzoVTJpZgaHvQ0Kwp-1666902015", database "product_definition", no encryption
We need some direction on how to resolve this issue!
