briteskies-knowledge-base

AS/400 Magento Integration Tools and Strategy

Bill Onion
April 24, 2019 | 10:30 AM

as400 magento integrationThe AS/400 is a dependable workhorse that many organizations have effectively used to manage their business for years. The thought of connecting the AS/400 with a modern eCommerce system can be daunting, but integrating Magento with your AS/400 can allow business logic to remain within the existing AS/400 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 AS/400 continues to process transactions safely, securely, and quickly. 

One of the most common misconceptions with the 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 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 AS/400 platform. 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 AS/400 

Typically, integrating Magento and the AS/400 requires the use of third-party tools. We have three tools that we commonly use to connect the data on the 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 AS/400 has the capabilities 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 AS/400 and, optionally, on the external system, and provides safe and secure message delivery between your AS/400 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 AS/400 and Magento. It is more robust and contains more features than the other options.  

Integrating Magento and JD Edwards World on AS/400 

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

File Transfer Protocol (FTP) 

One way for Magento to access the data on the AS/400 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 AS/400 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 AS/400. From there, the AS/400 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 AS/400 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 AS/400 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 AS/400 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.  

IBM

A Great Offer, Just a Click Away

Lorem ipsum dolor sit amet, consectetur adipiscing elit

You May Also Like

Subscribe by Email

No Comments Yet

Let us know what you think