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.

When you create your databases, you should use the same code page for all of your databases. You cannot change this code page once it is set. If you did not create your databases to use the same code page, you must use only the characters supported in the code page. For example, if you create a zone in global offers that does not use a character in the profile database code page, the global offer does not work.

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 HCL® 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:

Table 1. Scripts for creating user profile tables

This two-columned table provides information about the data source type in one column, and the script name in the second column.

Data source type Script name

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

Table 2. Scripts for creating advanced scoring tables

This two-columned table provides information about the data source type in one column, and the script name in the second column.

Data source type Script name

HCL DB2

aci_scoringfeature_db2.sql

Microsoft SQL Server

aci_scoringfeature_sqlsvr.sql

Oracle

aci_scoringfeature_ora.sql