Application Integration Solution for Insurance Claims Processing

Problem:

An insurance company provided insurance claims processing for its client companies. It used an HPE NonStop server to perform the processing functions required for each claim and an imaging application to prepare the form letters that were the primary interaction with the clients’ customers. The imaging application ran on a Windows server and utilized a SQL database. As claims were made, they entered the NonStop claims processing system, and once processed, the pertinent information was sent manually to the imaging application on the Windows server. The system created and printed the appropriate letters, which were sent to the customers. The imaging application then returned a completion notification to the NonStop claims processing system, and informed it that the forms were generated. The company wanted a faster and more efficient system that would not only reduce letter production time, but also the number of personnel involved. HPE Shadowbase was selected to help automate this process.

HPE Shadowbase Solution: Heterogeneous Active/Active Systems

In Figure 1, claims are entered into a data feed which flows to an HPE NonStop system for processing. Then, pertinent forms information from the NonStop claims processing system is sent to a Windows SQL server imaging application via Shadowbase heterogeneous bi-directional data replication. The imaging application then creates and prints the appropriate forms, which the company mails to the insurance customer, and sends a completion notification via Shadowbase back to the NonStop claims processing system, informing it that the forms were generated.

Diagram depicting Shadowbase Heterogeneous Systems. For a full image description, please see the paragraph that starts with "In Figure 1."

Figure 1 — Shadowbase Heterogeneous Bi-directional Replication

  • The insurance company’s data is transferred bi-directionally between a NonStop SQL database on the claims processing system and an SQL server database on the imaging system, automatically and quickly generating a form letter.
  • The letter’s information and completion notification are interchanged via data replication.
  • As claims are processed, the NonStop system records the results in its database.
  • The required information is extracted from the database and is replicated to the SQL server database on the imaging system.
  • When the imaging system has generated the required letters, it notes this action in its database.
  • These notes are returned to the claims processing system, also via data replication, which then executes the claim completion sequence.

Contact us for more information on this HPE Shadowbase solution.


The above was adapted from the book: Breaking the Availability Barrier, Volume III: Active/Active Systems in Practice by Paul J. Holenstein, Dr. Bruce Holenstein, and Dr. Bill Highleyman.