Reports SQL Generator page reference
The Reports SQL Generator uses the reporting schemas you configure to generate SQL that creates views and reporting tables.
Item
Description
Product
Lists the products whose reporting schema templates are installed.
Schema
Lists the reporting schemas for the product you selected. For more information see the following descriptions.
Campaign reports and reporting schemas
eMessage Reports and Reporting Schemas
Interact Reports and Reporting Schemas
Database Type
Indicates the database type of the application database where you plan to run the scripts you are generating.
Generate Type
Indicates whether the scripts you are generating should create views, materialized views, or reporting tables.
Materialized views are not an option when Database Type is set to MS SQL Server.
If the JNDI data source names are incorrect or have not been configured, the SQL Generator cannot validate scripts that create tables.
The fourth option, XML, doesn't result in a SQL script. Instead, it creates a description of the schema in XML. You can then use the XML file as needed with your third-party ETL or import tools.
See also,
About the reporting deployment options
.
Generate Drop Statement?
Indicates whether the scripts you are generating are drop scripts or not. When updating existing views or tables, it is best practice to generate a drop script and a creation script and to then run the drop script before you run the new creation script.
When you select
Yes
in the field, the SQL Generator appends the word
DROP
to the end of the script.
Generate
Click this option to have the SQL Generator create the script and then display it in this window. You can then copy and paste it as appropriate.
Download
Click this option to have the SQL Generator create the script and then prompt you to save it to your system. For information about the names it uses for the generated scripts, see:
SQL scripts by data source
.
Copyright IBM Corporation 2012. All Rights Reserved.