Step: Create the Interact user profile tables

Some optional features in Interact, such as global offers, offer suppression, and score override, require specific tables in your user profile databases. Refer to the IBM® Interact Administrator's Guide for details about the profile database, and the role that the offer suppression, global offers, and score override tables play in offer serving.

Use your database client to run the appropriate SQL scripts against the appropriate database or schema and create these required user tables. If you have more than one audience level defined, you need to create one of each required table for each audience level.

User profile tables

The following table lists the SQL scripts you must use to create the following optional profile tables:

Global offers table (UACI_DefaultOffers)

Offer suppression table (UACI_BlackList)

Score override table (UACI_ScoreOverride)

The SQL scripts are located in the ddl directory under your Interact installation.

You must run these scripts once per audience level. Modify the script for each different audience level (after the first) and rename the profile tables created after running the scripts.

Scripts for creating user profile tables
Data source type	Script name
IBM® DB2®	aci_usrtab_db2.sql
Microsoft™ SQL Server	aci_usrtab_sqlsvr.sql
Oracle	aci_usrtab_ora.sql

Advanced scoring (optional)

The following tables list the SQL scripts you must run if you are using the advanced scoring feature to override the Interact learning algorithm.

All of the SQL scripts are located in the ddl/acifeatures directory under your Interact installation.

If your scoring tables are configured for Unicode, use the appropriate script located in the ddl/acifeatures/Unicode directory under your Interact installation to create the learning tables.

Note that these scripts are intended to be run against the User Profile database.

Scoring table scripts
Data source type	Script name
IBM® DB2®	aci_scoringfeature_db2.sql
Microsoft™ SQL Server	aci_scoringfeature_sqlsvr.sql
Oracle	aci_scoringfeature_ora.sql

Running database scripts to enable Interact features