Dmitriy Kuznetsov
Author Archives: Dmitriy Kuznetsov

IBM i Integration Use Cases

 

Overview

Google “Digital Transformation” and you’ll get a lot of diagrams, white papers and dire predictions for companies not fully embracing it. The common theme is business must innovate at ever increasing speed. The limitations of the traditional IT delivery model make it difficult to evolve the systems at this pace. The recipe is to let business teams rapidly deliver their own projects, by reusing core business data and logic packaged as APIs. Modern low code development tools further democratize the delivery of new UI and process layers. The result is a network of applications that address specific business capabilities, evolve rapidly and independent of other components, and communicate through common integration fabric.

It’s a great model for startups that can get up and running in no time with modern cloud-based applications such as Salesforce, Netsuite, Workday, ServiceNow (extra shot of readily available capital never hurts either). Most modern SaaS applications have been built from the ground up around core APIs, and can be easily plugged into an integration platform. By contrast, established companies are saddled with a number of applications that have been developed over time with limited or no pre-built APIs or other out of the box integration methods.

In this post I discuss typical IBM i integration use cases and summarize the technology options for plugging into application network. As we all know, for any given IT problem there is always at least a half dozen tools and methods, and often many more.  Below I list the tools our team used or evaluated. Don’t see your tool or technique of choice listed here? I appreciate if you send it to me!

Continue reading

Traits of Modern IBM i Application

I’ve read somewhere a long time ago that the secret to success is to always start visualizing it in a great many details before thinking about how to achieve it. Otherwise we risk losing sight of the end goal, and waste time and resources fighting windmills. Sure, we’ll still get somewhere, and with some practice can even convince others that this is exactly the result we’ve planned for all along. How does it apply to IBM i modernization initiatives? Before diving into discussions about modernize vs migrate, RPG or SQL, screen scrapers vs RPG Open Access vs JavaScript, DDS or DDL etc, let’s pause for a moment and think about what would the modern IBM i application look like if it were built now, with all the knowledge accumulated over the years of maintaining and enhancing it. This would be our golden standard, very helpful when deciding on the best architecture or technology choices.

Continue reading

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