Data integration – Oracle database

Oracle database integration for a Healthcare company

The Problem

A healthcare company set out to capture and log details of support services provided to their customer to provide their support team, nurses and coaches with comprehensive historical data when in the field servicing customers. This required the integration of data from multiple sources within the organisation.

Our Solution

In a nutshell:

  • Mule was used to orchestrate disparate data sources to aggregate and archive data
  • Mule was also used to streamline batch processes used for bulk uploads of customer data

Ricston’s solution was to configure Mule ESB Enterprise Edition (EE) to listen for HTTP requests fired by the web application used by Companies customer support team to log information about calls, fetch data from various Oracle relational and XML databases including aggregating different pieces of data into a single payload, and finally store the new information back into the database. With the first part of the project complete, Ricston’s consultants then used Mule ESB EE in a slightly different way, as a batch engine.

Every couple of days, the entire customer database required updating through a batch process. Mule controlled this process by reading batches of data from the database, and through using its internal VM queues, Ricston consultants were able to successfully make the process as parallel as possible with little effort.

Send Ryan a message

Ryan Delia
Services Director