Documentation Campaign Campaign Classic v7 Documentation

Configure access to PostgreSQL

Last update: April 11, 2024

Use Campaign Federated Data Access (FDA) option to process information stored in an external PostgreSQL database.

PostgreSQL configuration

You first need to install Libpq. Libpq allows client programs to send queries to the PostgreSQL backend server and to receive these queries’ results.

Follow the steps below to configure access to PostgreSQL:

For CentOS, execute the following command sudo apt-get -y install libpq-dev.
For Linux, execute the following command yum install postgresql-devel.
For Windows, Libpq is implemented through libpq.dll which is included in Adobe Campaign installation.

In Adobe Campaign, you can then configure your PostgreSQL external account. For more on how to configure your external account, refer to this section.

PostgreSQL external account

NOTE

PostgreSQL is available on CentOS 7 and 6.

You need to create a PostgreSQL external account to connect your Campaign instance to your PostgreSQL external database.

From Campaign Explorer, click Administration ‘>’ Platform ‘>’ External accounts.
Click New.
Select External database as your external account’s Type.
Under Configuration, select PostgreSQL, Greenplum from the Type drop-down.
Configure the PostgreSQL external account authentication:
- Server: URL of the PostgreSQL server.
- Account: Name of the user.
- Password: User account password.
- Database: Name of the database (optional).
- Working schema: Name of your working schema. Learn more
- Timezone: Timezone set in PostgreSQL. Learn more
Click the Parameters tab then the Deploy functions button to create functions.

NOTE
For all functions to be available, you need to create the Adobe Campaign SQL functions in the remote database. For more information, refer to this page.
Click Save when your configuration is finished.

The connector supports the following options:

Option

Description

PGSQL_CONNECT_TIMEOUT

Maximum wait for connection, in seconds.
For more on this, refer to PostgreSQL documentation.

PGSQL_KEEPALIVES_IDLE

Number of seconds of inactivity after which the TCP should send a keepalive message to the server.
For more on this, refer to PostgreSQL documentation.

PGSQL_KEEPALIVES_INTVL

Number of seconds after which the TCP keepalive message not acknowledged by the server should be retransmitted.
For more on this, refer to PostgreSQL documentation.

PGSQL_KEEPALIVES_CNT

Number of TCP keepalives that can be lost before the client’s connection to the server is considered dead.
For more on this, refer to PostgreSQL documentation.

recommendation-more-help