Remerciez-le!

Remerciez @Admin pour avoir partagé cet document gratuitement, de la manière la plus simple, en partageant sur les réseaux sociaux.

iWave Integrator User Guide Revision 5.7.20 Updated 03/01/07 www.iwavesoftware.

iWave Integrator User Guide Revision 5.7.20 Updated 03/01/07 www.iwavesoftware.com Confidential iWave Integrator User Guide iWave Software Confidential Page 2 of 276 Revised [03/01/07] P01-664-09 iWave™ Integrator User’s Guide 10th Edition, March 2007 P01-664-09 Publication Copyright Notice This document is published by the iWave Software Technical Publications Department and applies to iWave Integrator Version 5.7.20. Copyright 2007 iWave Software, LLC. All rights reserved. This software/documentation contains proprietary information of iWave Software; it is provided under a license agreement containing restrictions on use and disclosure and is also protected by copyright law. Reverse engineering of the software is prohibited. Licensee is granted permission to make a limited number of copies of the documentation for its internal business purposes only. All such copies shall bear all copyright, trade secret, trademark and any other intellectual property notices on the original copies. This limited right to reproduce for internal purposes only is not transferable. Furthermore, this limited right DOES NOT include any license to distribute, modify, display or make derivative works from the Copyrighted materials. Trademarks iWave Software, iWave Integrator, and the iWave Software logo, are trademarks of iWave Software, LLC in the USA and in other select countries. The symbols ® and ™ denote USA trademark rights. All other trademarks referenced are the property of their respective owners. Disclaimer iWave Software does not warrant that this document is error-free. The information in this document is subject to change without notice and does not represent a commitment on the part of iWave Software. No part of this document may be reproduced or transmitted in any form or by any means, electronic or mechanical, including photocopying and recording, for any purpose without the express written permission of an authorized representative of iWave Software, LLC. Address inquiries to: iWave Software 3000 Internet Blvd, Suite 200 Frisco, Texas 75034 tel: + 1 866.924.9283 fax: + 1 214.618.6754 World Wide Web: http://www.iwavesoftware.com Email: ContactUs@iwavesoftware.com iWave Integrator User Guide Contents FIGURES......................................................................................................................................... 8 TABLES .......................................................................................................................................... 9 ABOUT THIS GUIDE .................................................................................................................... 10 Notational Conventions .......................................................................................................... 10 iWave Integrator Library Information Map.............................................................................. 11 Common Books...................................................................................................................... 11 iWave Integrator Guides......................................................................................................... 12 Manual History ....................................................................................................................... 14 PART I........................................................................................................................................... 15 CONCEPTS................................................................................................................................... 15 CHAPTER 1 .................................................................................................................................. 16 INTRODUCTION TO IWAVE INTEGRATOR ............................................................................................ 16 iWave Components................................................................................................................ 17 Administering iWave............................................................................................................... 18 Enterprise Data Model............................................................................................................ 19 Transactions Between iWave Integrators .............................................................................. 20 Defining Mapping and Processing ......................................................................................... 22 Mapping File........................................................................................................................... 22 Processing File....................................................................................................................... 23 Securing Transactions............................................................................................................ 24 Specialized Processing with iWave Exits............................................................................... 25 Automatic Creation of Problem Reports................................................................................. 26 CHAPTER 2 .................................................................................................................................. 28 BASIC IWAVE INTEGRATOR CONCEPTS............................................................................................. 28 What Data is Sent from Client to Server? .............................................................................. 29 Client Object ID ...................................................................................................................... 29 Server Object ID..................................................................................................................... 31 Server Name .......................................................................................................................... 31 What Data is Returned from Server to Client?....................................................................... 31 Server Object ID..................................................................................................................... 32 Transaction Return Value.......................................................................................................32 Error Text................................................................................................................................ 32 What is Verb CREATE-UNIQUE?.......................................................................................... 33 What Causes a Client to Begin Processing a Transaction? .................................................. 33 Event Detection Mode............................................................................................................ 34 Poll Detection Mode ............................................................................................................... 34 How Does the Client Respond to Transaction Success or Failure? ...................................... 35 What is Freeform Text?.......................................................................................................... 36 Example of Freeform Text Processing................................................................................... 36 Writing Freeform Text to a Database..................................................................................... 39 CHAPTER 3 .................................................................................................................................. 40 UNDERSTANDING TABLES AND VERBS.............................................................................................. 40 Primary Tables and Subtables ............................................................................................... 40 Verbs ...................................................................................................................................... 41 Create-Unique............................................................................................................... 42 Create............................................................................................................................ 44 iWave Software Confidential Page 3 of 276 Revised [03/01/07] P01-664-09 iWave Integrator User Guide Update........................................................................................................................... 45 Lock............................................................................................................................... 45 Unlock............................................................................................................................ 46 Retrieve ......................................................................................................................... 46 Search ........................................................................................................................... 46 Verb Qualifiers........................................................................................................................ 47 CHAPTER 4 .................................................................................................................................. 48 SELECTING A DETECTION MODE....................................................................................................... 48 Event Mode ............................................................................................................................ 49 Guaranteed Delivery .............................................................................................................. 50 Responding to Transaction Delays ............................................................................... 52 Priority of Agent Requests............................................................................................. 52 Poll Mode................................................................................................................................ 53 CHAPTER 5 .................................................................................................................................. 55 UNDERSTANDING POST-PROCESSING UPDATE ................................................................................. 55 Success Codes ...................................................................................................................... 56 Failure..................................................................................................................................... 56 Responding to the Transaction Outcome............................................................................... 57 CHAPTER 6 .................................................................................................................................. 59 MAPPING AND TRANSFORMING DATA ............................................................................................... 59 iWave Integrator Data Types.................................................................................................. 59 Timestamp Fields.......................................................................................................... 61 Personal-Name Fields............................................................................................................ 62 Translate Field........................................................................................................................ 63 Planning for Data Conversion ................................................................................................ 64 NoClear Field.......................................................................................................................... 65 CHAPTER 7 .................................................................................................................................. 66 SYSTEM VARIABLES ........................................................................................................................ 66 #APP-RC#.............................................................................................................................. 66 #CLIENT-OBJECT-ID# .......................................................................................................... 67 #DATE#.................................................................................................................................. 67 #DIP-RC# ............................................................................................................................... 68 #DIP-RS# ............................................................................................................................... 68 #ERROR-TEXT# .................................................................................................................... 69 #EXIT#.................................................................................................................................... 69 #FIXED-NOW#....................................................................................................................... 71 #NOW#................................................................................................................................... 72 #NULL# .................................................................................................................................. 72 #SERVER-OBJECT-ID# ........................................................................................................ 72 #TIME#................................................................................................................................... 73 CHAPTER 8 .................................................................................................................................. 74 EXITS .............................................................................................................................................. 74 Exits Supplied with iWave Integrator...................................................................................... 75 UNIX and Windows Exits .............................................................................................. 75 z/OS Exits...................................................................................................................... 77 lpad......................................................................................................................................... 79 ltrim......................................................................................................................................... 79 pntexec................................................................................................................................... 80 pntexif..................................................................................................................................... 81 pntfrag .................................................................................................................................... 81 pntindex.................................................................................................................................. 84 iWave Software Confidential Page 4 of 276 Revised [03/01/07] P01-664-09 iWave Integrator User Guide pntinteger................................................................................................................................ 85 pntmath................................................................................................................................... 86 pntmcs (z/OS Extended MCS Console Assignment Exit)...................................................... 86 Example 1: Unrestricted System Commands ........................................................................ 89 Example 2: Restricted System Commands............................................................................ 92 pntsqlcmd ............................................................................................................................... 95 pntsqlif, PNTSQLIF ................................................................................................................ 99 pntsubst................................................................................................................................100 pntwto...................................................................................................................................100 randint...................................................................................................................................101 right.......................................................................................................................................102 rpad ......................................................................................................................................102 rtrim ......................................................................................................................................103 strlwr.....................................................................................................................................104 strupr ....................................................................................................................................105 timeconv ...............................................................................................................................105 timediff..................................................................................................................................106 timestr...................................................................................................................................108 tokenize ................................................................................................................................109 tranchr ..................................................................................................................................110 Writing Functions for Use in Exits ........................................................................................111 PART II........................................................................................................................................113 SECURING TRANSACTIONS....................................................................................................113 CHAPTER 9 ................................................................................................................................114 AUTHENTICATION AND ENCRYPTION USING SECURE SOCKETS (SSL)..............................................114 SSL Overview.......................................................................................................................114 Secure Sockets Certificates .................................................................................................115 Commercial Certificates ..............................................................................................115 Self-Signed Certificates...............................................................................................117 Secure Sockets Entropy.......................................................................................................118 PART III.......................................................................................................................................119 ADMINISTERING IWAVE INTEGRATOR ..................................................................................119 CHAPTER 10 ..............................................................................................................................120 ADMINISTERING IWAVE INTEGRATOR FROM THE COMMAND LINE OR CONSOLE.................................120 Running iWave Administrator CLI (SDDC) ..........................................................................121 Verbs Supported by the iWave Administrator CLI ......................................................123 Using UNIX Scripts to Administer iWave Integrator.............................................................126 Administering iWave Integrator from the z/OS Console ......................................................128 Stopping iWave Director..............................................................................................129 Generating a Status Report ........................................................................................129 Changing iWave Director Log Options........................................................................130 Starting Components...................................................................................................130 Stopping Components.................................................................................................130 Cycling Components ...................................................................................................131 Forcing Components to Stop ......................................................................................131 Securing Userids and Passwords with the ‘iwpasswd’ Utility...............................................131 iWave Software Confidential Page 5 of 276 Revised [03/01/07] P01-664-09 iWave Integrator User Guide PART IV.......................................................................................................................................134 APPENDIXES, GLOSSARY AND INDEX ...................................................................134 APPENDIX A...............................................................................................................................135 PROCESSING AND MAPPING FILES..................................................................................................135 Sections in the Processing and Mapping Files ....................................................................135 Purpose of the Sections in a Processing File.......................................................................137 Purpose of the Sections in a Mapping File...........................................................................138 Verb Processing and Active Sections ..................................................................................138 Create-Unique.............................................................................................................139 Search .........................................................................................................................139 Statements in Processingand Mapping Files.......................................................................140 Assignment Statements ..............................................................................................140 Mapping Statements ...................................................................................................141 Inheritance............................................................................................................................142 Keyword INCLUDE......................................................................................................144 Keyword EXCLUDE ....................................................................................................145 Value Assignments across Data Types ...............................................................................145 Assigning to Field with Different Syntax......................................................................146 Assigning Character Data to a Freeform Text Field....................................................146 Assigning Freeform Text Data to a Character Field....................................................147 Assigning an Additional Entry to a Freeform Text Field..............................................147 APPENDIX B...............................................................................................................................150 SYNTAX RULES..............................................................................................................................150 Syntax Rules ........................................................................................................................150 iWave Integrator Constants..................................................................................................150 Referencing Data Values .....................................................................................................152 Keywords whose Settings can be Referenced.....................................................................153 Relational Expressions.........................................................................................................154 Timestamp Masks ................................................................................................................155 Conversion Specifiers in Timestamp Masks ...............................................................155 Settings for SQL Interfaces .........................................................................................158 Settings for Other Interfaces .......................................................................................159 Personal-Name Masks.........................................................................................................160 APPENDIX C...............................................................................................................................163 TRANSACTION PROCESSING...........................................................................................................163 Stage 1: Data Access by the Local Client............................................................................164 Search Phase on the Client ........................................................................................164 Read Phase on the Client ...........................................................................................164 Stage 2: Processing by the Remote Server.........................................................................166 Search Phase on the Server .......................................................................................167 Read Phase on the Server..........................................................................................167 Write Phase on the Server ..........................................................................................169 Stage 3: Post-Processing Update ........................................................................................170 Understanding the Details of Search Phase ........................................................................173 Understanding the Last Steps of Write Phase .....................................................................174 APPENDIX D...............................................................................................................................176 IWAVE UNIVERSAL AGENT .............................................................................................................176 Running the Universal Agent................................................................................................176 Format ..................................................................................................................................177 UNIX and Windows NT/2000 Example of Notification Mode ...............................................184 UNIX Example of Event Mode..............................................................................................185 iWave Software Confidential Page 6 of 276 Revised [03/01/07] P01-664-09 iWave Integrator User Guide z/OS Examples.....................................................................................................................186 Preparing to Run the Agents.......................................................................................186 Invoking the Agent in Normal Mode............................................................................187 Running the Agent in Automated Mode ...............................................................................188 Purpose of a Second Agent ........................................................................................188 Configuration Steps.....................................................................................................189 Return Codes .......................................................................................................................190 APPENDIX E...............................................................................................................................192 IWAVE DIRECTOR CONFIGURATION FILE.........................................................................................192 Syntax of Statements in Configuration Files ........................................................................192 Base Section (z/OS).............................................................................................................193 Base Section (UNIX) ............................................................................................................197 Base Section (Windows) ......................................................................................................201 InternetParameters Section (z/OS) ......................................................................................205 ReceiveFrom Section (z/OS)................................................................................................206 ReceiveFrom Section (UNIX and Windows) ........................................................................206 Secure Sockets (UNIX and Windows) .................................................................................207 ReceiveFromSSL Section (UNIX and Windows) .................................................................207 ssl_recv_name Section (UNIX) ............................................................................................207 ssl_recv_name Section (Windows) ......................................................................................209 SendTo Section....................................................................................................................210 iwave_director_name Section (z/OS)...................................................................................211 iwave_director_name Section (UNIX and Windows) ...........................................................212 SendToSSL Section (UNIX and Windows) ..........................................................................216 ssl_send_name Section (UNIX and Windows) ....................................................................216 Services Section...................................................................................................................220 service_name Section (z/OS)...............................................................................................221 service_name Section (UNIX and Windows) .......................................................................225 ClientApplications Section....................................................................................................229 application_name Section (z/OS).........................................................................................230 application_name Section (UNIX and Windows) .................................................................232 Agents Section .....................................................................................................................236 agent_name Section (z/OS).................................................................................................236 agent_name Section (UNIX and Windows)..........................................................................238 APPENDIX F ...............................................................................................................................242 PRODUCT IDENTIFIERS ...................................................................................................................242 APPENDIX G...............................................................................................................................244 TERMINATION STATUS ...................................................................................................................244 GLOSSARY.................................................................................................................................246 INDEX..........................................................................................................................................254 iWave Software Confidential Page 7 of 276 Revised [03/01/07] P01-664-09 iWave Integrator User Guide iWave Software Confidential Page 8 of 276 Revised [03/01/07] P01-664-09 Figures FIGURE 1 CONNECTION.................................................................................................................... 16 FIGURE 2 IWAVE INTEGRATOR COMPONENTS.................................................................................... 17 FIGURE 3 IWAVE DIRECTORS CONTROL ONE OR MORE IWAVE INTEGRATORS .................................... 18 FIGURE 4 SINGLE POINT OF CONTROL FROM A WINDOWS MACHINE ................................................... 19 FIGURE 5 VENDOR APPLICATION DATA MAPS TO THE ENTERPRISE DATA MODEL................................ 19 FIGURE 6 TRANSLATION IS NEEDED WHEN VALUES ARE DIFFERENT................................................... 20 FIGURE 7 DATA FLOW...................................................................................................................... 21 FIGURE 8 MAPPING AND PROCESSING FILES ..................................................................................... 22 FIGURE 9 SEVERITY AND PRIORITY MAP TO SEVPRI .......................................................................... 23 FIGURE 10 ENCRYPT TRAFFIC THAT CROSSES THE INTERNET............................................................ 25 FIGURE 11 CONNECTING ENTERPRISE MANAGEMENT TO HELP-DESK APPLICATIONS .......................... 26 FIGURE 12 IWAVE INTEGRATOR CONNECTION ................................................................................... 28 FIGURE 13 EVENT DETECTION MODE................................................................................................ 49 FIGURE 14 DETECTION PORT NEEDED FOR EVENT MODE.................................................................. 50 FIGURE 15 POLL MODE.................................................................................................................... 53 FIGURE 16 ISSUING AN Z/OS COMMAND IN THE EXTENDED MCS CONSOLE........................................ 87 FIGURE 17 SAMPLE RESPONSE FROM CONSOLE COMMAND............................................................... 88 FIGURE 18 SETTINGS FOR uploads/Finance/ iwave-integrator-users-guide-pdf.pdf