You can use SQL scripts to create and populate reporting tables for Unica Interact. The reports application uses reporting tables
to extract reportable data.
About this task
To create and populate reporting tables for Unica 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 Unica 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.