SAS/Warehouse Administrator®

SAS/Warehouse Administrator is designed for the IT professional responsible for creating and managing data warehouse/data mart processes. SAS/Warehouse Administrator is a customizable solution that offers a single point of control, making it easier to respond to the ever-changing needs of the business community.

End users increasingly understand the benefits of basing business intelligence systems on the solid foundations of a data warehouse. But from the IT department's perspective, implementing a corporate data warehousing strategy is a commitment of time and resources. Hand-writing programs to perform the tedious chores of extracting, cleansing transforming and loading operational data into a repository suitable for business intelligence applications can overextend even the most productive IT departments.

SAS/Warehouse Administrator software simplifies the setup and management of multiple data warehouses and data marts. This single solution:

• Integrates extraction, transformation and loading tools for building and managing data warehouses/data marts.
• Provides a framework for effective warehouse management through a metadata-driven architecture.
• Facilitates business subject definition, consolidation of business rules, scheduling of processes for warehouse maintenance and integration with decision-support tools for effective warehouse exploitation.
• Leverages the strengths of SAS software and rapid warehousing to deliver the well-proven benefits of a data warehouse even faster.

SAS/Warehouse Administrator software brings together the components in SAS software which are key to setting up and managing a SAS data warehouse — through the three phases of data warehouse management, organization and exploitation. To meet their business objectives, many organizations are setting up multiple-hierarchy data warehouses and localized data marts. SAS Warehouse Administrator software greatly reduces the complexity of building and managing the data warehouse and helps to automate day-to-day processes.

With its graphical user interface, you can simplify the visualization, navigation and maintenance of the data warehouse and eliminate much of the coding work required to build and manage it. SAS/Warehouse Administrator software offers the adaptability and the manageability you need as your business and information needs change, as more data is added, as processes become more complex, and as users require greater support.