Creating database or schema for Unica Campaign system tables
The Unica Campaign system tables hold application data. The empty database that you set up for the system tables can have any name. To ensure that the system tables will be mapped automatically, the ODBC name for that database must be UA_SYSTEM_TABLES. If you have multiple partitions, create data sources for each partition where you want to enable Unica Campaign.
Procedure
Complete the following steps to create a database or database schema for Unica Campaign system tables:
- Create a system user account for later in the installation
process.Note: The system user account must have the following rights: CREATE, DELETE, DROP, INSERT, SELECT, and UPDATE.
- Print the Unica Campaign installation worksheet. Obtain the information about your database
or schema and database account, and then note this information in
the checklist. Continue to fill in the checklist as you perform the
rest of the steps in this section, so that you can use this information
later in the installation process.Note: The IBM eMessage system tables are created in the Unica Campaign schema during the installation. However, IBM eMessage is not enabled.