Creating the Marketing Platform data sources

Creating the Marketing Platform data sources

You must create Marketing Platform data sources before you can install Marketing Platform.

1.	Complete the following steps to prepare the data sources for Marketing Platform:

2.	Create a database or a database schema for the Marketing Platform system tables.

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

Guidelines for creating data sources
Database vendor	Guideline
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 (32k if you need to support Unicode). See the DB2® documentation for instructions.
SQL Server	Use either SQL Server authentication only, or both SQL Server and Windows™ authentication, because the 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 multi-byte characters (for example, Chinese, Korean, and Japanese), ensure that the database is created to support them.

3.	Create a system user account.

The system user account must have the following rights:

CREATE VIEWS (for reporting)

CREATE SEQUENCE (Oracle only)

4.	Configure the web application server for your JDBC driver.

5.	Create JDBC connections in the web application server.

Copyright IBM Corporation 2014. All Rights Reserved.