Reporting SQL Generator
The Reporting SQL Generator uses the reporting schemas to determine the analytic logic that is necessary to extract data from the database for the
IBM
®
EMM
application. The Reporting SQL Generator then generates the SQL script that creates views or reporting tables that implement that logic and that enables business intelligence tools to extract reportable data.
During installation and configuration, the system implementers configured data source properties that identify the
IBM
®
EMM
application databases. The Reporting 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 Reporting SQL Generator cannot validate scripts that create reporting tables.
Copyright IBM Corporation 2014. All Rights Reserved.