Informatica to ODI Migration using InfatoODI tool and Discoverer Upgrade

Informatica to ODI Migration using InfatoODI tool and Discoverer Upgrade, achieving automation by almost 60%, & helped reduce risk and increased process quality by 70%.

About the Client

EPCOR is a utility company that provides clean water, wastewater and drainage services, electricity, natural gas, and safe, reliable energy to residential and commercial customers. EPCOR operates in Canada and the United States, catering to over 2 million customers.

Client Speak

iconCongrats! We are live in production. Great job to the team.

  • All numbers are matching as per EBS.
  • EPCOR has been able to complete all tasks without any issues and seamlessly.
  • System speed and performance is great as compared to the former version.
  • EPCOR is very excited, and after week one, they believe it is a zero-defect system.icon


- Jon Harkness

Business Challenges

  • Excessive dependency on existing OBIA reporting environment
  • Mappings to be converted were more complex than expected
  • BI Apps best practices not implemented for custom data marts. This resulted in lesser Infa2ODI automation
  • HRDM data mart was very complicated and required significant performance tuning
  • Manual report testing of 400+ reports as the Oracle provided BVT tool did not work
  • Multi-EBS implementation for Discoverer to OBIEE