case studies

TMS Migration and Middleware Implementation

About The Client

A premier provider of trucking based logistic services for customers across the United States in divisions including standard flatbed, tankers, and refrigeration transport. For the customer team, their IBM i based TMS system was the source of truth, but posed challenges as the business pursued a new cloud based TMS system and needed to migrate data from the old TMS to the new cloud-based system.

  • Industry: Freight transport and logistics
  • Headquartered: US
  • Platforms: infoConnect & infoCDC, IBM i (AS400), Cloud TMS Platform,
  • Team Size: Multinational
the_client
 

The Challenge

Running key lines of business applications on a heavily customized IBM i (AS400) based TMS system, the customer was in process of transitioning some functionality of the existing IBM i based TMS to a new cloud-based solution. During the transitioning period, both the existing TMS and new cloud-based system needed to be bi directionally in sync in real time to eliminate or minimize the business process overhead and reduce the need for ops teams to work with both systems (avoid “swivel chair” approach).

The pre-existing integration design entailed a custom windows-based middleware that translated data flow between the IBM i and cloud TMS based applications. Limited re-use, inability to process real time transactions, custom development heavy, potential IBM i performance degradation as the number of interfaces grew, and security risks were all contributing factors to consider as the customer team sought third party assistance to confirm or adjust their integration design.

 

Our Solution

Our team partnered with the customer to design and implement a modern, scalable integration architecture. After a detailed discovery and proof-of-concept phase, the team replaced the legacy Windows-based middleware with an enterprise-grade integration platform deployed on-premises.

The Solution

Real-time, bi-directional synchronization

Between IBM i (AS/400) and the cloud-based TMS.

The Solution

infoConnect Connector

To securely expose IBM i business logic and enable direct integration with middleware.

The Solution

infoCDC (Change Data Capture)

To replicate database changes in near real-time, ensuring data consistency across platforms.

The Solution

Enterprise integration capabilities

Such as monitoring, CI/CD automation, and performance tuning for thousands of transactions per second.

The Solution

Knowledge transfer and training

For the customer’s IT team, supported by Our team 24/7 global operations team with SLA-driven support.

The Solution

Using middleware + an AS400 connector

To send messages, queue, and call IBM i programs directly from middleware

Technologies Used

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

  • infoConnect & infoCDC
    infoConnect & infoCDC
  • Cloud TMS Platform
    Cloud TMS Platform
  • IBM i (AS/400)
    IBM i (AS/400)
 

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

  • Seamless Transition

    Enabled smooth migration from IBM i–based TMS to the cloud platform with zero disruption to daily operations.

  • Operational Efficiency

    Eliminated swivel-chair processes by keeping both systems synchronized in real time.

  • Data Accuracy & Consistency

    Improved the reliability of business data across platforms and reduced manual reconciliation.

  • Scalability & Performance

    Delivered a high-performance integration capable of processing thousands of secure transactions per second.

  • Modernization with Reuse

    Preserved existing IBM i investments while modernizing the integration approach.

we-did-it

Other Case Studies

Default thumbnail

Mulesoft Success Story

Infoview Systems’ “Unlocking Data and Processes” modernizes legacy IBM i (AS/400) ERP systems by enabling seamless integration, real-time data access, and reusable business processes....
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