DataSync provides several unique product functions:

DataSync can purge all prior snapshot data in the data warehouse and replace it with a completely new snapshot. Each file in the synchronization process may be scheduled either independently or as a group.

DataSync can detect which records have been added, deleted, or changed and then insert, update, or delete 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. Each file in the synchronization process may be scheduled either independently or as a group.

DataSync can automatically perform a complete analysis of all source database schemas and perform complete, applicable transformations for the target datamart schema.

DataSync provides options for automatically detecting error conditions and resyncing until a successful sync has been performed.

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 on the synchronized data.

You can create transformations to change or manipulate the data that is being synced from the source to the target. The supported transformations include column expressions, column mapping, aggregation, lookups, unions, and etc. This enables DataSync to have ETL (Extract, Transform, Load) functionality.