CONNX Data Integration Suite 14.8.0 | DataSync | Introduction
 
Introduction
The CONNX DataSync Tool pumps data to a data mart or a data warehouse. With CONNX DataSync, users can move a complete snapshot of a pre-defined list of tables, views, or complex transformations into the Data Warehouse. The tool can also incrementally update the current snapshot of data through a simple-to-use scheduling interface. This accomplishes the goal of "near real-time" data synchronization.
The following diagram illustrates the data synchronization process:
The data synchronization process extracts, transforms, and then loads, inserts, updates, or deletes information from the operational data stores to the target data stores. It supports full reloading and incremental updating, as well as viewing the data through a CONNX Store.