Creating databases or schemas

Set up data sources so that the Opportunity Detection system can store user and interaction data. You can use your Campaign Customer (user) tables or set up unique data sources based on the type of data that is stored.

Complete the following steps to create databases or schemas for Opportunity Detection:

Create a database and a database schema for the Opportunity Detection system tables.

The following table provides information about vendor-specific guidelines while creating a database or a database schema for the Opportunity Detection system tables:

Guidelines for creating databases or schemas
Database vendor	Guidelines
DB2®	Set the database page size to at least 16K, or 32K if you need to support Unicode. See the DB2® documentation for instructions.

If you plan to enable locales that use locales that use multi-byte characters, such as Chinese, Korean, and Japanese, ensure that the database is created to support them.

Create a system user account.

The account that you create must have at least CREATE, SELECT, INSERT, UPDATE, DELETE, and DROP rights.

Obtain information about your databases or schemas and database accounts and then print and add the information to the Opportunity Detection installation worksheet. You can use this information later in the installation process.

Required databases or schemas for Opportunity Detection