In the Spotlight Revolutionizing the Data Integration Platform Read this white paper to learn about the process of improving data quality, starting with the business impact of poor quality data and then outlining the challenges of creating trustworthy data. What does SAS Data Integration Studio do? SAS Data Integration Studio is a visual design tool for building, implementing and managing data integration processes regardless of data sources, applications or platforms. Powerful data transformations efficiently meet enterprise data integration requirements. The creation and management of data and metadata are improved with extensive impact analysis of potential changes made throughout the entire data integration process. Why is SAS Data Integration Studio important? SAS Data Integration Studio can completely integrate data from anywhere or any source, cleanse it, merge and/or transform it and place it into a target destination. Standardized metadata is shared across the entire SAS Enterprise Intelligence Platform, and multiple designers can capture, manage, organize and exploit data across the enterprise, quickly and repeatedly. For whom is SAS Data Integration Studio designed? SAS Data Integration Studio empowers data integration designers with tools to fulfill data integration process development with unprecedented deployment speed. Designers can work more efficiently, better anticipate and control the impact of system changes, and more effectively mitigate project risks. Key Benefits Quickly meet the information needs of your organization. SAS Data Integration Studio is an easy-to-use, high-performance tool for quickly extracting, transforming and loading data to meet enterprise data integration needs. The drag-and-drop interface reduces programming time and automatically captures and manages standardized metadata from any source, easily and seamlessly, throughout the data integration process. Reduce maintenance and deployment costs with simplified data integration processes. As a single point of control for interactively managing data integration processes, SAS Data Integration Studio provides an easy-to-manage, multi-user environment that lets designers and domain experts collaborate on large enterprise projects using shareable and repeatable processes. Powerful change analysis capabilities enable designers to understand impacts on the entire deployment, saving hours of labor in development and maintenance. Minimize training and the need for advanced programming skills. In-depth transformation structures and templates that can be reused easily enable even those with minimal training and programming skills to deploy powerful transformations and sophisticated data integration processes. Key Features User interface. A drag-and-drop Windows-like interface provides a single point of control for managing data integration processes across the enterprise. A customizable metadata view lets data integration designers quickly display, visualize and understand enterprise metadata. Wizards simplify many tasks, and a visual end-to-end process designer lets developers quickly build and edit data integration jobs using built-in templates and an extensive library of transformations. Data extraction and transfer. Interactive wizards guide users through the process of connecting to data regardless of platform, topology or database, and populating the metadata repository with relevant information. In addition, new data sources can be added seamlessly for faster development. Movement and transfer of data are minimized because transformations and processing can be directed to occur natively on any platform with any database. Powerful transformations. Ready-to-use transformations eliminate the need to manage thousands of lines of custom code over the life cycle of projects. Because all transformations are metadata-driven via the user interface, training requirements are reduced. All transformations, including those that are user-written, are available in a library and are metadata-driven. This makes them easy to use and eliminates many project management headaches. Multiple-user development environment. Full check-in/check-out methodology results in automatic, up-to-date documentation and easy metadata management. A full history of changes made during the life cycle of projects is logged for auditing purposes. Multiple designers can easily synchronize work and collaborate on large projects. Enterprise metadata management. An open enterprise metadata structure retains and tracks technical, business and administrative metadata and aids in developing the data integration processes. Navigational tools help you understand how the data was derived, which allows instant reconciliation against any other source of information. Integrated workflow scheduling, load balancing and grid computing support. Integrated workflow scheduling and load balancing provide efficient execution of processes throughout the project life cycle. Automatic support for grid computing environments can dramatically speed many operations, resulting in maximized processing cycles and optimized use of hardware, increased overall productivity and reduced operations costs. For a complete list of key benefits and features, refer to the SAS Data Integration Studio fact sheet . SAS Data Integration Studio is a component of SAS Enterprise Data Integration Server.

Looking for more information on ETL? Download the free white paper "SAS ETLQ: Revolutionizing the Data Integration Platform". Read related customer success stories. Ready to put The Power to Know® to work for you? Contact your local SAS office or call us toll free at 1-800-727-0025 (U.S. and Canada). Contact SAS for pricing information and to learn more about our products and solutions. Sign up for one of our free e-newsletters. Download the FREE white paper "SAS ETLQ: Revolutionizing the Data Integration Platform"