You can use SQL scripts to create and populate reporting
tables for Interact.
Reports uses reporting tables to extract reportable data.
Procedure
Complete the following steps to create and populate reporting
tables for Interact:
- Create the reporting databases.
- Use your database administration tools to run the appropriate
script against the appropriate application database(s) for the report
package that you are configuring.
- 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.
- 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.
- Use your database administration tools to populate the
new tables with the appropriate data from the production system database.
Note: You must use your own tools for this step. The SQL
Generator does not generate the SQL for you.
What to do next
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 HCL®
EMM application
and the new reporting tables.