Configuring access to local Deliver system tables

Unica Deliver requires access to the Deliver system tables in the Campaign schema. To allow Unica Deliver components to access system tables in the Campaign schema without requesting a manual database login, you must specify an Deliver system user to provide the necessary database access credentials.

About this task

The system user that accesses the database is associated with an Unica Platform data source that contains the login credentials for the database that hosts the Campaign schema.

For more information about system table configuration properties, see Deliver | partitions | partition[n] | dataSources | systemTables.

Procedure

  1. Specify the system user that you defined in the Unica Platform. Edit the following configuration property.

    Deliver > partitions > partition [n] < dataSources > systemTables > asmUserForDBCredentials

  2. Specify the login credentials for the database that contains the Campaign schema and Deliver system tables. Edit the following configuration property.

    Deliver > partitions > partition [n] < dataSources > systemTables > amDataSourceForDBCredentials