Creating views or materialized views for Unica Campaign and Unica Deliver only:

You can use SQL scripts to create views or materialized views for Unica Campaign and Unica Deliver. The reports application uses views or materialized views to extract reportable data.

Note: For Oracle and DB2®, Unica Deliver requires materialized views. For SQL Server, Unica Deliver requires views.
To create views or materialized views for Unica Campaign or Unica Deliver, 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.

  3. For Unica Campaign with a DB2® database, increase the DB2® heap size to at least 10240. The default heap size is 2048. Use the following command to increase the heap size:

    db2 update db cfg for databasename using stmtheap 10240

    where databasename is the name of the Unica Campaign database.

    Increasing the heap size ensures that Unica Insights does not display SQL error messages if a user selects all the campaigns when running a report such as the Financial Summary report.

Continue with Setting up data synchronization.