To map or re-map a system table
Most system tables are mapped automatically during initial installation and configuration if you use the recommended system table data source name, UA_SYSTEM_TABLES. For more information, see the installation documentation. If you need to map system tables, continue with these instructions.
*
You should only map or remap system tables when no users are using Campaign.
1.
Select Settings > Campaign Settings.
The Campaign Settings page opens, presenting links for various administration tasks.
2.
In the Data Source Operations section, click Manage Table Mappings.
The Table Mappings window opens.
3.
Select Show System Tables.
4.
Select the table to map from the Unica® system table list and double-click it or click Map Table or Re-Map Table.
The Select source database and match required fields window opens.
5.
If the table is not automatically selected in the Source Table drop-down list, select it (entries are alphabetically listed by owner.table names). Source table fields in the Campaign database are automatically mapped to required fields. For system tables, you do not need to add or remove any field mappings; all field entries should be matched automatically.
*
When mapping a system table, do not select a different table from the Source Table list; you will not be able to complete the mapping. If you do this accidentally, click Cancel and select a the correct table in the Table Mappings window.
6.
Click Finish.
Copyright IBM Corporation 2012. All Rights Reserved.