Monthly Archives: August 2016

Securely connect Mule to IBM i / AS400

Anyone who has been on the receiving end of a PCI audit knows that encrypting data in transit is a sensible thing to do. It’s a must have requirement for sensitive customer data, personally identifiable information and as a general rule should be applied by default unless there’s a compelling reason not to. In this article I will show how to securely connect Mule to IBM i (AS/400, iSeries, System i).

Mule flows typically communicate with IBM i data and business logic via the following transports:

  • AS400 connector – works with Data queues and system commands
  • Database connector – facilitates direct access to application data and calls to DB2 stored procedures
  • Other TCP based protocols (HTTP, FTP etc)

In this article, I will show how to setup IBM i server encryption and secure Mule Database and Data queue communications.

Continue reading

Consuming and Producing APIs on IBM i / AS400 with Mulesoft Anypoint and Web Transaction Framework

In this demo I show how to connect IBM i (AS400, iSeries, System i) data and processes with Mule and Infoview’s AS400 connector and Web Transaction Framework.

Connecting, modernizing and migrating off of legacy systems is a complex undertaking. We are a capable cross-functional team of seasoned integration and IBM i professionals focused on customer care and business outcomes. Contact us to find out how we can help making your Digital Transformation initiatives a success. 

Send data to IBM i / AS400 multi member files with MuleSoft Anypoint

On a recent call with a prospect I ran into a use case where they needed to send data to AS400 multi member files with MuleSoft Anypoint. IBM i (AS/400, iSeries, System i) operating environment includes an integrated DB2 database that is widely used as an application data store. Remote clients can access IBM i data via DB2 SQL Query Engine, JDBC or ODBC interfaces, and this works well for regular files and DB2 tables. There is a special file type widely used in older IBM i applications that supports partitioning content into multiple “members” and provides methods for isolating the data for traditional programs. The challenge of interfacing with multi-member files is that they cannot be easily accessed via standard SQL clients.

There are several “brute force” options for remotely creating and working with multi-member files in Mule, including:

Continue reading