Extraction, Transformation and Loading (ETL)

SAS Enterprise Data Integration Server enables organizations 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 also provides unparalleled technical support and professional services, giving organizations the flexibility to go beyond the robust prepackaged transformations to build unique routines without fear of losing vendor support for custom work.

• Enables rapid generation of data warehouses, data marts and data streams.
• Lets you create ETL processes that are reusable, easily modified and have embedded data quality processing.
• Increases returns on existing IT investments by providing multiple-platform scalability and interoperability.

Features

• A powerful, yet easy-to-use transformation user interface that supports collaboration, reuse of processes and common metadata.
• Single or multiple-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 processes and is available for immediate reuse.
• Transformations can run on any platform with any data source.
• More than 300 predefined table and column-level transformations.
• Ready-to-use analytical transformations, including correlations and frequencies, distribution analysis and summary statistics.
• 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, so they are reusable in many different projects and 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.
• Easily refresh, append and update during loading.
• Optimize loading techniques with user-selectable options.
• Database-aware loading techniques, including bulk load facilities, index and key creation, and dropping and truncating of e tables.
• Ability to easily design, create and load OLAP cubes.