Step: Generate the view or table creation scripts

1.	Log in to IBM® EMM as the platform_admin user (or another user with access to the Report SQL Generator menu item).

2.	Only if you did not use the default JNDI names for the JDBC data sources you created in an earlier step, do the following.

a.	Select Settings \| Configuration \| Reports \| Schemas \| ProductName .

b.	Change the default values of the JNDI property to match the JNDI names you gave the JDBC connections in an earlier step.

3.	Select Settings \| Reports SQL Generator.

4.	In the Product field, select the appropriate IBM® application.

5.	In the Schema field, select one or more reporting schemas.

6.	Select the Database Type.

7.	In the Generate Type field, select the appropriate option (views, materialized views, or tables).

8.	Ensure that Generate Drop Statement is set to No.

9.	(Optional.) To examine the SQL that will be generated, click Generate. The SQL Generator creates the script and displays it in the browser window.

10.	Click Download.

The SQL Generator creates the script and prompts you to specify where you want to save the file. If you selected a single reporting schema from the Schema field, the script name matches the name of schema (eMessage_Mailing_Performance.sql, for example). If you selected more than one reporting schema, the script name uses the product name only (Campaign.sql, for example). For a complete list of names, see SQL scripts by data source.

11.	Specify the location where you want to save the script. If you change the name of the file, be sure to use something that clearly indicates which schemas you selected. Then click Save.

12.	Repeat steps 5 through 12 for each script you need to generate.

The Interact reporting schemas reference more than one data source. Generate a separate SQL script for each data source.