Reporting schemas

You must create reporting views 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 or tables and then run the scripts on the Deliver databases.