Running database scripts to enable Marketing PlatformCampaignDistributed MarketingeMessageContact OptimizationInteractLeadsOpportunity DetectDigital Analytics for On PremisesCustomerInsightPredictiveInsightMarketing OperationsInteraction HistoryAttribution ModelerIBM SPSS Modeler Advantage Enterprise Marketing Management Edition features

To use the optional features that are available in Marketing PlatformCampaignDistributed MarketingeMessageContact OptimizationInteractLeadsOpportunity DetectDigital Analytics for On PremisesCustomerInsightPredictiveInsightMarketing OperationsInteraction HistoryAttribution ModelerIBM ®SPSS® Modeler Advantage Enterprise Marketing Management Edition, run database scripts against the database to create tables or update existing tables.

Your Marketing PlatformCampaignDistributed MarketingeMessageContact OptimizationInteractLeadsOpportunity DetectDigital Analytics for On PremisesCustomerInsightPredictiveInsightMarketing OperationsInteraction HistoryAttribution ModelerIBM SPSS Modeler Advantage Enterprise Marketing Management Edition 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 Marketing PlatformCampaignDistributed MarketingeMessageContact OptimizationInteractLeadsOpportunity DetectDigital Analytics for On PremisesCustomerInsightPredictiveInsightMarketing OperationsInteraction HistoryAttribution ModelerIBM SPSS Modeler Advantage Enterprise Marketing Management Edition Reports Pack.