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
