Upgrade the Oracle BI Apps 7.9.6.X to Oracle BI Apps 220.127.116.11. Migrate ETL code from Informatica to ODI and upgrade OBIEE 11g to 12c.
The company evaluated many consulting companies but selected KPI Partners because of KPI's expertise in BI APPS, Informatica, ODI, and OBIEE. In addition, KPI proposed a team with 100% offshore team resources to minimize cost and risk for the customer.
What KPI Delivered
KPI proposed Upgradation of Oracle BI Apps 18.104.22.168 (Informatica version) to Oracle BI Apps 22.214.171.124 (ODI Version) from multiple source systems like PSFT, Primavera, SQL Server, and flat-files. Upgradation has been done on Oracle Financials, Project and Supply Chain, and HR Analytics.
We have installed and configured BI Apps 126.96.36.199.1. Converted 500+ mappings from Informatica to ODI which includes ROV and other custom mappings. Customized the load plan in an optimal way to increase the ELT load performance. Enabled usage tracking and email configuration in ODI for load notifications.
Upgraded OBIEE 11g to 12c using bar file and configured the security as it was in OBIEE 11g. More than 600 reports were validated and updated the data model in RPD as per BI Apps standards. Created BI publisher reports on SQL server tables based on Client requirements.
We have Developed ELT mappings and reports for the Quality custom module.
The new BI Apps version with ODI reduces the load time and server cost. It also helped and encouraged the team to find key new further of the ELT tool and OBIEE 12c which help their business grow.