Reporting schemas

You must create reporting view to implement reporting for Unica Campaign, Unica Interact, and Unica Deliver. Reports can extract reportable data in the reporting views. The report packages for Unica Campaign, Unica Interact, and Unica Deliver include reporting schemas that the Reporting SQL Generator uses to produce SQL scripts that create reporting views.

For Unica Campaign and Unica 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 Unica Deliver reporting schemas. However, you must generate the SQL script that builds the reporting views and then run the scripts on the Deliver 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 Unica user interface, your installation must be integrated with IBM Cognos® BI.