Make sure that you use the database administration tools to schedule regular data
synchronization between the production databases of the Unica application and the materialized
views.
About this task
To set up data synchronization, use the following guidelines depending on your application and
database type.
Procedure
-
For Unica Campaign, use the scheduled
Extraction, Transformation, and Load (ETL) method, or any custom method to schedule regular data
synchronization between the production databases and the new reporting tables.
-
For Unica Deliver, the materialized views for
Oracle and DB2® are refreshed by stored procedures. Stored
procedures also update the
uare_delta_refresh_log
table.
-
For Unica Interact on Oracle or DB2 databases, use the scheduled Extraction, Transformation, and
Load (ETL) method or any custom method to schedule regular data synchronization between the
production databases and the new reporting tables.
-
For Unica Interact on a SQL server, use the
scheduled Extraction, Transformation, and Load (ETL) method, or any custom method to schedule
regular data synchronization between the production databases and the new reporting tables.