SSL enabled PostgresSQL source connector confg

[_abs9900]

Hello,

We have a requirement to create postgreSQL database source connector, and postgres allows only SSL connections.

I've used connection string in below format:

Server={*********};Database={postgres};Port={5432};UID={postgres};Password={*******};EncryptionMethod=1;ValidateServerCertificate=0

Connection is failing with this string.

AEP IP's are added to allowed network list.

Query: Is there any other step that we have to follow to create a Encryption enabled connection?

Also, which is the correct connection string format to use if we have an SSL enabled postgres source?

[BryanRek · Accepted solution]

To connect you must specify ssl mode in the driver connecting to the Adobe PostGres connnection.

To connect DBVisualizer with Adobe Experience Platform, you must enable the use of SSL. See the SSL modes documentation to learn about SSL support for third-party connections to Adobe Experience Platform Query Service, and how to connect using verify-full SSL mode.

https://experienceleague.adobe.com/docs/experience-platform/query/clients/dbvisulaizer.html?lang=en

[NimashaJain]

@_abs9900 Did you find the suggestion solution helpful? It would be great if you can  mark the answer as correct for posterity. If you have found out solution yourself, share it with wider audience in the community.