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