Overview

Energy companies require close oversight of their revenue streams to operate efficiently. This necessitates modern technological solutions to manage the large data volumes flowing through revenue management systems.

Challenge

NITCO was tasked with integrating Oracle with Aptitude RevStream, a revenue management solution, to improve efficiency and scalability.

Solution

NITCO collaborated with the customer to design and build a new Dell Boomi integration for the revenue management system. The solution enhanced storage capacity by adding an additional hard disk to the Boomi Atom and redesigned processes following Dell Boomi’s best practices for configuration and change management.

Dell Boomi was used to:

• Connect with Oracle
• Call Oracle stored procedures
• Pull data from Oracle tables
• Convert data into XML
• Map XML to Aptitude RevStream’s target schema
• Move data to Aptitude RevStream

Benefits

• Established seamless integration between Oracle and RevStream
• Increased logging capacity of Dell Boomi Atom
• Adopted Dell Boomi’s best practices for development and deployment