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 Unica 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 Unica 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.

Also in the case of Unica Platform, Unica Campaign and Unica Interact deployed on different Application server instances/profiles you are required to add Unica Campaign, Unica Interact Runtime and Unica Interact Learning Data Source in the Unica Platform Application instance/profile.