Create and populate reporting tables for Interact
You can use SQL scripts to create and populate reporting tables for Interact. Reports uses reporting tables to extract reportable data.
1.
Complete the following steps to create and populate reporting tables for Interact:
2.
Create the reporting databases.
3.
Create the reporting database.
4.
Use your database administration tools to run the appropriate script against the appropriate application database(s) for the report package that you are configuring.
5.
Run the lookup_create script on the Interact design time database. Ensure that the database tool that you use commits the changes. For example, you might need to set the auto-commit option of the database to true.
6.
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.
7.
Use your database administration tools to populate the new tables with the appropriate data from the production system database.
*
You must use your own tools for this step. The SQL Generator does not generate the SQL for you.
Setting up data synchronization
Make sure that you use scheduled Extraction, Transformation, and Load (ETL) method, or any custom method to schedule regular data synchronization between the production databases of the IBM® EMM application and the new reporting tables.
Copyright IBM Corporation 2014. All Rights Reserved.