Running database scripts to enable Interact features

To use the optional features that are available in 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 of the optional features, run the appropriate script against the database or table that is indicated.

dbType is the database type, such as sqlsvr for Microsoft™ SQL Server, ora for Oracle, or db2 for HCL® DB2®.

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)	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 Interact Reports Pack.