Mapping tables for Unica Optimize

You can exchange data between Unica Optimize and Unica Campaign by mapping the Unica Optimize system tables, contact history tables, and segment membership tables to the Unica Campaign tables.

About this task

Note: Mapping the segment membership system tables in Unica Campaign for use with strategic segments is optional. Map the segment membership system table for an audience only if you use the audience with flowcharts or Unica Optimize sessions that use strategic segments.

For more information about mapping system tables in Unica Campaign, see the Unica Campaign Administrator's Guide.

Complete the following steps to map tables for Unica Optimize:

Procedure

  1. Map all system tables.
  2. Map all contact history tables.

    Confirm that each audience level in your Unica Campaign configuration has a contact history table. You must map each contact history table. For more information about additional contact history tables, see the Unica Campaign Administrator's Guide.

  3. Optional: For each audience used in Unica Optimize sessions that use strategic segments, map the segment membership system table for the audience to the database table that defines the segment members.

    Requirements when you use strategic segments:

    If you plan to use strategic segments, ensure that there is a segment membership table for each audience level in your Unica Campaign configuration. You must map each segment membership table.

    Create two indexes on the audience segment membership tables. Create the first index on SegmentID and create the second on the audience level columns. The UA_SegMembership table ships with an index on CustomerID and on SegmentID.

    For more information about system tables and strategic segments, see the Unica Campaign Administrator's Guide.