The CONNX Data Synchronization tool provides several unique product functions.

• Full reloads on demand

Purges all prior snapshot data in the data warehouse, replacing it in the data warehouse

with a completely new snapshot.

• Incremental updates on demand

Detects which records have been added, deleted, or changed, and inserts, updates,

or deletes the corresponding data in the data warehouse snapshot tables at a fraction

of the usual time. The incremental update runs up to 10 times faster than the full

update, a significant decrease in the time it takes to synchronize.

• Performs a scheduled incremental update

Detects which records have been added, deleted, or changed, and inserts, updates,

or deletes the corresponding data in the data warehouse snapshot tables. Each file

in the synchronization process may be scheduled independently, or as a group.

• Performs a scheduled full reload

Purges all prior snapshot data in the data warehouse. A completely new snapshot of

the data is placed in the data warehouse. Each file in the synchronization process

may be scheduled independently, or as a group.

• Creates datamart model schema

Automatically performs a complete analysis of all source database schemas and performs

complete, applicable transformations for the target datamart schema.

• Error detection & correction

CONNX Data Synchronization provides options for automatically detecting error conditions, and resyncing until

a successful sync has been performed.

• Task triggering

Additional tasks can be triggered based on the status of a synchronization. A task can be as simple as sending an e-mail to notify that a sync was successful, or as complex as calling an ETL (Extract, Transform, Load) tool to perform additional transformations against the synchronized data.