The Reporting SQL Generator uses the reporting schemas to determine the analytic logic necessary to extract data from the database for the IBM® Unica® application. It then generates SQL 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® Unica® application databases. The Reporting SQL Generator uses connects to the application databases as follows.