Few days ago, I worked on the implementation of setting up IBM Unica Campaign with DB2 on AIX platform. For user tables I used data source of Oracle database by installing Oracle client and data source of DB2 by DB2 Runtime Client. In this activity, I also setup Cognos BI Server and integrated IBM Unica components on it. IBM Unica is running on IBM WebSphere. I documented all steps to make it a detailed installation guide.
Following are table of contents extracted from guide.
- Preparing AIX Platform
- Setting up DB2 Server
- Installing DB2
- Creating Users, Buffer pool & Table Spaces
- Create DB Users of IBM Unica Platform and Campaign on AIX
- Installing IBM WebSphere Application Server
- Create IBM WebSphere Server Profile
- Configuring IBM WebSphere Application Server for Unica Deployment
- Adding Application Server Custom Property
- Creating JDBC Provider for DB2
- Creating Data Source for IBM Unica Platform
- Create Data Source for IBM Unica Campaign
- Setting Heap Size of WebSphere
- Installing IBM Unica Platform
- Deploying IBM Unica Platform on WebSphere
- Installing IBM Unica Campaign
- Deploying IBM Unica Campaign on WebSphere
- Configuring Campaign Server on AIX
- Configuring Campaign after Deployment
- Set up Campaign System User
- Settings for Configuration page of Unica
- Map System Tables in Campaign
- Configuring Reports in IBM Unica Platform
- Installing Oracle Client 11g for Oracle Data Sources in IBM Unica Campaign
- Creating Group and User for Oracle Client Installation
- Create Oracle Base Directory
- Login Oracle User and Configure Environment
- Install Oracle Client
- Creating Oracle Data Source in IBM WebSphere Application Server
- Creating Oracle Data Source in IBM Unica Platform
- Installing DB2 Runtime Client for DB2 Data Sources in IBM Unica Campaign
- Adding DB2 Data Source in db2cli.ini
- Installing IBM Cognos BI 10.2
- Prerequisites and Checklist
- Installing Java 6 on AIX
- Installing HTTP Server & Configuring for Cognos
- Setting up IBM Cognos BI 10.2 System
- Configuring Cognos Server
- Installing Unica Integration Components & Report Model on Cognos System
- Installation checklist: IBM Cognos Integration
- Obtain the JDBC Driver for the Marketing Platform System Tables
- Install Reporting Models on the Cognos System
- Create Cognos Data Source for Unica Database
- Import Reports Folder to Cognos Connection
- Configure & Publish Data Model
- Configure the Reporting Properties in IBM Unica Marketing
- Test Your Configuration without Authentication Enabled
