Using Postgres datasources with Unica Campaign

Unica Campaign supports Postgres as System and user tables. The Postgres database connection with Unica Campaign is supported with unixODBC and Postgres ODBC Connector. Users must install unixODBC and Postgres ODBC Connector on Unica Campaign Analytical server (listener) machine.
Note: For information on supported versions, see the Recommended Software Environments and Minimum System Requirements document.

Postgres Server On Linux

To create database in Postgres DB use below command:

CREATE DATABASE <your_db_name>;

CREATE USER <your_user_name> WITH PASSWORD <your_user_password>;

Set the following parameters in Postgres configuration (postgresql.conf) file for Platform and Campaign.

  • max_connections: set this value to 1000
    Note: While running application if there is error Campaign Server: loadFolderDetailItemsByEntity: Database connection error (Error Code = 11518). Please increase the value of parameter max_connections as per application usage.

Postgres server on Windows:

To create database in Postgres DB use below command:

CREATE DATABASE <your_db_name>;

CREATE USER <your_user_name> WITH PASSWORD <your_user_password>;

Set the following parameters in Postgres configuration (postgresql.conf) file for Platform and Campaign.
  • max_connections: set this value to 1000
    Note: While running application if there is error Campaign Server: loadFolderDetailItemsByEntity: Database connection error (Error Code = 11518). Please increase the value of parameter max_connections as per application usage.