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:
*
*
If the JNDI data source names are incorrect or missing, the Reporting SQL Generator cannot validate scripts that create reporting tables.