SAS, the leader in business intelligence, announced major new enhancements to its market-leading enterprise data integration platform. With the creation of SAS Enterprise ETL Server, SAS is delivering a powerful end-to-end enterprise data integration and management platform for designing, managing and improving data warehouses, and greatly simplifying the extraction, transformation and loading (ETL) process. The announcement was made at a press conference at SeUGI 21, this year’s annual SAS European Users Group International conference.

Data integration is the single biggest obstacle to achieving return on data warehousing and business intelligence software investment. "Data integration today, quite ironically, is about much more than just integrating data,” said Doug Laney, vice president of technology research services at META Group. “Our research indicates that organizations are increasingly on the lookout for enterprise-class solutions that encompass robust meta data management, embody data quality features, include built-in analytic functions and demonstrate a tangible ‘awareness’ of popular business application data structures.”

The SAS Enterprise ETL Server is the latest rollout in the SAS 9.1 suite of tools which began March 31, with the announcement of its Business Intelligence Server. SAS Enterprise ETL Server is a high-performance data integration software product that synthesizes corporate information from a wide range of data sources in a timely, cost-effective manner and manages meta data over the project life cycle.

The Enterprise ETL Server gives IT departments suffering from poor data quality and widely inconsistent data representations greater confidence by offering a single version of the truth through integrated data quality. The product provides a single point of control for managing the ETL process, leading to significantly reduced maintenance and deployment costs, as well as seamless application and meta data interoperability and scalability. In addition, the new data integration platform helps economically-impacted IT departments, which demand that new software quickly integrate into their existing operational infrastructure, by providing near real-time data warehousing and integration capabilities.

Building upon an existing set of world-class data manipulation tools, SAS Enterprise ETL Server features three new products: SAS ETL Studio (a newly enhanced solution formerly known as SAS/Warehouse Administrator, the new SAS Metadata Server and the new SAS Data Quality Solution.

SAS ETL Studio: A critical component of the ETL process, SAS ETL Studio is tailored in three personas to meet the various needs of IT professionals by simplifying the data management process and integrating with various data sources. It allows ETL designers, project managers and systems architects to navigate and understand complex data integration issues, all while leveraging full access to SAS analytics.

ETL Studio synthesizes corporate data from disparate “silos” of information in a fast, cost-effective manner. The ETL process is usually the most time- consuming and difficult to design and operate of any of the development activities in the data warehousing and business intelligence “value chain.” ETL Studio can access and integrate almost any data source, from mainframe to PC files to ERPs, can execute on nearly any platform and can easily access analytic components including data mining.

SAS Metadata Server: New to the market, SAS Metadata Server manages all business, technical and process meta data, providing information about all data sources (including those not in SAS), content, business rules and authorization. Metadata Server, along with all other SAS 9.1 products, is fully compliant with the Common Warehouse Metamodel (CWM) standard, and includes bridges to interoperability with third-party vendors. SAS is a pioneer in open meta data initiatives and is the only business intelligence vendor that allows metadata to be shared and exchanged throughout the entire intelligence value chain in an enterprise, from ETL and storage to BI and analytic applications. Organizations can now build one version of the truth, eliminating redundancy, lowering support costs, minimizing work when changes are made and significantly reducing errors.

SAS Data Quality Solution: Powerful and easy to use, the SAS Data Quality Solution runs on any platform and is geared for IT professionals to implement changes and data quality metrics across the enterprise network. It eliminates or reduces inconsistencies in corporate data faster and more accurately and allows duplicate records to be removed or integrated. Expanded support for international data cleansing is now available for many languages. New data profiling operations enable organizations to detect data errors as well as interpret and infer the structure of legacy databases or text files. SAS Data Quality Solution allows business and IT users to complete data quality and data integration projects in record time.

Now at early adopter sites, SAS Enterprise ETL Server will ship to customers in a phased release beginning October 30.

Register or login for access to this item and much more

All Information Management content is archived after seven days.

Community members receive:
  • All recent and archived articles
  • Conference offers and updates
  • A full menu of enewsletter options
  • Web seminars, white papers, ebooks

Don't have an account? Register for Free Unlimited Access