Preparing data sources for Campaign
Campaign uses data sources to store user and interaction data.
About this task
Note: Information about using web application clustering in
IBM®
Campaign is provided in Web application clustering.
Complete the following steps to prepare data sources for Campaign.
Procedure
- Create a database or a database schema for the Campaign system tables. Note: Campaign requires customer tables, which should already exist.
- Create a database user account.
The database user account must have the following rights: CREATE, DELETE, DROP, INSERT, SELECT, and UPDATE.
- Create ODBC or native connections.
- Configure the web application server for your JDBC driver.
- Create JDBC data sources in the web application server.
- Creating database or schema for Campaign system tables
The IBM Campaign system tables hold application data. The empty database that you set up for the system tables can have any name. To ensure that the system tables will be mapped automatically, the ODBC name for that database must be UA_SYSTEM_TABLES. If you have multiple partitions, create data sources for each partition where you want to enable IBM Campaign. - Creating ODBC or native connections
Create ODBC or native connections so that the Campaign server can access the Campaign database. Create ODBC or native connections on the computer where you installed the Campaign server. - Configuring the web application server for your JDBC driver
The web application server where you plan to deploy Campaign must contain the correct JAR file to support JDBC connections. You must add the location of the JAR file to the class path of the web application server. - Creating JDBC connections in web application server
Create JDBC connections on each of the web application servers where Campaign is deployed. Campaign uses the JDBC connections to access the required databases. - Preparing DB2 on z/OS user datasources for Campaign
Follow these guidelines to use a DB2® database on z/OS® as a data source for Campaign. - Preparing Amazon Redshift user data sources for Campaign
Follow these guidelines to use Amazon Redshift as a data source for Campaign. - Preparing Apache Hadoop Hive user data sources for Campaign
Follow the steps below to enable Hive-based Apache Hadoop data sources to be used in IBM Campaign
Parent topic: IBM Campaign Installation Guide