Preparing Unica Deliver system tables for the partition

For each partition that you create for Unica Deliver, you must create, populate and configure the Unica Deliver system tables that are used by the partition in the Unica Campaign schema.

Procedure

Complete the following actions to prepare the Unica Deliver system tables for a partition:
  1. Create the Unica Deliver system tables.
    In your database client, run the SQL scripts for creating system tables against the Unica Campaign database.
  2. Populate the tables that you created.
    Use the database client to run the scripts for populating tables against the Unica Campaign database. For more information about the SQL scripts, see the reference table for script names and locations at Creating and populating the Unica Deliver system tables manually.
  3. Set the following configuration properties in the Deliver configuration for the partition, specifying the user name and platform data source that you configured for the partition's Unica Campaign system user:
    • Deliver > partitions > partition [n] < dataSources > systemTables > asmUserForDBCredentials
    • Deliver > partitions > partition [n] < dataSources > systemTables > amDataSourceForDBCredentials
    Unica Deliver accesses the partition's system tables through a system user configured in Unica Platform. A Unica Platform data source added to the system user provides the required access credentials. Because the Unica Deliver system tables exist in the Unica Campaign schema for the partition, you can use the system user that you created to access the Unica Campaign schema to access the partition's Unica Deliver system tables.
  4. Update the following properties in the partition's configuration properties:
    • Deliver > partitions > partition [n] < dataSources > systemTables > type
    • Deliver > partitions > partition [n] < dataSources > systemTables > schemaName
    • Deliver > partitions > partition [n] < dataSources > systemTables > jdbcBatchSize
    • Deliver > partitions > partition [n] < dataSources > systemTables > jdbcClassName
    • Deliver > partitions > partition [n] < dataSources > systemTables > jdbcURI
    See the Unica Platform online help for each property to learn more about setting the configuration properties. For additional information about these configuration properties and configuring Unica Deliver, see the Unica Deliver Startup and Administrator's Guide.