Update the views or reporting tables
Note that this procedure describes updating existing views or reporting tables. If you are creating views or reporting tables for the first time, do not use this procedure. Instead, use the reports chapter in the installation guide for your IBM® Unica® application.
After you generate and download the SQL scripts that update your views or tables, run them on the application databases.
1.
Locate the SQL scripts that you generated and saved. Use the table in SQL scripts by data source to determine which scripts to run against which database.
2.
Use your database administration tools to run the drop scripts.
3.
Use your database administration tools to run the creation scripts.
4.
For reporting tables, use your database administration tools to populate the new tables with the appropriate data from the production system database.
5.
For reporting tables and materialized views, use your database administration tools to schedule data synchronization processes between the IBM® Unica® application's production databases and the new reporting tables or materialized views to run regularly.
*
You must use your own tools for this step. The Reports SQL Generator does not generate this SQL for you.
Copyright IBM Corporation 2012. All Rights Reserved.