To implement reporting for Campaign, Interact, and eMessage, you start by creating reporting views or tables so the reports can extract reportable data. The report packages for these applications include reporting schemas that the Reporting SQL Generator uses to produce SQL scripts that create reporting views or tables.

For Campaign and Interact, you customize the schema templates so that all the data you want to include in your reports is represented. Then you run the Reporting SQL Generator, take the resulting scripts, and run them on your application databases.

Although you cannot customize the eMessage reporting schemas, you or the installation team must still generate the SQL 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 IBM® Unica® application data. However, if you want to display reports in the IBM® Unica Marketing user interface, your installation must be integrated with IBM Cognos 8 BI.