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:
In this article, I will show how to setup IBM i server encryption and secure Mule Database and Data queue communications.
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.
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: