Installation checklist: HCL Cognos integration
Integrate HCL® Cognos® with IBM EMM applications by creating HCL Cognos data sources and configuring the HCL Cognos application firewall. You must also create reporting, configure Cognos reporting properties in Marketing Platform, and configure and test HCL Cognos to use IBM EMM authentication.
The following list provides a high-level overview of how to install and configure the HCL components and reports on the HCL Cognos system:
- Obtain the JDBC driver for the Marketing Platform system tables.
- Installing the reporting models and integration component on the HCL Cognos system.
- Creating HCL Cognos data sources for IBM EMM application databases.
- Setting up email notifications.
- Configuring HCL Cognos Application Firewall for IBM EMM
- For eMessage reports, installing stored procedures for delta processing.
- For eMessage reports, creating stored procedures, staging tables, and indexes.
- Loading templates for Reports SQL Generator.
- Generating view or table creation scripts
- Creating views or materialized views for Campaign or eMessage
- Creating views or materialized views for Interact
- Creating and populating reporting tables for Campaign
- Creating and populating reporting tables for Interact
- Importing the reports folder in Cognos Connection
- Configuring and publishing the data model.
- Enabling internal links in the reports.
- Verifying data source names and publishing.
- Configuring Cognos reporting properties in Marketing Platform.
- Setting report folder permissions.
- Running and scheduling stored procedures for eMessage
- Testing your configuration before enabling authentication.
- Configure IBM Cognos to use IBM EMM authentication.
- Testing your configuration with authentication configured.