DocumentationExperience PlatformSource Connectors Guide

PostgreSQL

Last update: April 29, 2025
  • Topics:
  • Sources

CREATED FOR:

  • Developer

Read this document to learn about prerequisite steps that you need to complete before you can connect your PostgreSQL database to Adobe Experience Platform.

Prerequisites

Read the following sections to complete the prerequisite setup before you connect your PostgreSQL database to Experience Platform.

IP address allowlist

You must add region-specific IP addresses to your allowlist prior to connecting your sources to Experience Platform on either Azure or Amazon Web Services (AWS). For more information, read the guide on allowlisting IP addresses to connect to Experience Platform on Azure and AWS for more information.

Authenticate to Experience Platform on Azure

You must provide values for the following authentication credentials to connect PostgreSQL to Experience Platform on Azure.

Account key authentication

Provide values for the following credentials to connect your PostgreSQL database to Experience Platform on Azure using account key authentication.

Credential
Description
connectionString
The connection string associated with your PostgreSQL account. The PostgreSQL connection string pattern is: Server={SERVER};Database={DATABASE};Port={PORT};UID={USERNAME};Password={PASSWORD}.
connectionSpec.id
The connection specification returns a source’s connector properties, including authentication specifications related to creating the base and source connections. The connection specification ID for PostgreSQL is 74a1c565-4e59-48d7-9d67-7c03b8a13137.

Read the PostgreSQL documentation for more information.

Basic authentication

Provide values for the following credentials to connect your PostgreSQL database to Experience Platform on Azure using basic authentication.

Credential
Description
server
The name or IP address of your PostgreSQL database.
port
The TCP port of your PostgreSQL server.
username
The username associated with your PostgreSQL database authentication.
password
The password associated with your PostgreSQL database authentication.
database
The name of the PostgreSQL database that you want to connect to.
sslMode

The Secure Sockets Layer (SSL) method to be applied to your connection. The available values are:

  • Disable: Use this option to disable SSL. If your server requires an SSL configuration, then the connection will fail.
  • Allow: Use this option to allow SSL connections. Non-SSL connections may still be used if the server supports them.
  • Prefer: Use this option to prefer SSL connections given that the server supports them. This option also allows for non-SSL connections.
  • Require: Use this option to make SSL connections mandatory. If the server does not support SSL, then the connections will fail.
  • Verify-Ca: Use this option to verify server certificates while failing connections if the server does not support SSL.
  • Verify-Full: Use this option to verify server certificates with the host’s name while failing connections if the server does not support SSL.

Read the PostgreSQL documentation for more information.

Authenticate to Experience Platform on Amazon Web Services (AWS)

AVAILABILITY
This section applies to implementations of Experience Platform running on Amazon Web Services (AWS). Experience Platform running on AWS is currently available to a limited number of customers. To learn more about the supported Experience Platform infrastructure, see the Experience Platform multi-cloud overview.

Provide values for the following credentials to connect your PostgreSQL database to Experience Platform on AWS using basic authentication.

Credential
Description
server
The name or IP address of your PostgreSQL database.
port
The TCP port of your PostgreSQL server.
username
The username associated with your PostgreSQL database authentication.
password
The password associated with your PostgreSQL database authentication.
database
The name of the PostgreSQL database that you want to connect to.
sslMode

The Secure Sockets Layer (SSL) method to be applied to your connection. The available values are:

  • Disable: Use this option to disable SSL. If your server requires an SSL configuration, then the connection will fail.
  • Allow: Use this option to allow SSL connections. Non-SSL connections may still be used if the server supports them.
  • Prefer: Use this option to prefer SSL connections given that the server supports them. This option also allows for non-SSL connections.
  • Require: Use this option to make SSL connections mandatory. If the server does not support SSL, then the connections will fail.
  • Verify-Ca: Use this option to verify server certificates while failing connections if the server does not support SSL.
  • Verify-Full: Use this option to verify server certificates with the host’s name while failing connections if the server does not support SSL.

Read the PostgreSQL documentation for more information.

Connect PostgreSQL to Experience Platform using APIs

  • Create a PostgreSQL base connection using the Flow Service API
  • Explore data tables using the Flow Service API
  • Create a dataflow for a database source using the Flow Service API

Connect PostgreSQL to Experience Platform using the UI

  • Create a PostgreSQL source connection in the UI
  • Create a dataflow for a database source connection in the UI
recommendation-more-help
337b99bb-92fb-42ae-b6b7-c7042161d089