IBM Software Systems Integration: With IBM MQ Series for JMS, IBM FileNet Case Manager, and IBM Business Automation Workflow

✍ Scribed by Alan S. Bluck

• Publisher: Apress
• Year: 2023
• Tongue: English
• Leaves: 1286
• Edition: 1
• Category: Library

✦ Synopsis

Examine the working details for real-world Java programs used for system integration with IBM Software, applying various API libraries (as used by Banking and Insurance companies). This book includes the step-by-step procedure to use the IBM FileNet Case Manager 5.3.3 Case Builder solution and the similar IBM System, IBM Business Automation Workflow to create an Audit System. 

You'll learn how to implement the workflow with a client Java Message Service (JMS) java method developed with Workflow Custom Operations System Step components. Using IBM Cognos Analytics Version 11.2, you'll be able to create new views for IBM Case Manager Analytics for custom time dimensions. The book also explains the SQL code and procedures required to create example Online Analytical Processing (OLAP) cubes with multi-level time dimensions for IBM Case Manager analytics.

IBM Software Systems Integration features the most up to date systems software procedures using tested API calls.

What You Will Learn

• Review techniques for generating custom IBM JMS code
• Create a new custom view for a multi-level time dimension
  
• See how a java program can provide the IBM FileNet document management API calls for content store folder and document replication
• Configure Java components for content engine events
  

Who This Book Is For

IT consultants, Systems and Solution Architects.

✦ Table of Contents

Table of Contents
About the Author
About the Technical Reviewer
Acknowledgments
Introduction
Chapter 1: IBM FileNet Case Manager 5.3.3 Case Builder Solution Development Steps for the Audit System
Chapter Organization
Introduction
Part 1 – Bill of Materials
Starting the IBM Case Manager System
Start the LDAP Servers
Start the IBM FileNet Case Manager Database
Start the IBM FileNet Content Engine Web Service
Start the IBM Case Manager Web Application
Load the IBM Case Manager Builder Web Application
Part 2 – IBM Case Manager Solution Metadata
Adding a New Solution
Adding Properties and Business Objects
Adding Roles
Adding Properties to the In-Baskets for Each Role
Adding Document Class
Adding Business Objects
Adding Business Object Types As Case Properties
Part 3 – Adding IBM Case Manager Case Types
Adding Case Types
Auditing Department Task
Adding Business Objects to Be Searched
Part 4 – Testing and Administration of the Audit Solution
Exporting and Production Deployment of the Audit Master Solution
Importing the Zipped Audit Master Solution to a Production System
Debugging the Case Manager Client
Procedure
Checked FileNet Version
Checked FileNet Health
Check FileNet Object Store Upgrade Status
Upgrading Status Meaning
Check FileNet Workflow Upgrade Status
Fix/Workaround for Error on Case Search
Issue Found in Case Manager Client Search in the Solution
Initial Workaround
Fix (Recommended)
Testing for the Audit Master Solution
Chapter 1 Exercises
Chapter 2: Configuring Java Custom Components
Chapter Organization
Part 1 – Supporting Documents
IBM FileNet Java API Call Examples
Java Code Development
Part 2 – Configuring Java Components for Content Engine Events
Custom Code Module Java JAR API Call Development
Adding a Code Module
Creating a Custom Event Object
Configuring Workflow Subscriptions
Creating the fn_eventshandler.jar
Part 3 – Testing the Add Document to Folder Event
Part 4 – The DbExecute Workflow Step for Calling Database Stored Procedures
The IBM Auto-Claims Case Manager Solution Example
Methods of Displaying a Case Type Task Workflow
The Case Builder Workflow Step Designer Application
The Process Designer Plugin Applet in IBM Content Navigator
Configuring the DbExecute Connection
Part 5 – Standalone Process Designer Installation
Fixing the Process Designer Shell Script Environment Variables
The DbExecute Workflow Step Addition
Procedure to Configure a DbExecute Connection in the Content Engine Store
The DbExecute Stored Procedure SQL
Configuring the Workflow for the DbExecute Step
Procedure to Add the DbExecute System Step to the Task Workflow
Stored Procedure Parameter Limitations
Example SQL Table Creation for the DB2 Database
DbExecute Stored Procedure Installation
Testing on Different Database Platforms
Oracle Version of the Stored Procedure SQL Code
MS SQL Server Version of the Stored Procedure SQL Code
Chapter 2 Exercises
Chapter 3: IBM JMS Interface Development IBM FileNet 5.5.x Workflow
Chapter Organization
Part 1 – Bill of Materials
Notification of Successful Document Load into the FileNet Target Object Store OS2
Part 2 – Custom Operations Component Development
Creating the AUD_CIOps Java Project
Adding the Supporting Library JAR Files
Installing the IBM JRE Java SDK 1.8
Creating the configuration.properties File
Creating the Test Java Package and Code
Initial Error Fixes
Configuring the Ports and Library Jar Files for IBM MQ Series
MQ Series Channel Security Settings
Create a CRL LDAP Authentication
Part 3 – Creating a Non-privileged MQ User for a Client Application Connection
Procedure
Listener Authorities
Stopping and Starting the Queue Manager
Creating a Client Channel for Messaging
Setting Up the Client on Linux
Sending a Message from a Client to a Server
Testing for Errors
Remediation for Missing Dead-Letter Queue, AUDD1
Remediation for Missing Local Queue, AUDQ1
Error Log Location
Part 4 – Second Run of the AUDOperationsTest.java JUnit for JMS Messaging
Code Now Updated As Follows for AUDOperations.java
AUDOperations Rebuild and Deploy .jar: Final Prebuild Test
Part 5 – Building the AUDOperations.jar
Rebuilding the AUDOperations.jar File
FileNet Workflow System Component AUDOperations.jar Deployment
Editing the Parameters
Checking the Deployment in Component Manager and Workflow
IBM Process Designer Component Queue Configuration
Part 6 – Transferring Workflow and Setting Up Workflow Subscriptions
Creating a Workflow Subscription on a New Audit Report Document Event
Transferring the JMS Test Workflow to the Target Object Store
Testing the Updated Audit Master Solution
Chapter 3 Exercises
Chapter 4: A Replication Java Program for IBM FileNet Object Stores
Chapter Organization
Part 1 – Bill of Materials
Part 2 – The Replication Program Introduction
Nonfunctional Requirements
Development Tools Used
The P8 5.5.5 Environment
Unit Test Data
Creator Property
Setting Object Store Access Rights
Shell Script Batch Jobs
Linux Directory Paths Required
Jars Required for Content Engine Client
Config Area
Encryption of the Administrator User Password in config.xml by the Program
Update of the Config.xml Start Date
Config.xml
log4j.xml (Updated to Fix Error Issues)
Original log4j.xml File
log4j.dtd
Static Constants for Property Types
Event Setup
Folder Class
Document Class
Unit Test Phases
Phase 1
Phase 2
Phase 3
Phase 4
Creating the Java Projects
Part 3 – Code Developed for the Replication Program
CEReplicate – 2957 Lines of Java Code – replication.jar
Project Creation
Adding the Base CEReplicate Java Code
Adding the IBM FileNet Libraries to the AUDIT_CEReplicate Classpath
Adding the Apache Commons Codec 1.5 Library
Adding the Supporting External Library JAR Files
Adding the Xerces Java Library for XML File Processing
Adding the Supporting Java Projects
Updating the Java Build Path with the Required Projects
Updating the Supporting Jar Library File Security
Updating the IBM FileNet Object Store Security
Running the Replication Program Tests
Result with the Exact GUID Copy of a Replicated Document
Part 4 – Code Listing – CEReplicateConfig
CEReplicateConfig – 502 Lines of Java Code –fn_common.jar
Part 5 – Code Listing – CEMigrateConfig
CEMigrateConfig – 425 Lines of Java Code – fn_common.jar
Part 6 – Code Listing – Supporting Utility Code
PropsUtil – 68 Lines of Java Code – fn_utils.jar
CEConnect – 67 Lines of Java Code – fn_connect.jar
CEConnection – 119 Lines of Java Code – fn_connection.jar
Chapter 4 Exercises
Chapter 5: IBM Cognos Analytics Custom Development
Bill of Materials
Development Introduction
Time Dimension SLA Calculations on Cognos
Dynamic Dimensions for Aging Bands
Initial Datasource Setup Before Adding the Custom Views
Updated Datasource Setup After Adding the Custom Views
Some More Complex Examples
Time Dimension SLA Calculations on Microsoft SQL Server Analysis Services
Enabling OLAP Integration
Dynamic Dimensions for Aging Bands
Procedure for Creating a Multilevel Dimension
Reuse of Existing Exposed Dimensions to Create a Hierarchy
SQL Statements for Table Creation and Load to Test the DepartmentName Dimension
Chapter 5 Exercises
Chapter 6: PDF Document Creation Using Java
Chapter Organization
Part 1 – Bill of Materials
Imports Used with the Test Audit Report Stub from the iText jar Library
Example 1 – A Simple Audit PDF Document
Expected Output from the AuditTest.java Code
Adding an Image to a PDF Document
Creating a PdfWriter Object
Creating an iText Document Object Class
Creating the Document Object
Creating an Image Object
Adding Images to the Document
Closing the Document
Example 2 – Test Code to Add the Audit Master Logo
Part 2 – Example 3 – An Audit Report from the Audit Master
Creating the Audit_Report Java Project
Creating the com.asb.ce.utils Java Package
Creating the AuditReportConfig Java Class
Creating the com.asb.config Package
Creating the ConfigVal Java Class
Adding the MimeType Java Code
Adding the AUDITConfig Java Code
Adding the com.ibm.filenet.ps.ciops Package
Adding the ContentElementDataSource Java Class
Adding the QOperations Java Class
Part 3 – Supporting Java Classes for the Main Audit Report Program
Adding the EmailTemplate Utility Java Class
Adding the TemplateContentElementDataSource Java Class
Adding the com.ibm.filenet.ps.ciops.database Package
Adding the DatabaseLoginModule Java Class
Adding the DatabasePrincipal Java Class
Adding the com.ibm.filenet.ps.ciops.test Package
Adding the Configuration Java Class
Adding the QOperationsTest Java Class
Adding the AUDITReportMain Java Class
Adding the Audit_Report Project Classpath Properties
Adding the iText 2.1.7 Jar File for the PDF Creation Calls
Adding the JUnit Java Test Library Jar File
Adding the Apache Commons IO Jar File
Adding the Apache Commons Lang Java 8 Language Jar File
Adding the Config Subfolder to the Audit_Reports Project
Adding the AuditTest Java Class
Adding the AuditMasterLogoTest Java Class
Adding the IBM Case Manager Audit Report Questions
Testing the Audit Report Program
Creating the log4j.xml for the Audit Report Logs
Verifying the Audit Report pdf File Structure
Creating the Audit Master Solution Workflow Audit Review Step
Part 4 – Example 4 – Create an Auditor Calendar Table in a PDF Document
Chapter 6 Exercises
Index