Mapping the translation table

Map a translation table to make IBM Digital Analytics segments accessible in Unica Campaign. The table mapping identifies essential information such as the data source, table name and fields, and audience levels.

Before you begin

Before mapping a translation table, you must create and populate the table. For a complete list of tasks, see Integrating IBM Digital Analytics and Unica Campaign.

About this task

Mapping a new base record table makes data accessible to processes in flowcharts. The instructions below explain how to map a new base record table for global use. You can also map a new base record table when you edit a flowchart, by using Admin > Tables.

Procedure

  1. Select Settings > Unica Campaign Settings > Manage table mappings.
  2. Optional: Save the mapping information in a table catalog for reuse. To make the information available for use in all flowcharts, store it in the default catalog (default.cat). Unica Campaign users can load the saved catalog to get the mappings.

    For details, see Table catalog administration.

  3. If there is a change to the physical table (for example, if columns are added or deleted), you must remap the table. If you do not remap the table, flowcharts that use IBM Digital Analytics segments will return an error at run time indicating that the table schema has changed.
    Important: When you map or remap a table, the Unica Campaign Table name that is assigned in the Table Definition wizard must exactly match the TranslationTableName that is defined in the Unica Campaign configuration settings. If you do not edit the table name when using the Table Definition wizard, the names will match. See Campaign | partitions | partition[n] | Coremetrics).

What to do next

Complete the remaining steps that are described in the topic Integrating IBM Digital Analytics and Unica Campaign.