Generating view or table creation scripts
You can create reporting views or tables by using the view or table creation scripts. Reports extract reportable data from reporting views or tables. Use the SQL Generator to create view or table creation scripts.
If you are using eMessage reports, make sure that you have run the SQL scripts in .For eMessage reports, creating stored procedures staging tables, and indexes
1.
Complete the following tasks to create view or table creation scripts:
2.
Log in to IBM® EMM as a user that has the ReportsSystem role.
Proceed to step 2 if you did not use default JNDI names for JDBC data sources.
Proceed to step 3 if you used default JNDI names for JDBC data sources.
3.
Complete the following steps if you did not use default JNDI names for JDBC data sources:
a.
Select Settings > Configuration > Reports > Schemas > ProductName.
b.
Change the default values of the JNDI property to match the JNDI names that you used for JDBC connections.
4.
Select Settings > Reports SQL Generator.
5.
In the Product field, select the appropriate IBM® application.
6.
In the Schema field, select one or more reporting schemas.
7.
Select the Database Type.
8.
In the Generate Type field, select the appropriate option (views, materialized views, or tables).
*
You cannot select materialized views when the database type is set to Microsoft™ SQL Server.
*
For eMessage only. For Oracle and IBM® DB2®, eMessage requires materialized views. For SQL Server, eMessage requires views.
*
If the JNDI data source names are incorrect or have not been configured, the SQL Generator cannot validate the SQL.scripts that create tables.
9.
Ensure that Generate Drop Statement is set to No.
10.
If you want to examine the SQL script that is generated, click Generate.
The SQL Generator creates the script and displays it in the browser window.
11.
Click Download.
The SQL Generator creates the script and prompts you to specify the location for the file to be saved.. If you selected a single reporting schema from the Schema field, the script name matches the name of schema, for example eMessage_Mailing_Performance.sql. If you selected more than one reporting schema, the script name uses the product name, for example Campaign.sql.
12.
Specify the location where you want to save the script, and click Save. If you change the name of the file, make sure to use a name that clearly indicates the schemas that you selected.
13.
Repeat steps 5 through 12 for each script that you need to generate.
*
The Interact reporting schemas reference multiple data sources. Generate a separate SQL script for each data source.
Copyright IBM Corporation 2014. All Rights Reserved.