Product Functions
DataSync provides several unique product functions:
Full Reloads on Demand or When Scheduled
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.
Incremental Updates on Demand or When Scheduled
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.
Datamart Model Schema Creation
DataSync can automatically perform a complete analysis of all source database schemas and perform complete, applicable transformations for the target datamart schema.
Error Detection and Correction
DataSync 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 on the synchronized data.
Transformations
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.