Installation checklist: IBM® Cognos® integration
The following list provides a high level overview of how to install and configure the IBM® components and reports on the IBM® Cognos® system. Each step is described in detail later.
1.
Step: Obtain the JDBC driver for the Marketing Platform system tables.
2.
Installing the reporting models and integration component on the IBM Cognos system.
3.
Creating IBM Cognos data sources for IBM EMM application databases.
4.
Setting up email notifications.
5.
Configuring IBM Cognos Application Firewall for IBM EMM
6.
For eMessage reports, limiting scope of delta processing.
7.
For eMessage reports, creating stored procedures staging tables, and indexes.
8.
Loading templates for Reports SQL Generator.
9.
Generating view or table creation scripts
10.
Creating views or materialized views for Campaign or eMessage
11.
Create views or materialized views for Interact
12.
Creating and populating reporting tables for Campaign
13.
Create and populate reporting tables for Interact
14.
Importing the reports folder in Cognos Connection
15.
Configuring and publishing the data model.
16.
Enabling internal links in the reports.
17.
Verifying data source names and publishing.
18.
Configuring Cognos reporting properties in Marketing Platform.
19.
Setting report folder permissions.
20.
Running and scheduling stored procedures for eMessage
21.
Testing your configuration before enabling authentication.
22.
Configure IBM Cognos to use IBM EMM authentication.
23.
Testing your configuration with authentication configured.
Copyright IBM Corporation 2012. All Rights Reserved.