Creating Interact user profile tables

Some features of Interact, such as global offers, offer suppression, and score override, require specific tables in your user profile databases. Run SQL scripts to create the required user tables.

Use your database client to run the appropriate SQL scripts against the appropriate database or schema and create the required user tables. If you have multiple audience levels defined, you must create a table for each audience level.

For more information about the profile database, and the role that offer suppression, global offers, and score override tables play in offer serving, see the IBM® Interact Administrator's Guide.

User profile tables

You must use SQL scripts 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 in the ddl directory under your Interact installation.

You must run the SQL scripts once for every audience level. Modify the script for each audience level, after the first, and rename the profile tables that are created after you run the scripts.

Use the scripts in the following table to create the Interact user profile tables:

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)

For Interact built-in learning, you can use the advanced scoring feature to override components of the Interact learning algorithm.

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

If your scoring tables are configured for Unicode, use the appropriate script in the ddl/acifeatures/Unicode directory under your Interact installation to create the learning tables. You must run the SQL scripts against the User Profile database.

Use the scripts in the following table to create the Interact scoring tables:

Scripts for creating advanced scoring tables
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