Customer is a component of the University of Texas System located in Galveston, Texas, United States. It is an academic health centre with 11,000 employees and a medical school that is the oldest in Texas. Established in 1891 Customer has more than 2,500 students and more than 1,000 faculty. It has four schools, three institutes for advanced study, a comprehensive medical library, four on-site hospitals, a network of clinics that provide primary and specialized medical care and numerous research facilities.
Customer had a legacy PeopleSoft EPM 8.9 Student Data Warehouse ecosystem including OBIEE 10g that had moved to sustaining support where they would no longer receive new Updates, Fixes, Security Alerts, Data fixes, Critical Patches. Also, they would be on their own to manage integration for Third-Party Product or new versions of Oracle products. Moreover, the Extract Transformation and Load (ETL) tool, Data Stage 8.5, was going to be de-supported altogether from IBM the following year.
The ERPA Solution:
ERPA conducted an assessment of the Customer’s PeopleSoft EPM ecosystem including OBIEE 10g to catalogue the metadata repositories, dashboards and reports that had been created and were in production. We then conducted an analysis of the delivered Metadata Repositories (.RPDs) in OBIA 220.127.116.11.2 which would be the logical replacement to their legacy PeopleSoft EPM system. Subsequently, ERPA conducted a fit gap analysis between the two systems to determine the viability and cost of re-implementing their data warehouse on OBIA. Lastly, ERPA created a Data Warehouse Roadmap with a timeline, estimation of resources, and cost estimates.
- Clear understanding of the required effort to replace their legacy data warehouse / business analytics system
- Establish a base line comparison for system option analysis
Key Technologies & Services:
- OBIA 18.104.22.168.2
- PeopleSoft EPM