case studies

Achieving Cost-Effective Migration from IBM i to Modern Applications Ensuring Seamless Integration and Data Consistency

About The Client

The client is a diversified multinational corporation with primary operations in agribusiness and transportation. Key segments include Foods (premium pork products), and Marine (containerized shipping services). The client engages in international grain processing and trading through its Commodity Trading and Milling division and has operations in sugar production, power generation, and turkey processing. The client markets products under several renowned brands with a global footprint across America, the Middle East, Africa, the Pacific Basin, and Europe.

  • Industry: Transportation
  • Headquartered: Minnesota, USA
  • Platforms: IBMi DB2, Synon CA:2E, IBM i Implementer
  • Team Size: 5–7 Experts
the_client
 

The Challenge

The client faced challenges during their migration from an IBMi-based application to a React JS and Node JS-based P2P suite application while maintaining their database on IBMi DB2. They used ER/Studio to create data models; however, they were unable to incorporate these new tables into their existing Synon-based application due to advanced database definitions that conflicted with the legacy system.

They also faced difficulties managing ‘change history’ and ‘release history’, along with other constraints imposed by ER/Studio, which created obstacles in aligning the new application with their operational needs and slowed down the migration process.

 

Our Solution

The Solution

Synon-Based Data Modeling for Seamless Legacy and Modern Application Integration

The client implemented Synon to generate the data model on the IBMi DB2 database, which enabled seamless use by both the new React JS and Node JS-based P2P suite application and the existing IBMi-based application.

The Solution

Optimizing DB2 for Compatibility with Synon-Generated Code

To capitalize on advanced DB2 features such as Varchar, Identity columns, and Row change timestamps, they updated the database definitions in the backend to ensure compatibility with Synon-generated code. For example, they modified the Identity column definition from 'Generated by Default' to 'Generated Always' to align with the application's requirements.

The Solution

Streamlining Version Control and Change Management for Seamless Integration

The client also adopted Implementer for checking out and promoting changes, which streamlined the process of managing version control and maintaining a comprehensive change history. This approach ensured consistent data integrity and facilitated smooth integration across both legacy and modern applications.

Technologies Used

Our software architects and engineers are experts in using the latest technologies.

  • IBMi DB2
    IBMi DB2
  • Synon CA:2E
    Synon CA:2E
  • Implementer
    Implementer
 

Business Impact

Our solution added value with surprising results because we were able to deliver a high-quality product on time.

Here’s how we did it

  • Re-utilized existing tools to eliminate the need for ER/Studio, resulting in significant cost savings on licensing and maintenance fees.

  • The newly generated tables were made fully compatible with the existing IBMi-based application and the new React JS and Node JS-based P2P suite application

  • By leveraging their existing technology stack, avoided additional expenditure on new tools optimizing operational costs.

  • Change history’ was effectively maintained, ensuring traceability and control over modifications.

we-did-it

Other Case Studies

Default thumbnail

Optimizing SKU Assortment and Inventory Management Through Advanced Data-Driven Reporting Solutions

The client, a majority employee-owned supermarket chain headquartered in Boise, Idaho, sought to enhance their SKU assortment initiatives by developing a reliable reporting system. They then engaged technical expertise to refine the report and improv...
View Full Success Story
Default thumbnail

Optimizing Payment Processing To Ensure Accurate Financial Reporting and Operational Efficiency for ...

The client, a majority employee-owned supermarket chain headquartered in Boise, Idaho, with operations across ten U.S. states, faced a challenge with their payment processing system. When payments applied to returned checks were deleted, the check st...
View Full Success Story

I wanted to take a moment to highlight and commemorate the efforts from our dedicated PIO team. To preface, the projects we work on here are complex, with rigid objectives, budgets, and timelines. Expectations are always high and are ever-changing. From the start of our relationship, the IO team was able to exceed expectations and make our business wishes a reality.

Project Manager

Over the past year I have worked with them, they have worked very hard to understand our highly customized system and troubleshoot things with little or no documentation while managing to keep the business up and running normally. Without the hard work and dedication they have shown, I know we would have had some issues causing downtime or lost production. I am looking forward to continuing working them in the next year as well.

Information Technology Supervisor

I have been working with Programmers IO for more than 5 years now and I have been pleased with all projects and developers that I have worked with. We have had a few issues here and there but they have always fixed and made it right. They have been an excellent addition to our business.

Director Of Development

Let’s Build Your Modernization Roadmap Together

Contact us for a free strategy session with IBM i experts.

Talk to an IBM i Expert