Skip to content

JD Edwards Integration with North America JD Edwards

Case Studies

About Manufacturing Company

KPI's client is a subsea engineering and applied technology company based in Houston, Texas, U.S, that provides engineered services and hardware to customers who operate in marine, space, and other environments.


  • jdewards_KPI Partners
  • OBIEE-KPI Partners
  • SQL Server KPI Partners
  • ODI KPI Partners

Business Driver

Upgrade the Oracle BI Apps 7.9.6.X to Oracle BI Apps Migrate ETL code from Informatica to ODI and upgrade OBIEE 11g to 12c.


Selection Process

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 (Informatica version) to Oracle BI Apps (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 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.


Business Benefits

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.


Comments not added yet!

Your future starts today. Ready?