SAS^® Data Migration

With large data volumes, often fragmented environments with nonstandard formats and data quality issues, many organizations have underestimated the effort required to migrate data. They tend to start by using a mix of tools and manual coding, and lack the benefits of an integrated set of tools based on a common metadata environment. This approach frequently has led to: inefficiencies in both the process and developed code, and minimal reusability and maintenance difficulties, which can ultimately lead to a common outcome that includes project delays and cost overruns.

SAS Data Migration addresses these issues, by bringing together a full-featured, state-of-the-art solution that is optimized and licensed especially for data migration projects. This powerful data migration solution delivers:

• Comprehensive connectivity and data profiling, enabling you to access and survey your data sources.
• Advanced data quality and transformations to improve the consistency and accuracy of your data en route to its new destination.
• Centralized metadata management that improves efficiency and reusability and captures key migration metrics.
• Multiple data latency options, including batch, message queues and real time.

Components of SAS^® Data Migration

• An expanded version of SAS Enterprise Data Integration Server, including a suite of advanced data quality tools.
• All standard SAS/ACCESS® engines based on availability by host, including Oracle, Teradata, DB2, SQL Server, Netezza, Neoview and others. You can use as many as needed to migrate your data.
• SAS Data Surveyor for SAP may be added upon request at no additional charge.
• A 90-day, project-based license that can be purchased up to three times prior to being converted to an annual license.

In addition to the migration software, SAS offers professional services that include supplemental human resources, mentoring, migration planning or a full migration solution.

How SAS^® Is Different

• SAS Data Migration provides the ability to migrate or synchronize data between database structures, enterprise applications, mainframe legacy files, text, XML, message queues and a host of other sources.
• You get complete, seamless and transparent read/write/update access to more than 60 data sources, including relational and nonrelational databases, PC file formats and data warehouse appliances. In addition, SAS Data Surveyor for SAP is available for accessing SAP application data.
• Embedded, reusable data quality business rules clean data as it is moved, synchronized or replicated.
• SAS can help you leverage all your enterprise data for competitive advantage.