Creating views or materialized views for Unica Interact only

You can use SQL scripts to create views or materialized views for Interact. The reports application uses views or materialized views to extract reportable data.

Before you create views or materialized views for Interact, verify that the language setting for the computer from where you run the lookup_create SQL script is enabled for UTF-8 encoding.

To create views or materialized views for Interact, complete the following steps.

  1. Locate the SQL scripts that you generated and saved previously.
  2. Use the database administration tools to run the appropriate script against the appropriate application database(s) for the report package that you are configuring.
Note: When you run a script that creates materialized views on a DB2 database, you may see the following error:
SQL20059W The materialized query
        table-name may not be used to optimize the processing of queries.

However, the materialized view is successfully created.

  1. Under the Interact installation directory, in the tools subdirectory of report folder, find the uari_lookup_create_<db_type>.sql script for your database. For example, for SQL Server, script is available at <INTERACT_HOME>/Interact/reports/tools/uari_lookup_create_MSSQL.sql.
  2. Run the uari_lookup_create script on the Interact design time database.
  3. Locate the uari_lookup_populate.sql script under <INTERACT_HOME>/Interact/reports/tools path and run it on the Interact design time database.
    Note: Ensure that the database tool that you have used commits the changes. For example, you may require to set the auto-commit option of the database to true.

Continue with Setting up data synchronization.