Data Migration & Synchronisation

Capture and propagate data changes in real-time to ensure data integrity, consistency and credibility

Migrating data from system to system is a constant activity for most organisations. For many, mergers and acquisitions have resulted in multiple overlapping systems containing information that needs to be synchronised. Moving legacy data during application upgrades and conversions is ongoing, as is the movement of data in and out of ERP systems.

SAS Data Integration provides the capability to migrate, synchronize and replicate data among different operational systems and data sources. Powerful data transformations are available for altering, reformatting and consolidating information. Real-time data quality integration allows data to be cleansed as it is being moved, replicated or synchronised, and you can easily build a library of reusable business rules. Bad data is never spread from system to system, so the information delivered across the enterprise is up-to-date, consistent and accurate.

Key Benefits

• Reduces time, cost and risk when consolidating or upgrading legacy applications.
• Prevents the propagation of bad data by cleansing data as it is moved.
• Delivers up-to-date and standardised information across large numbers of applications, systems, environments and geographies.

Key Features

• Metadata-driven access to sources.
• Extensive library of predefined transformations can be extended and shared with other integration processes.
• Embedded, reusable data quality business rules clean data as it is moved.
• Recognises changes to key fields and replicates/synchronises changes across multiple databases.
• Scheduler allows changes made in one or more systems to be propagated to other systems on a scheduled basis.
• Delivers real-time data services for Synchronisation and migration projects.