Published on 20 Dec 2011
“ Now our business managers, administrators and deans have the information needed to answer questions they couldn’t answer before. ”
Manav Mehra, ETL Team Lead, Enterprise Information and Analytics Department, Office of the CIO, University of Arizona
University of Arizona
In 2008, University of Arizona leaders recognized that to stay competitive with other universities they had to replace aged administrative computer systems. But replacing these source systems was only the first step in expanding the availability of business information to school staff. The University’s Business Intelligence (BI) team used IBM InfoSphere Information Server software to expand its data warehouse.
University leaders sought to expand the availability of business information to authorized users. Decision makers routinely depended on IT experts to compile data, sometimes waiting for days or weeks for information to answer business and operational questions.
The University used IBM InfoSphere Information Server software to understand, cleanse, transform and deliver data from source systems into its enterprise data warehouse, providing a single source of information for business intelligence.
- Increased data warehouse demand to over 1,900 users and growing - Improved time to compile report data from weeks to seconds—more than 90 percent faster - Reduced time to run more than 22,000 nightly ETL jobs by almost 70 percent with upgrade to IBM InfoSphere Information Server 8.5
IBM products and services that were used in this case study.
InfoSphere Data Architect, InfoSphere DataStage, InfoSphere FastTrack, InfoSphere Information Server, InfoSphere Metadata Workbench
© Copyright IBM Corporation 2011 IBM Corporation Software Group Route 100 Somers, NY 10589 U.S.A. Produced in the United States of America December 2011 All Rights Reserved IBM, the IBM logo, ibm.com, and InfoSphere are trademarks of International Business Machines Corporation in the United States, other countries or both. If these and other IBM trademarked terms are marked on their first occurrence in this information with a trademark symbol (® or ™), these symbols indicate U.S. registered or common law trademarks owned by IBM at the time this information was published. Such trademarks may also be registered or common law trademarks in other countries. A current list of IBM trademarks is available on the web at “Copyright and trademark information” at ibm.com/legal/copytrade.shtml Other company, product and service names may be trademarks or service marks of others. References in this publication to IBM products or services do not imply that IBM intends to make them available in all countries in which IBM operates.