Business Intelligence Application Upgrade Enabled to Stay Oracle-Support Compliant and Up-Take New Capabilities

 

The client is an independent special district that provides high-quality drinking water, reliable sewage collection and treatment, ground-breaking recycled water programs, and environmentally sound urban runoff treatment to its customers. 

 

Background

The client was using Oracle Business Intelligence Applications (OBIA) v 7.9.6.2 on top of Oracle Analytics 10g with Informatica 8.6.1 as data extraction tool & Digital to Analog Converter (DAC) as an Extract Transform Load (ETL) scheduling tool.  

 

The client wanted to upgrade its Business Intelligence (BI) infrastructure including tools & components to the most appropriate version, across departments, to stay compliant with Oracle support. 

 

Solution

DiLytics carried out the upgrade of OBIA from v7.9.6.2 to v 11.1.1.9.1 in a time span of 18 weeks. This included the following: 

  • Technical Discovery
    – Collect information and BI object repository
    – Study and analyze object details
  • Upgrade data warehouse & BI
    – Upgrade and migrate data warehouse
    – Upgrade Oracle Analytics (from 10 g to 11g)
  • Migrate BI Repository
    – Migrate BI Rapid File Database (RPD) metadata repository
    – Migrate dashboards and reports repository
  • Upgrade ETL
    – Upgrade the ETL tool
    – Migrate ETL data mapping repository
  • Migrate Configuration & Load Data
    – Migrate application configurations
    – Load historical data 

 

Business Benefits

  • Empowered end users
  • Reduced costs
  • Enabled up-take of new capabilities

 

Technical Stack

  • Source System(s): Oracle E-Business Suite
  • Data Integration Tool: Oracle Data Integrator (ODI)
  • Monitoring Tool: Oracle BI Data Warehouse Administrative Console (DAC)
  • Reporting Tool: Oracle Analytics

To get a copy of this success story in a downloadable format with more in-depth analysis, kindly provide us a little information about yourself in the form below

DiLytics Delivers

View all Success Stories →

Manufacturing Analytics

DiLytics implemented a Manufacturing Analytics solution for a Biotechnology Company in a short period of 100 days.

Custom Data Warehouse

DiLytics implemented a custom data warehouse solution for a Leading Container Leasing Company in a short span of 150 days.

Center of Excellence

DiLytics established a Business Intelligence Center of Excellence to help a Video Game and Digital Entertainment Company maximize RoI.