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

The initiative delivered a broad range of business benefits, including:

  • 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

 

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.

Enterprise Data Warehouse Implementation Enabled Better Business Performance

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.