Preparing data sources for Unica Campaign

The Unica Optimize runtime environment uses data sources to store user and interaction data.

About this task

Note: Information about using web application clustering in Unica Campaign is provided in Unica Campaign web application clustering.

Complete the following steps to prepare data sources for Unica Optimize.

Procedure

  1. Create a database or a database schema for the Unica Optimize system tables. The empty database that you set up for Unica Campaign can have any name.
    Note: Unica Campaign requires customer tables, which should already exist.
  2. Create a database user account.

    The database user account must have the following rights: CREATE, DELETE, DROP, INSERT, SELECT, and UPDATE.

  3. Create ODBC or native connections. If you use UA_SYSTEM_TABLES as the ODBC name for that database, the Unica Campaign system tables will be mapped automatically.
  4. Configure the web application server for your JDBC driver.
  5. Create JDBC data sources in the web application server.