Creating and populating the Unica Interact system tables

Use your database client to run the Unica Interact SQL scripts against the OneDB database or to create and populate the Unica Interact runtime environment, design time environment, learning, user profile, and contact and response tracking data sources.

Design time environment tables

Before you can enable the Unica Interact design time environment, you must add some tables to your Interact system table database.

The SQL scripts are in the INTERACT_HOME/interactDT/ddl directory under your Interact design time environment installation.

If your Interact system tables are configured for Unicode, use the appropriate script that is in the INTERACT_HOME/interactDT/ddl directory in your Interact design time environment. There are no Unicode equivalent scripts for the aci_populate_systab scripts that are used to populate the design time environment tables.

Use the script in the following table to create the Unica Interact design time environment tables:

Table 1. Script for creating design time environment tables
This two-columned table provides information about the data source type in one column, and the script name in the second column.
Data source type	Script name
OneDB	aci_systab_ifx.sql

Use the script in the following table to populate the Interact design time environment tables:

Table 2. Script for populating design time environment tables
This two-columned table provides information about the data source type in one column, and the script name in the second column.
Data source type	Script name
OneDB	aci_populate_systab_ifx.sql

Runtime environment tables

The SQL script is in the <INTERACT_HOME>/ddl directory under your Interact installation.

If your Interact runtime tables are configured for Unicode, use the appropriate script that is in the <INTERACT_HOME>/ddl/Unicode directory to create the runtime tables. There are no Unicode equivalent scripts for the aci_populate_runtab scripts that are used to populate the runtime tables.

You must run the SQL script once for each server group data source.

Use the script in the following table to create the Interact runtime tables:

Table 3. Script for creating runtime environment tables
This two-columned table provides information about the data source type in one column, and the script name in the second column.
Data source type	Script name
OneDB	aci_runtab_ifx.sql

Use the script in the following table to populate the Interact runtime tables:

Table 4. Script for populating runtime environment tables
This two-columned table provides information about the data source type in one column, and the script name in the second column.
Data source type	Script name
OneDB	aci_populate_runtab_ifx.sql

Learning tables

You can use SQL scripts to create and populate tables for optional features such as learning, global offers, score override, and contact and response history tracking.

All the SQL scripts are in the <Interact_HOME>/ddl directory.

Note: The built-in learning module requires a separate data source from the Interact runtime environment tables. For the built-in learning module, you must create a data source to hold all the learning data. The separate data source can communicate with all server groups, which means you can learn from your different touchpoints at the same time.

If your Interact runtime tables are configured for Unicode, use the appropriate script that is in the <Interact_HOME>/ddl/Unicode directory to create the learning tables.

Use the scripts in the following table to create the Interact learning tables:

Table 5. Script for creating learning tables
This two-columned table provides information about the data source type in one column, and the script name in the second column.
Data source type	Script name
OneDB	aci_lrntab_ifx.sql

Contact and response history tables

You must run SQL scripts against the contact history tables if you want to use cross-session response tracking or the advanced learning feature.

All the SQL scripts are in the Interact installation directory.

Note: Using contact and response history features requires a separate data source from the Interact runtime environment tables. To use the contact and response history features, you must create a data source to reference contact and response data. The separate data source can communicate with all server groups.

If your contact history tables are configured for Unicode, use the appropriate script that is in the Unicode directory under the same location as the standard script to create the learning tables.

Use the script in the following table to create the Interact contact and response history tables:

Table 6. Script for creating contact history tables
This two-columned table provides information about the data source type in one column, and the script name in the second column.
Data source type	Script name
OneDB	aci_crhtab_ifx.sql in the <Interact_Home>/ddl/ directory. aci_lrnfeature_ifx.sql in the <Interact_Home>/interactDT/ddl directory.