Task 3: Map the Unica 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 Unica system tables to these database tables.
You can map user tables to your created audience levels without mapping the Unica 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 Optimize sessions that contain strategic segments. Using strategic segments in Campaign and Optimize 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 Unica system table and click Map Table.
5.
On the table mapping window, select the database table corresponding to the Unica 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 Unica 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 Unica 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 2012. All Rights Reserved.