Search in book...
Toggle Font Controls
Create new playlist

Name your new playlist

Playlist description (optional)
Sign In

Email address

Password

Forgot Password?

or

Continue with Facebook

Continue with Google
Sign Up

Full Name

Email address

Confirm Email Address

Password

or

Continue with Facebook

Continue with Google

Alan S. Bluck

IBM Software Systems Integration

With IBM MQ Series for JMS, IBM FileNet Case Manager, and IBM Business Automation Workflow

The Apress logo.

Alan S. Bluck

Ashley Heath, Hampshire, UK

ISBN 978-1-4842-8860-3e-ISBN 978-1-4842-8861-0

https://doi.org/10.1007/978-1-4842-8861-0

This work is subject to copyright. All rights are solely and exclusively licensed by the Publisher, whether the whole or part of the material is concerned, specifically the rights of translation, reprinting, reuse of illustrations, recitation, broadcasting, reproduction on microfilms or in any other physical way, and transmission or information storage and retrieval, electronic adaptation, computer software, or by similar or dissimilar methodology now known or hereafter developed.

The use of general descriptive names, registered names, trademarks, service marks, etc. in this publication does not imply, even in the absence of a specific statement, that such names are exempt from the relevant protective laws and regulations and therefore free for general use.

The publisher, the authors, and the editors are safe to assume that the advice and information in this book are believed to be true and accurate at the date of publication. Neither the publisher nor the authors or the editors give a warranty, expressed or implied, with respect to the material contained herein or for any errors or omissions that may have been made. The publisher remains neutral with regard to jurisdictional claims in published maps and institutional affiliations.

This Apress imprint is published by the registered company APress Media, LLC, part of Springer Nature.

The registered company address is: 1 New York Plaza, New York, NY 10004, U.S.A.

Dedicated to

my beloved wife, Jennifer,

and

my children, Julie and Rosalie,

and

their families

Introduction

This book describes the design and build of an Audit Master System for ISO9000/BS5750 internal quality system audits, implemented using the IBM Case Manager Builder web application.

This system is then extended from the initial working IBM Case Manager solution to demonstrate a number of Java-based integrations to show the possibilities of integration with other systems, using the IBM FileNet Content Manager API, IBM MQ Series, JMS Java API calls, and the IBM Process Designer Workflow application.

The fully working integrations are described step by step, including

The replication and synchronization of documents and the Case Manager folder system to another Object Store.
The transfer of the Case metadata to an IBM MQ Series queue using JMS Java calls. This is demonstrated with the use of an IBM Process Designer Workflow, Java library Operations Step method to call the JMS (Java Messaging Service) with the Case data.
The creation and deployment of a Custom Java EventHandler Code Module to automatically link the separate Case Audit Report documents to a central folder.
The implementation of a workflow step to call a database Stored Procedure to store the Case Audit metadata to a separate database system.
The creation of graphical analytical summary data using the IBM Cognos Analytics system and the extension of the IBM Case Analyzer OLAP Event table database to use custom Views for date range and multilevel Time Dimensions using the Cognos links to a Microsoft SQL Server Analysis Manager system.
The use of Java iText library methods to generate pdf Audit Report questions from the Case Management data, which are then stored against a Department Case Document folder.

This book is designed for use by IT consultants, Systems and Solution Architects with basic general IT knowledge to provide working templates for the development of solutions using IBM software products to integrate diverse corporate systems, and for developers of document management, workflow, and case management solutions for implementation in manufacturing organizations, banks, and insurance companies.

Acknowledgments

There are a few people whom I want to thank for the continued and ongoing support that they gave me while I wrote this book. First and foremost, I would like to thank my wife, Jenny, for continuously encouraging me to write the book – I could never have completed this book without her support.

I am grateful to the excellent online courses and materials provided by Red Hat (www.redhat.com) and IBM RedBooks (www.redbooks.ibm.com).

I would also like to extend my gratitude to the team at Apress for their support in the editing and publication of the book, and the technical reviewer, Giles Metcalf, for his helpful suggestions and diligence.

Table of Contents

Chapter 1: IBM FileNet Case Manager 5.3.3 Case Builder Solution Development Steps for the Audit System1

Chapter Organization1

Introduction2

Part 1 – Bill of Materials3

Starting the IBM Case Manager System6

Part 2 – IBM Case Manager Solution Metadata11

Adding a New Solution11

Adding Properties and Business Objects13

Adding Roles15

Adding Properties to the In-Baskets for Each Role21

Adding Document Class23

Adding Business Objects27

Adding Business Object Types As Case Properties43

Part 3 – Adding IBM Case Manager Case Types44

Adding Case Types44

Adding Business Objects to Be Searched54

Part 4 – Testing and Administration of the Audit Solution70

Exporting and Production Deployment of the Audit Master Solution98

Debugging the Case Manager Client114

Checked FileNet Version118

Checked FileNet Health119

Check FileNet Object Store Upgrade Status120

Fix/Workaround for Error on Case Search123

Fix (Recommended)131

Chapter 1 Exercises139

Chapter 2: Configuring Java Custom Components143

Chapter Organization144

Part 1 – Supporting Documents144

IBM FileNet Java API Call Examples144

Java Code Development145

Part 2 – Configuring Java Components for Content Engine Events146

Custom Code Module Java JAR API Call Development179

Creating a Custom Event Object188

Configuring Workflow Subscriptions193

Creating the fn_eventshandler.jar199

Part 3 – Testing the Add Document to Folder Event205

Part 4 – The DbExecute Workflow Step for Calling Database Stored Procedures251

The IBM Auto-Claims Case Manager Solution Example251

Methods of Displaying a Case Type Task Workflow252

The Case Builder Workflow Step Designer Application255

The Process Designer Plugin Applet in IBM Content Navigator258

Configuring the DbExecute Connection271

Part 5 – Standalone Process Designer Installation276

Fixing the Process Designer Shell Script Environment Variables290

The DbExecute Workflow Step Addition298

The DbExecute Stored Procedure SQL304

Configuring the Workflow for the DbExecute Step307

Stored Procedure Parameter Limitations311

Example SQL Table Creation for the DB2 Database312

Testing on Different Database Platforms329

Oracle Version of the Stored Procedure SQL Code330

MS SQL Server Version of the Stored Procedure SQL Code331

Chapter 2 Exercises332

Chapter 3: IBM JMS Interface Development IBM FileNet 5.5.x Workflow335

Chapter Organization336

Part 1 – Bill of Materials337

Part 2 – Custom Operations Component Development386

Part 3 – Creating a Non-privileged MQ User for a Client Application Connection458

Procedure458

Listener Authorities478

Stopping and Starting the Queue Manager486

Creating a Client Channel for Messaging491

Setting Up the Client on Linux493

Sending a Message from a Client to a Server495

Testing for Errors495

Part 4 – Second Run of the AUDOperationsTest.java JUnit for JMS Messaging558

Code Now Updated As Follows for AUDOperations.java559

AUDOperations Rebuild and Deploy .jar: Final Prebuild Test570

Part 5 – Building the AUDOperations.jar575

Rebuilding the AUDOperations.jar File583

FileNet Workflow System Component AUDOperations.jar Deployment584

Editing the Parameters604

IBM Process Designer Component Queue Configuration607

Part 6 – Transferring Workflow and Setting Up Workflow Subscriptions623

Creating a Workflow Subscription on a New Audit Report Document Event623

Transferring the JMS Test Workflow to the Target Object Store626

Testing the Updated Audit Master Solution635

Chapter 3 Exercises644

Chapter 4: A Replication Java Program for IBM FileNet Object Stores647

Chapter Organization648

Part 1 – Bill of Materials648

Part 2 – The Replication Program Introduction650

Nonfunctional Requirements652

Development Tools Used653

The P8 5.5.5 Environment654

Unit Test Data656

Creator Property657

Setting Object Store Access Rights658

Linux Directory Paths Required663

Jars Required for Content Engine Client667

Static Constants for Property Types682

Event Setup684

Unit Test Phases687

Creating the Java Projects698

Part 3 – Code Developed for the Replication Program699

CEReplicate – 2957 Lines of Java Code – replication.jar699

Project Creation704

Part 4 – Code Listing – CEReplicateConfig760

CEReplicateConfig – 502 Lines of Java Code –fn_common.jar862

Part 5 – Code Listing – CEMigrateConfig878

CEMigrateConfig – 425 Lines of Java Code – fn_common.jar878

Part 6 – Code Listing – Supporting Utility Code891

PropsUtil – 68 Lines of Java Code – fn_utils.jar891

CEConnect – 67 Lines of Java Code – fn_connect.jar893

CEConnection – 119 Lines of Java Code – fn_connection.jar895

Chapter 4 Exercises899

Chapter 5: IBM Cognos Analytics Custom Development903

Bill of Materials903

Chapter 5 Exercises989

Chapter 6: PDF Document Creation Using Java991

Chapter Organization991

Part 1 – Bill of Materials993

Imports Used with the Test Audit Report Stub from the iText jar Library993

Example 1 – A Simple Audit PDF Document994

Example 2 – Test Code to Add the Audit Master Logo1000

Part 2 – Example 3 – An Audit Report from the Audit Master1002

Part 3 – Supporting Java Classes for the Main Audit Report Program1152

Part 4 – Example 4 – Create an Auditor Calendar Table in a PDF Document1263

Chapter 6 Exercises1267

Index1271

About the Author and About the Technical Reviewer

About the Author

Alan S. Bluck

has over 45 years of IT experience. He has been a Solutions Architect for IBM for over 10 years. Elected as an IBM Champion (2022), he is now the director and owner of ASB Software Development Limited, an IBM PartnerWorld partner, and a consultancy providing systems architecture for a broad range of services. He is a Member of the British Computer Society (MBCS, CITP).

About the Technical Reviewer

Giles Metcalf

has been a software architect in the process, content, and case management arena for more than 20 years. With extensive experience in the Financial Services market, he is keenly interested in integrating modern solutions with legacy systems, as well as enhancing the flow of information through organizations. He has worked with most of the high-street banks, as well as many other institutions. He has recently moved into the Identity and Access Management sphere.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.

Table of Contents for Front Matter

Create new playlist

Sign In

Sign Up

IBM Software Systems Integration

With IBM MQ Series for JMS, IBM FileNet Case Manager, and IBM Business Automation Workflow

Table of Contents for
Front Matter