[vc_section full_width=”stretch_row” css=”.vc_custom_1764231338483{margin-top: 0px !important;margin-bottom: 0px !important;padding-top: 35px !important;padding-bottom: 0px !important;background-color: #ffffff !important;}”][vc_row full_width=”stretch_row” css=”.vc_custom_1764242243988{margin-top: 0px !important;margin-bottom: 0px !important;padding-top: 35px !important;}”][vc_column css=”.vc_custom_1764231401597{padding-top: 0px !important;padding-bottom: 0px !important;}”][vc_column_text css=”” el_class=”text-block”]
Business Intelligence Application Upgrade Enabled to Stay Oracle-Support Compliant and Up-Take New Capabilities
[/vc_column_text][vc_column_text css=”.vc_custom_1764234926595{margin-top: 0px !important;margin-bottom: 10px !important;}” el_class=”text-block”]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: [/vc_column_text][rt_list_style list_style=”seven” list_css=”.vc_custom_1764243197283{margin-bottom: 10px !important;padding-left: 35px !important;}” list_extra_class=”text-block”]
- Technical Discovery
[/rt_list_style][rt_list_style list_style=”seven” list_css=”.vc_custom_1764243266596{margin-bottom: 10px !important;padding-left: 70px !important;}” list_extra_class=”text-block”]- Collect information and BI object repository[/rt_list_style][rt_list_style list_style=”seven” list_css=”.vc_custom_1764243279340{margin-bottom: 10px !important;padding-left: 70px !important;}” list_extra_class=”text-block”]- Study and analyze object details
[/rt_list_style][rt_list_style list_style=”seven” list_css=”.vc_custom_1764243305324{margin-bottom: 10px !important;padding-left: 35px !important;}” list_extra_class=”text-block”]
- Upgrade data warehouse & BI
[/rt_list_style][rt_list_style list_style=”seven” list_css=”.vc_custom_1764243339050{margin-bottom: 10px !important;padding-left: 70px !important;}” list_extra_class=”text-block”]- Upgrade and migrate data warehouse[/rt_list_style][rt_list_style list_style=”seven” list_css=”.vc_custom_1764243360890{margin-bottom: 10px !important;padding-left: 70px !important;}” list_extra_class=”text-block”]- Upgrade Oracle Analytics (from 10 g to 11g)[/rt_list_style][rt_list_style list_style=”seven” list_css=”.vc_custom_1764243381078{margin-bottom: 10px !important;padding-left: 35px !important;}” list_extra_class=”text-block”]
- Migrate BI Repository
[/rt_list_style][rt_list_style list_style=”seven” list_css=”.vc_custom_1764243399908{margin-bottom: 10px !important;padding-left: 70px !important;}” list_extra_class=”text-block”]- Migrate BI Rapid File Database (RPD) metadata repository[/rt_list_style][rt_list_style list_style=”seven” list_css=”.vc_custom_1764243422715{margin-bottom: 10px !important;padding-left: 70px !important;}” list_extra_class=”text-block”]- Migrate dashboards and reports repository
[/rt_list_style][rt_list_style list_style=”seven” list_css=”.vc_custom_1764243607837{margin-bottom: 10px !important;padding-left: 35px !important;}” list_extra_class=”text-block”]
- Upgrade ETL
[/rt_list_style][rt_list_style list_style=”seven” list_css=”.vc_custom_1764243510876{margin-bottom: 10px !important;padding-left: 70px !important;}” list_extra_class=”text-block”]- Upgrade the ETL tool
[/rt_list_style][rt_list_style list_style=”seven” list_css=”.vc_custom_1764243485547{margin-bottom: 10px !important;padding-left: 70px !important;}” list_extra_class=”text-block”]- Migrate ETL data mapping repository[/rt_list_style][rt_list_style list_style=”seven” list_css=”.vc_custom_1764243617523{margin-bottom: 10px !important;padding-left: 35px !important;}” list_extra_class=”text-block”]
- Migrate Configuration & Load Data
[/rt_list_style][rt_list_style list_style=”seven” list_css=”.vc_custom_1764243542618{margin-bottom: 10px !important;padding-left: 70px !important;}” list_extra_class=”text-block”]- Migrate application configurations[/rt_list_style][rt_list_style list_style=”seven” list_css=”.vc_custom_1764243574299{margin-bottom: 35px !important;padding-left: 70px !important;}” list_extra_class=”text-block”]- Load historical data
[/rt_list_style][vc_column_text css=”” el_class=”text-block”]
Business Benefits
[/vc_column_text][vc_column_text css=”.vc_custom_1764220656362{margin-bottom: 10px !important;}” el_class=”text-block”]The initiative delivered a broad range of business benefits, including:[/vc_column_text][rt_list_style list_style=”seven” list_css=”.vc_custom_1764243641988{margin-bottom: 35px !important;padding-left: 35px !important;}” list_extra_class=”text-block”]
- Empowered end users
- Reduced costs
- Enabled up-take of new capabilities
[/rt_list_style][vc_column_text css=”” el_class=”text-block”]
Technical Stack
[/vc_column_text][vc_column_text css=”.vc_custom_1764235035609{margin-bottom: 0px !important;}” el_class=”text-block”]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
[/vc_column_text][/vc_column][/vc_row][/vc_section][vc_row full_width=”stretch_row” equal_height=”yes” content_placement=”middle” css=”.vc_custom_1764231422347{margin-top: 0px !important;margin-bottom: 0px !important;padding-top: 35px !important;padding-bottom: 75px !important;background-color: #ffffff !important;background-position: center !important;background-repeat: no-repeat !important;background-size: cover !important;}”][vc_column width=”1/3″ css=”.vc_custom_1531997568277{margin-top: 0px !important;margin-bottom: 10px !important;padding-top: 0px !important;padding-bottom: 0px !important;}”][/vc_column][vc_column width=”1/3″][vc_column_text css=”” el_class=”text-block”]
DiLytics Delivers
[/vc_column_text][/vc_column][vc_column width=”1/3″][vc_custom_heading text=”View all Success Stories →” font_container=”tag:h6|font_size:16px|text_align:right|color:%23dd3333|line_height:26px” use_theme_fonts=”yes” css=”.vc_custom_1660717315754{margin-top: 0px !important;margin-bottom: 10px !important;}” el_class=”font-weight-medium” link=”url:https%3A%2F%2Fdilytics.com%2Fsuccess-stories%2F|title:Success%20Stories”][/vc_column][vc_column][rt_case_study_style case_study_style_variation=”seven” case_study_display_filter=”no” case_study_enable_title=”yes” case_study_enable_excerpt=”yes” case_study_spacing=”30″ case_study_looping_sort=”ASC” no_of_case_studies=”3″][/vc_column][/vc_row][vc_row][vc_column][vc_empty_space][/vc_column][/vc_row]