Configuring access to local Deliver system tables

Deliver components must be able to access the Deliver system tables in the Campaign schema. You must create and configure a system user that can access the system tables automatically. The system user that was configured during the installation of Campaign already has the necessary access to the Campaign schema.

About this task

Note: If your installation contains multiple partitions, you must complete this task for each partition. You cannot share system users across partitions.

If you want to use a different system user to access the Deliver system tables, you must create a new system user in the Platform and create new platform data source with access to the Campaign schema.

Procedure

  1. In the Deliver configuration, specify a system user that accesses the database that hosts the Campaign schema.

    You can create a new user or specify an existing user. The system user that you set up for Campaign already has access to the Campaign schema.

    Use the configuration property Deliver > partitions > partition [n] < dataSources > systemTables > asmUserForDBCredentials.

    By default the specified user is asm_admin.

  2. In the Deliver configuration, specify the data source that is configured to contain the user name and password that is required to access the database that hosts the Campaign schema.

    You can use the data source that was created to access the Campaign schema when you installed Campaign.

    Use the configuration property Deliver > partitions > partition [n] < dataSources > systemTables > amDataSourceForDBCredentials.