IBM AS400 Web Transaction Framework and Mulesoft AS400

IBM AS/400 Web Transaction Framework and Mulesoft AS/400 Connector Demo for Partners and Customers

Challenge: Traditional IT is too slow for Business Demands May 25, 2016 2

Solution: Application Network Right Operational Model IT becomes Center for Enablement. Enables business to complete their own projects by providing reusable assets / APIs. Right Technology Anypoint is a single platform to develop, operate, collaborate and discover APIs Right Implementation Partner with experienced implementation consultants to get it right from the first try and accelerate the success May 25, 2016 3

APIs are building blocks of Application Network May 25, 2016 4

IBM i (AS/400) “last mile” service Unlocking IBM i data and processes takes time Consume API Provide API May 25, 2016 5

Mulesoft Anypoint, AS/400 connector and Web Transaction Framework - Consistent architecture approach for providing and consuming APIs on IBM i Uses native IBM i functions, no extra servers to maintain Enables rapid implementation with included demos May 25, 2016 6

IBM i Integration Use Cases API Provider API Consumer • Unlock the IBM i application data • Execute IBM i business logic • Receive and process external business events on IBM i May 25, 2016 • Access external data from IBM i application • Execute external logic from IBM i • Publish IBM i business events 7

IBM AS/400 Connector for Mulesoft Anypoint platform Functionality and Motivation • Speeds up IBM i API consumer use case development by hiding complexities of integrating with AS/400 based systems • Enables native zero-footprint messaging between AS/400 and Mulesoft ESB using AS/400 Data Queues • Supports Data Queue Listen, Read, Write as well as AS/400 System Command call operations • Mulesoft Certified connector May 25, 2016 8

Web Transaction Framework Overview Functionality and Motivation • Speeds up IBM i integration development both for providing and consuming APIs • Provides Consistent Architecture for all IBM i integrations • Enables native zero-footprint messaging between AS 400 and external systems such as Mulesoft ESB with AS/400 connector • Service Registry is a repository for all IBM i interface configurations • Transaction Insight consolidates the runtime data for real time monitoring and alerting, as well as analytics May 25, 2016 9

Live Demo 1 IBM i consumes Currency Exchange API Web Transaction Framework May 25, 2016 10

Demo 1 IBM i as API consumer Architecture IBM i team only needs to implement the interface program that saves the request data into staging table(s) then retrieves and passes back the API response from response staging table(s). Mule team implements the API client, certificates, reconnection, data transformation etc Mule AS 400 Web Transaction Framework Service Registry (TRNTYPES) Transaction history (TRNHDR) Transaction Errors (TRNLOG) ERP Data Queue – JMS Bridge API Client Request DQ Order Entry POS Inventory Merchandising Etc Interface Programs Create (CRTTRN) Process (PRCTRN) AS 400 Connector Data Queue Adapter AS 400 Connector Response DQ Database Connector Request and Response Staging

Demo 1 IBM i as API consumer Flow Diagram May 25, 2016 12

Demo 1 IBM i as API consumer Mule flow – no custom Java components, standard Mule source and processors for AS 400 operations May 25, 2016 13

Demo 1 IBM i as API consumer RPG source code sample – no data queue or integration logic, just simple I/O operations May 25, 2016 14

Live Demo 2 IBM i provides Product Price API Web Transaction Framework May 25, 2016 15

Demo 2 IBM i as API provider Mule team implements API, data transformation, serializing request and response into staging, calling Web Transaction Framework DB 2 procedures Mule IBM i team implements interface program to handle request and response staging tables IBM i Web Transaction Framework Service Registry (TRNTYPES) Transaction history (TRNHDR) Transaction Errors (TRNLOG) APIs Database Connector ERP Interface Programs Create and Process Transaction Request and Response Staging

Demo 2 IBM i as API provider Flow Diagram

Demo 2 IBM i as API provider Mule flow – trigger IBM i transaction processing, no custom Java code needed May 25, 2016 18

About Infoview Systems • Since 1994, we specialized in implementation, enhancements and support for complex ERP and Line of Business applications based on AS/400 platform • Starting in early 2000 s, expanded into System Integration / Service Oriented Architecture, connected legacy systems to partners, vendors and customers. Worked with variety of tools from IBM, Microsoft, Software AG, Informatica, Mulesoft • In 2014 we focused on growing our integration practice, and partnered with Mulesoft in 2015 • Products: IBM AS/400 Connector for Mulesoft Anypoint platform, AS/400 Web Transaction Framework • Services: Application Integration Strategy, Solution Architecture, Development, Training and Support, specializing in Mulesoft Anypoint platform, IBM i (AS/400), Java May 25, 2016 19