Mapping the translation table

Mapping the translation table is how you make Digital Analytics segment data accessible in Campaign. The table mapping identifies the data source, the translation table name and location, the table fields, audience levels, and data for Campaign to use.

Before mapping the table, you must configure the translation table, configure integration settings, and assign credentials to a Marketing Platform account. For instructions, see Integrating IBM Digital Analytics and Campaign.

This task is typically performed by IT or other technical personnel when the Digital Analytics-Campaign integration is initially configured. However, tables can be mapped or remapped by any user with appropriate permissions, at any time.

Confirm that Campaign is configured properly to access the necessary user tables: See Testing user table access.

Map the translation table by following the instructions and guidelines in User table administration tasks.

To summarize: You map a new base record table to make data accessible to processes in flowcharts. You can map (create) a new base record table when editing a flowchart (using Admin > Tables) or by selecting Settings > Campaign Settings > Manage Table Mappings.

Save the mapping information in a table catalog for reuse. This way, the table mapping needs to be done only once, and Campaign users who want to include Digital Analytics segments can load the saved catalog to get the mapping information directly. If you want the information to be available for use in all flowcharts, store it in the default catalog (default.cat). See Table catalog administrative tasks.

Whenever 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 using Digital Analytics segments will return an error at run time indicating that the table schema has changed.

When you map or remap a table, the IBM® Campaign Table Name assigned in the Table Definition wizard must exactly match the TranslationTableName defined in the Campaign configuration settings (see Campaign | partitions | partition[n] | Coremetrics). If you do not edit the table name when using the Table Definition wizard, the names will match.