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?
Solved! Go to Solution.
Topics help categorize Community content and increase your ability to discover relevant content.
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
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
@_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.
Views
Replies
Total Likes
Views
Likes
Replies