Required databases or schemas for Collaborate

The Unica Interact runtimeOpportunity Detect Design Time environment requires several databases to hold user and interaction data. You can use your Unica Campaign Customer (user) tables or set up a unique data source.

The Collaborate design time environment tables are manually created by running the scripts to the database or schema that holds the Unica Campaign system tables.

According to the type of data that must be stored, determine how many databases or schemas you must create for use with the Collaborate runtime environment.

In Interact setup, Interact design time tables database or schema is shared across all the server groups defined within that setup.

The following list provides a brief summary of the databases or schemas that are required for the Collaborate runtime environment:
  • Database or schema to hold the Collaborate runtime tables. There must be a separate database or schema for each server group.
  • Database, schema, or view to hold the user profile tables. The user profile tables can be in the same database as your Unica Campaign Customer (user) tables. There can be a separate set of user profile tables for each interactive channel.
  • Database, schema, or view to hold the test run tables. The test run tables can be in the same database as your Unica Campaign Customer (user) tables.
  • If you want to use built-in learning, there must be a database or schema to hold the learning tables.
  • If you want to use cross-session response tracking, there must be a database or schema to hold a copy of the Unica Campaign contact history tables. Alternatively, instead of creating a copy, you can use the Unica Campaign system tables database to run the cross-session response tracking scripts.