Client: BJC HealthCare

Industry: Non-profit organization

Oracle Platforms Used

  • Oracle Analytics Server
  • OBIA
  • OBIEE, Oracle Data Integrator, Oracle DB,
  • Oracle PeopleSoft ERP

Business Requirements

BJC Health was looking to modernize its existing Oracle BI Applications to leverage the latest technological advancements and address the challenges posed by the de-supported version. With a focus on improving Oracle data analytics capabilities and empowering business teams, BJC Health approached Jade to achieve the following objectives:

Modernize Oracle BI Applications
To upgrade to the latest and most advanced version
Migrate Informatica ETL to ODI Ecosystem
To migrate complex Informatica ETL mappings and relevant BI components to the Oracle ODI ecosystem for seamless integration and optimized data processing
Enable Advanced Analytics Dashboards
To develop intuitive and user-friendly dashboards for business teams (Procurement, Finance, Projects Accounting, SCM, and HR) to provide them with actionable insights for data-driven decision-making.

Download Case Study

Business Challenges


Upgrading from Oracle BI Applications 7.9 to 11.x necessitated re-implementation due to the absence of a direct upgrade path


The migration process was hindered by the lack of in-house experts in Oracle Data Integrator (ODI) and was taking a longer duration.


The absence of the original implementation team added complexity to the migration process.

Jade's Oracle Analytics Services: Business Benefits Achieved

  • Automated workflows reduced costs and risk and increased the process quality by 50%
  • Faster data and dashboards delivery and increased end-user productivity by 30%

Highlights of Solution Offered by Jade

OBIApps Modernization using Oracle Analytics Cloud

  • Automated Migration and Upgrade
    • Jade implemented InfatoODI for a seamless OBIA migration and upgrade at BJC HealthCare, reducing manual effort and minimizing risks.
  • Availability of Newer Modules
    • Newer modules in the latest OBIA versions were made accessible, enhancing reporting capabilities and data analysis for BJC HealthCare.
  • Extended ODI Loads and Mappings
    • Jade customized ODI loads and mappings, augmenting BJC's enterprise data warehouse and accelerating business insights.