For Unica Interact only: Creating and populating reporting tables
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 nameduari_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.