Reporting schemas

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.

For Campaign and Interact, you must customize the schema templates so that the data that you want to include in your reports is represented. You can run the Reporting SQL Generator after you customize the schema templates. You can run the SQL scripts that the SQL Generator generated and run the scripts on your application databases.

You cannot customize the eMessage reporting schemas. However, you must generate the SQL script that builds the reporting views or tables and then run the scripts on the eMessage databases.

The reporting schemas make it easier for you to use any third-party reporting tool to examine your HCL® application data. However, if you want to display reports in the HCL® Marketing Software user interface, your installation must be integrated with HCL Cognos® BI.