Preparing eMessage system tables for the partition
For each partition that you create for eMessage, you must create, populate and configure the eMessage system tables that are used by the partition in the Campaign schema.
Procedure
Complete the following actions to prepare the eMessage system tables for a partition:
- Create the eMessage system tables. In your database client, run the SQL scripts for creating system tables against the Campaign database.
- Populate the tables that you created. Use the database client to run the scripts for populating tables against the Campaign database. For more information about the SQL scripts, see the reference table for script names and locations at Creating and populating the eMessage system tables manually.
- Set the following configuration properties in the eMessage
configuration for the partition, specifying the user name and platform
data source that you configured for the partition's Campaign system
user:
- eMessage > partitions > partition [n] < dataSources > systemTables > asmUserForDBCredentials
- eMessage > partitions > partition [n] < dataSources > systemTables > amDataSourceForDBCredentials
- Update the following properties in the partition's configuration
properties:
- eMessage > partitions > partition [n] < dataSources > systemTables > type
- eMessage > partitions > partition [n] < dataSources > systemTables > schemaName
- eMessage > partitions > partition [n] < dataSources > systemTables > jdbcBatchSize
- eMessage > partitions > partition [n] < dataSources > systemTables > jdbcClassName
- eMessage > partitions > partition [n] < dataSources > systemTables > jdbcURI
- Creating and populating the eMessage system tables manually
For eMessage, you must create additional system tables in the Campaign schema and then populate the tables with initial data. The Campaign installer automatically creates and populates the eMessage system tables in the Campaign schema if you select the option to create system tables automatically. However, if you do not select the option, you must create and populate the eMessage system tables manually.
Parent topic: Configuring multiple partitions in eMessage