Setting up data synchronization

Ensure that you use the database administration tools to schedule regular data synchronization between the production databases of the HCL Unica application and the materialized views.

To set up data synchronization, use the following guidelines depending on your application and database type.

  • 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 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.