Successful Migration to a Modern P2P Suite Enhances Operational Efficiency and Transforms Synon Tables Across a Global Corporation
About 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 operates 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:
- Platforms: IBMi DB2, Synon CA:2E, Implementer
- Team Size: 3
The Challenge
The client faced challenges migrating from an IBMi-based application to a React JS and Node JS-based P2P suite while retaining their IBMi DB2 database. The application's reliance on IBMi-generated physical and logical files created inefficiencies, as these files were only compatible with the IBMi environment. All physical and logical files were converted to tables and index views To address this issue. This conversion enabled the new application to function effectively with the existing database structure.
Our Solution
The solution involved leveraging Synon to generate DDL tables for Synon physical files and create indexes or views for Synon logical access paths, ensuring compatibility between the new P2P suite application and the existing IBMi-based application. This approach allowed both applications to effectively share and utilize the same IBMi DB2 database, maximizing efficiency and continuity.
By incorporating advanced DB2 features such as Identity and Varchar clauses, the solution enhanced data handling capabilities and optimized performance. The conversion from DDS to DDL was carefully managed to prevent data loss, maintaining complete data integrity throughout the migration process and ensuring a smooth transition to the new application environment.
Technologies Used
Our software architects and engineers are experts in using the latest technologies.
- IBMi DB2
- Synon CA:2E
- 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
-
Achieved significant cost savings by avoiding the purchase and implementation of additional tools and software.
-
Ensured complete preservation of all production data throughout the migration, maintaining data accuracy and continuity.
-
Maximized the value of the existing database by allowing seamless re-utilization across both the legacy and new applications, supporting operational efficiency and reducing disruption.
Other Case Studies
Infrastructure Migration to AWS: Enhancing Community Services Through Scalable and Secure Cloud Solu...
Revolutionizing Customer Financing with Personalized, Real-Time Sales Quotes and Advanced OCR Techno...
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.
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.
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.
Let’s Build Your Modernization Roadmap Together
Contact us for a free strategy session with IBM i experts.
Talk to an IBM i Expert