ETL | Extraction, Transformation and Loading

Extract, cleanse, transform, load and manage data from a single environment

SAS provides integrated ETL capabilities that enable organisations to extract transform and load data from across the enterprise to create consistent, accurate information.

An intuitive, point-and-click process design desktop makes it easy to build logical process workflows, quickly identify the input and output data flows, and create business rules in metadata, all of which enable the rapid generation of data warehouses, data marts and data streams.

SAS Data Integration includes a powerful, yet easy-to-use transformation language that supports collaboration, reuse of processes and common metadata. Transformation processes are callable through custom exits, message queues and Web services, so they are easily reusable in different projects in many different technology environments. Metadata is captured and documented throughout transformation and data integration processes and is available for immediate reuse.

SAS also provides unparalleled technical support and professional services, giving organisations the flexibility to go beyond the robust prepackaged transformations to build unique routines without fear of losing vendor support for custom work.

Key Benefits

• Rapidly generate data warehouses, data marts and data streams.
• Control the cost of data integration and ETL design and maintenance.
• Create ETL processes that are reusable, easily modified and have embedded data quality processing.
• Increase returns on existing IT investments by providing multiplatform scalability and interoperability.

Key Features

• Single or multi-source data acquisition, transformation, cleansing and loading to create data warehouses, data marts, or BI and analytic data stores.
• Metadata is captured and documented throughout the data integration and transformation process.
• Transformations can run on any platform with any data source.
• More than 300 predefined table and column-level transformations.
• Transformation Generator wizard or Java plug-in design templates for creating reusable and repeatable transformations that are tracked and registered in metadata.
• Transformation processes are callable through custom exits, message queues and Web services, enabling reuse in many different projects and in different technology environments.
• Transformations can be executed interactively and scheduled to run in batch at set times or based on events that trigger execution.
• Framework for publishing information to archives, a publishing channel, e-mail or various message queuing middleware.