Generate updated SQL scripts for the reporting views or tables

This procedure describes how to generate updated SQL scripts for existing reporting views or tables. If you are configuring views or tables for the first time, do not use this procedure. Instead, see the IBM® Unica® Marketing Platform Installation Guide.

To generate updated SQL scripts, complete the following steps:

1.	Select Settings > Reports SQL Generator. The SQL Generator page appears.

2.	In the Product field, select the appropriate IBM® Unica® application.

3.	In the Schema field, select one or more reporting schemas. Use the table in SQL scripts by data source to determine the appropriate schemas to select.

4.	Select the Database Type. This option must match the database type of the database for which you are generating the script.

5.	In the Generate Type field, select the appropriate option (views, materialized views, or 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 generate scripts that create tables.

6.	Set the value in the Generate Drop Statement field to Yes.

7.	(Optional.) To examine the SQL, click Generate. The SQL Generator creates the script and displays it in the browser window.

8.	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_Execution.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.

9.	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.

10.	Repeat steps 7 through 10 but select No in the Drop Statement field this time.

11.	Repeat steps 3 through 11 for each script you want to generate.

There might be times when you want to disable script validation. For example, perhaps the Marketing Platform cannot connect to the IBM® Unica® application database but you want to generate the scripts anyway. To disable validation, clear the values in the data source configuration properties for reporting. When you generate the scripts, the Reports SQL Generator displays a warning that it cannot connect to the data source, but it still generates the SQL script.