Summary of Product Functions

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

  • Scheduled incremental updates

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 either independently or as a group.

  • Scheduled full reloads

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 either independently or as a group.

  • Datamart model schema creation

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

complete, applicable transformations for the target datamart schema.

  • Error detection and correction

    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.

  • Transformations

Transforms can be created to change or manipulate data that is being synced from the source to the target. Transformations, such as column expressions, column mapping, aggregation, lookups, unions, etc. can be developed. This enables DataSync to have ETL (Extract, Transform, Load) functionality.