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:
- Create the Unica Deliver system
tables.
In your database client, run the SQL scripts for creating system
tables against the Unica Campaign database.
- Populate the tables that you created.
- 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.
- 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.