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 IBM Campaign 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. The empty database that you set up for IBM Campaign can have any name. 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. If you use UA_SYSTEM_TABLES as the ODBC name for that database, the IBM Campaign system tables will be mapped automatically.
- 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. This enables your web application to connect to the system tables. The location of the JAR file must be included in 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 Vertica datasources for Campaign
Follow these guidelines to use a Vertica database 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 - Preparing Cloudera Hadoop Impala based user data sources for Campaign
Follow the steps below to enable Impala based Cloudera Hadoop data sources to be used in IBM Campaign
Parent topic: IBM Campaign Installation Guide