Creating databases or schemas

Set up data sources so that the Interact 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 Interact:

Create a database or a database schema for the Interact system tables.

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

Guidelines for creating databases or schemas
Database vendor	Guidelines
Oracle	Enable the auto commit feature for the environment open. See the Oracle documentation for instructions.
DB2®	Set the database page size to at least 16K, or 32K if you need to support Unicode. See the DB2® documentation for instructions.
SQL Server	Use either the SQL Server authentication, or both the SQL Server and Windows™ authentication, because Marketing Platform requires SQL Server authentication. If necessary, change the database configuration so that your database authentication includes SQL Server. Also, be sure that TCP/IP is enabled in your SQL Server.

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 Interact installation worksheet. You can use this information later in the installation process.

Required databases or schemas for Interact