Mapping the translation table

Map a translation table to make IBM® Digital Analytics segments accessible in HCL® 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 HCL Digital Analytics and 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 > Campaign Settings > Manage table mappings.

    For details, see Mapping and unmapping user tables.

  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). 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 HCL Campaign Table name that is assigned in the Table Definition wizard must exactly match the TranslationTableName that is defined in the HCL 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 HCL Digital Analytics and Campaign.