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:
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. |