You can use SQL scripts to create and populate reporting tables for Interact. The reports application uses reporting tables
to extract reportable data.
About this task
To create and populate reporting tables for Interact, complete the following steps.
Procedure
- 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.
-
In the tools subdirectory in the reports package installation directory,
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
Continue with Setting up data synchronization.