Creating the Marketing Operations system table database or schema

Create the Marketing Operations system table database or schema with the help of your database administrator. After you create the database, complete the data source information worksheet for future reference.

Complete the following steps to create Marketing Operations system tables database or schema:

Work with a database administrator to create the required database for Marketing Operations.

Have the database administrator create an account for you to specify for a system user later in the installation process.

This account must have CREATE, SELECT, INSERT, UPDATE, DELETE, and DROP rights for both tables and views, as appropriate. In addition:

The database must use UTF-8 encoding.

If you are using SQL Server, ensure that TCP/IP is enabled.

If you are using DB2®, ensure that the buffer pool for the table space is at least 32K.

Print and complete the Marketing Operations data source information worksheet. You use the information later in the installation process.

IBM DB2 database tablespaces

Configuring the web application server for your JDBC driver

Creating the JDBC connections in the web application server