Expand my Community achievements bar.

SOLVED

SSL enabled PostgresSQL source connector confg

Avatar

Level 2

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?

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

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

View solution in original post

2 Replies

Avatar

Correct answer by
Community Advisor

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

Avatar

Administrator

@_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.