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: