Database table administration

HCL® 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 HCL 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 Campaign to make them available to flowcharts.

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

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.