Creating the Marketing Platform data sources

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

Procedure

Complete the following steps to prepare the data sources for Marketing Platform:
  1. Create a database or a database schema for the Marketing Platform system tables.
    The following table provides information about vendor-specific guidelines for creating a database or a database schema for the Marketing Platform system tables.
    Table 1. Guidelines for creating data sources

    This two-columned table provides information about the database vendor in one column, and the guidelines in the second column.
    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.
    Note: 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.
  2. Create a system user account.
    The system user account must have the following rights:
    • CREATE TABLES
    • CREATE VIEWS (for reporting)
    • CREATE SEQUENCE (Oracle only)
    • CREATE INDICES
    • ALTER TABLE
    • INSERT
    • UPDATE
    • DELETE
  3. Create ODBC or native connections.
  4. Configure the web application server for your JDBC driver.
  5. Create JDBC connections in the web application server.