IBM i (AS/400) Magento Integration Tools and Strategy

Bill Onion

Key Steps for integrating the IBM i and Magento by Adobe Commerce

The IBM i (AS/400) is a dependable workhorse that many organizations have effectively used to manage their business for years. The thought of connecting the IBM i with a modern eCommerce system can be daunting, but integrating Magento by Adobe Commerce with your IBM i ERP can allow business logic to remain within the existing system and enable the data to flow in real time to Magento.  

An integration project allows Magento to sell to customers and capture orders while the IBM i continues to process transactions safely, securely, and quickly. 

Download this integration guide to learn more

One of the most common misconceptions with the IBM i (AS/400) is that it’s impossible to interface with it. People often think that the data is simply locked in there and they can’t integrate with the system, however we have integrated many sites to IBM i (AS/400) systems and there are a number of ways to access that information.   

We love Magento projects where we need to integrate to the IBM i. We’ve found several tools and methodologies to allow the data to flow easily and quickly. Using these various tools allow us to quickly and easily access any data we need and share it across the two platforms.   

Tools for Integrating Magento and IBM i

Typically, integrating Magento and the IBM i requires the use of third-party tools. We have three tools that we commonly use to connect the data on the IBM i (AS/400) with an external eCommerce system.   

Web Services 

Web Services is a great option because there is no need to buy new software. The IBM i has the capability to create web services and host them within the native system.  

IBM WebSphere MQ Series 

A relatively inexpensive tool, WebSphere MQ delivers tremendous value to the project and team. This software tool is located on the IBM i and, optionally, on the external system, and provides safe and secure message delivery between your IBM i and Magento.  

Mule Enterprise Service Bus 

Mule ESB is used for our more complex projects and acts as a middleware between the two systems. At a base level, this tool processes transactions between the IBM i and Magento. It is more robust and contains more features than the other options.  

Integrating Magento and JD Edwards World on IBM i (AS/400)

JD Edwards World ERP runs on the IBM i, so when integrating Magento with JDE World, you’re actually integrating with the IBM i (AS/400). Here are a few ways that we access the IBM i Magento Integration Stats Infographic necessary information.  

File Transfer Protocol (FTP) 

One way for Magento to access the data on the IBM i is to use FTP and the IFS. When using the IFS to store data, another system has to do the actual deposit of the information. One option is to duplicate the data and use FTP to send it back and forth, but you can also FTP directly from the IBM i onto the IFS, then add RPG access. Once the data is on the IFS, native RPG or CL programs are used to access the data and make updates in the production environment.  

XML/RPG/WebSphere MQ 

Using this method, the eCommerce platform creates an XML document and deposits it onto the MQ channel, and MQ sends it to the IBM i. From there, the IBM i can accept the XML document and process it using native RPG programs. All of this happens at the speed of light, allowing for quick updates, data lookups, and other tasks. The communication process can also happen in the other direction, with the IBM i creating an XML document, depositing it onto MQ and sending it to the eCommerce platform, where the eCommerce platform processes the document. 

Regardless of the method used, integrating Magento to the IBM i is not as scary or difficult as many people think. There are a lot of moving parts, yes, but when broken down into individual challenges, the project quickly becomes attainable. 

Regardless of how complicated a project’s integration needs might be, our team follows six key steps for a successful integration. 

Six Key Steps for a Successful IBM i and
Magento Integration

1. Define the eCommerce Strategy

When beginning a Magento eCommerce and AS/400 integration, you first need to ask yourself a few questions: What is the site intended to do? Is it intended to primarily increase revenue, decrease costs, or improve customer satisfaction? Rank these in order of importance, with only one ranked as most important. 

2. Engage the Sales Team

Get the sales team on board. Make sure the sales team understands what role the online site will play in the company and how they can leverage the site for success. An eCommerce site can be a valuable tool in your sales teams’ arsenal to effectively and efficiently meet your customers’ needs.

3. Define the Project Leader

An eCommerce project, especially in a B2B environment, will touch almost every part of your organization: Sales and Marketing, Operations, Finance, and especially IT. There must be a champion for this endeavor within your organization, someone who will help to drive the project through to launch and ensure that it gets the TLC it deserves thereafter. 

4. Identify the Primary Data Source

Data is the lifeblood of an eCommerce engine, and the data needed for an integration project typically already exists in the AS/400. This makes it critical to set a strategy around the data integration. It is crucial to determine where each data element should be stored and which system owns the data.

5. Put the Business Logic Where it Belongs

After it’s determined whether Magento or the AS/400 owns each piece of data, consider the business logic required to process an eCommerce order. ECommerce systems typically include functionality that is duplicated in the ERP, such as item pricing, taxing, and order processing. In considering these redundancies, look to keep a business function within the system that is best suited for processing that function.

6. Use the Best Integration Methodology Available

There are several integration options available, and It’s often beneficial to use an integration methodology that is already being used, but it may make sense to change to a new technology. When deciding on which methodology to use, you need to consider the initial programming needs as well as ongoing support. Our team regularly turns to our Ten Points of Integration strategy for success. 

We love projects where we need to integrate Magento to the AS/400 platform. Using the above tools and methodologies allows the data to flow easily and quickly across the two platforms, giving you an integration that allows your organization to grow.

Are you ready to integrate your AS/400 environment with Magento? Contact our team to get started.  

*This article was originally published in 2019 and updated in February of 2024.

Start today by checking out these IBM i Commerce Integration Resources

A Great Offer, Just a Click Away

Lorem ipsum dolor sit amet, consectetur adipiscing elit

Subscribe by Email

No Comments Yet

Let us know what you think