Task 3: Map the IBM® Campaign system tables to the database tables
After creating the physical database tables for each new audience level and the audience levels in Campaign, you must map the IBM® Campaign system tables to these database tables.
You can map user tables to your created audience levels without mapping the IBM® Campaign system tables to database tables, but you will not be able to log contact and response history without mapping the Contact History, Detailed Contact History, and Response History tables.
IBM® recommends that you map segment membership system tables to physical database tables only for audiences used in Campaign flowcharts or Contact Optimization sessions that contain strategic segments. Using strategic segments in Campaign and Contact Optimization is optional.
1.
Select Settings > Campaign Settings.
The Campaign Settings page appears.
2.
On the Campaign Settings page, under Data Source Operations, click Manage Audience Levels.
The Audience Levels window opens, displaying existing audience levels.
3.
Select the audience level for which you are mapping database tables, and click History Tables.
4.
On the Table Mappings window, select each IBM® Campaign system table and click Map Table.
5.
On the table mapping window, select the database table corresponding to the IBM® Campaign system table for that audience level. The Source Table Fields list is populated with the fields from the database table you selected. The Required Fields list is populated with Selected Fields (from your source database table) and the corresponding Required Fields (from the IBM® Campaign system table).
*
Fields can only be mapped if Campaign finds an exact match for the field names.
6.
Click Next to specify mapping for any custom fields in your database tables.
7.
Click Next to specify display names for custom fields. This option is not available for all tables.
8.
Click Finish to complete the mapping. Repeat this procedure for each required IBM® Campaign system table for the audience level.
*
You can also perform this task from the Manage Table Mappings link on the Campaign Settings page.
Copyright IBM Corporation 2015. All Rights Reserved.