Database table administration

Unica Campaign administrators must perform initial one-time tasks and routine administration tasks that pertain to database tables.

There are two main types of database tables:
  • System tables contain Unica Campaign application data.
  • User tables contain customer data for use in marketing campaign flowcharts.

Most administration tasks pertain to user tables, because system table setup is typically handled by the installation process.

User tables must be mapped in Unica Campaign to make them available to flowcharts.

To efficiently manage mapped user tables, you can set up table catalogs.

Unica Campaign can also make use of customer data that is stored in flat files. Data dictionaries define the structure of user tables that are based on flat files.