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.
Data source type | Script name |
---|---|
OneDB | aci_systab_ifx.sql |
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.
Data source type | Script name |
---|---|
OneDB | aci_runtab_ifx.sql |
Use the script in the following table to populate the Interact runtime tables:
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.
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:
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.
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:
Data source type | Script name |
---|---|
OneDB |
|