Running database scripts to enable Unica Interact features

To use the optional features that are available in Unica Interact, run database scripts against the database to create tables or update existing tables.

Your Interact installation, both the design time environment and runtime environment, includes feature ddl scripts. The ddl scripts add required columns to your tables.

To enable any one of the optional features, run the appropriate script against the database or table which is indicated.

dbType is the database type, such as sqlsvr for Microsoft SQL Server, ora for Oracle, db2 for DB2® , and MariaDB for MariaDB database.

Use the following table to run database scripts against the database to create tables or update existing tables:

Table 1. Database scripts

This four-columned table provides information about the feature names in the first column, feature scripts in the second column, details about running the database scripts in the third column, and the changes in the tables in the fourth column.

Feature Name Feature Script Run Against Change

Global offers, offer suppression, and score override

aci_usrtab_dbType.sql in Interact_Home\ddl\acifeatures\ (Runtime environment installation directory)

Your profile database (userProdDataSource)

Creates the UACI_DefaultOffers, UACI_BlackList, and UACI_ScoreOverride tables.

Scoring

aci_scoringfeature_dbType.sql in Interact_Home\ddl\acifeatures\ (Runtime environment installation directory)

Score override tables in your profile database (userProdDataSource)

Adds the LikelihoodScore and AdjExploreScore columns.

Learning

aci_lrnfeature_dbType.sql in Interact_Home\interactDT\ddl\acifeatures\ (Design time environment installation directory)

Unica Campaign database that contains your contact history tables

Adds the columns RTSelectionMethod, RTLearningMode, and RTLearningModelID to the UA_DtlContactHist table. Also adds the columns RTLearningMode and RTLearningModelID to the UA_ResponseHistory table. This script is also required by the reporting features provided by the optional Reports Pack.