HCL TECHNOLOGIES ABOUT US PRODUCTS & SOLUTIONS RESOURCES CONTACT US

Home
HCL Marketing Software Reports Installation and Configuration Guide
An installation of the HCL® Marketing Software reports is complete when you install HCL® Cognos® BI and configure it for HCL Marketing Software applications. This guide provides detailed information about configuring HCL Cognos BI, and integrating HCL Cognos BI with HCL Marketing Software.
After you install or upgrade your reporting packages, you must configure your reporting installation.
You must create reporting view or tables to implement reporting for Campaign, Interact, and eMessage. Reports can extract reportable data in the reporting views or tables. The report packages for Campaign, Interact, and eMessage include reporting schemas that the Reporting SQL Generator uses to produce SQL scripts that create reporting views or tables.
The Report SQL Generator uses the reporting schemas to determine the analytic logic that is necessary to extract data from the database for the HCL® Marketing Software application. The Report SQL Generator then generates the SQL script that creates views or reporting tables that implement the logic and that enable business intelligence tools to extract reportable data.

The Report SQL Generator

The Report SQL Generator uses the reporting schemas to determine the analytic logic that is necessary to extract data from the database for the HCL® Marketing Software application. The Report SQL Generator then generates the SQL script that creates views or reporting tables that implement the logic and that enable business intelligence tools to extract reportable data.

During installation and configuration, the system implementers configured data source properties that identify the HCL Marketing Software application databases. The Report SQL Generator connects to the application databases to complete the following tasks:

Validate scripts that create views or materialized views
Determine the correct data types to use in scripts that create reporting tables

If the JNDI data source names are incorrect or missing, the Report SQL Generator cannot validate the scripts that create the reporting tables.