Create and populate reporting tables for Interagir

1.	Create the new reporting databases.

2.	Locate the SQL scripts that you generated and saved previously. Refer to Scripts SQL por Origem de Dados if necessary.

3.	Use your database administration tools to run the generated script(s) in the new database.

4.	Locate the tools subdirectory in the reports package installation directory and find the lookup_create script for your database type. For example, the script for SQL is named uari_lookup_create_MSSQL.sql, and so on.

Run this script on the the Interagir design time database. Ensure that the database tool you are using commits the changes. For example, you may need to set the database's auto-commit option to true.

5.	Locate the db/calendar subdirectory in the Plataforma de Marketing installation directory and find the ReportsCalendarPopulate script appropriate for the database type. This script creates two more tables: UA_Calendar and UA_Time.

6.	Run this script on both the set of tables that represents the Interagir design time database and the tables that represent the Interagir run time database.

For DB2® only, do one of the following:

Either run the script from the command line using the command db2 -td@ -vf ReportsCalendarPopulate_DB2.sql

Or, if you use the DB2® client interface, change the termination character to the @ character in the Statement termination character field.

7.	Use your database administration tools to populate the new tables with the appropriate data from the production system database.

Note that you must use your own tools for this step. The SQL Generator does not generate this SQL for you.