2400 Meadowbrook Parkway, Duluth, GA 30096 | +1 770-493-5588 Follow Us
Select Page

Case Study

SOM Accelerator reduced the manual efforts by 60-75% as compared to traditional methods.

Client Background

The client is a diversified, multi-national FORTUNE® 50 health insurance provider in the US which offers various health insurance plans under Medicaid, Medicare and commercial lines of business.

Client Need

  • Define the scope of the program after analyzing the existing legacy system, without causing any hindrances to operations.
  • To support the growth and scalability projections and to better align with future state enterprise architecture, needed to migrate the following to Oracle Exadata:
    • Legacy data with iterative loads in different phases of the project for 2000+ tables.
    • Application .NET code and active services including ETL, Reporting related objects for more than 200+ applications.
    • Database objects with 1800+ artefacts.

Our Solution

  • Analyzed the list of applications active in Sybase, identified dependencies, and performed impact analysis.
  • Utilized SOM Accelerator For DB objects and schema conversion which reduced the manual effort by about 60-75%.
  • Analyzed the .NET and VB applications and converted so ensure compatibility with Oracle.
  • Performed integration testing and automated the validation using custom applications and ETL jobs.
  • Utilized SOM accelerator for extraction, transformation, and loading of data from Sybase to Oracle with the added functionalities of notifications, failover and auditing mechanism.
  • Automated validation of data through SSIS Packages. Migrated ~11 TB in 45 hours for 2000+ tables.
  • Migrated DataStage Jobs and WebFOCUS reports from Sybase to Oracle
  • Implemented CI/CD for deployments across various environments and validating the applications.

Tools & Technologies

Sybase, Oracle, IBM DataStage, Python, .NET, VB.NET, WebFOCUS

Key Benefits

  • Successfully completed the migration before the open-enrollment period.
  • Post-completion of Sybase to Oracle migration, improved the performance of the applications by 20%.
  • Automated code conversion to successfully reduce manual effort by 60-75%.
  • The SOM accelerator creates developer-friendly manual intervention runs to identify the exact changes and code block for further changes.
  • Enabled developers to easily inspect areas that need manual intervention and modify the code accordingly.
  • Increased the scalability to the core platform to easily integrate with future state architecture changes.
Key benefits for converting Sybase Database to Oracle by using SOM Accelerator

Let's Connect

Talk to us and know how our over two decades of experience and a strong global presence can transform your business.


Digital Product Engineering

Cloud Services

Data & Analytics

Intelligent Automation

Cyber Security

Build Operate Transfer

Talent Solutions


Communication & Media


Healthcare, Life Sciences,
and Insurance

Banking & Financial Services

Energy and Utilities



Transportation and Logistics

Innovation @ Work

Blogs and Insights

Research and Whitepapers

Case Studies


Webinars & Tech Talks
US Employment Reports


About Us


Strategic Partnerships

Office Locations

News and Events

The Foundation


Open Positions

Life @ Innova Solutions

Candidate Resource Library

Let's Connect