IBM Sterling Managed File Transfer Integration With WebSphere .
Front coverIBM Sterling Managed FileTransfer Integration withWebSphere Connectivity for aMulti-Enterprise SolutionUsing Sterling File Gateway and Sterling B2BIntegrator for robust managed file transferExtending file transfer capabilities withWebSphere Message BrokerIntegrating Sterling Connect:Direct withWebSphere MQ File Transfer EditionJennifer FoleyKentaroh KidoStephen LitzkowKieran ScottDerek Tuckeribm.com/redbooks
International Technical Support OrganizationIBM Sterling Managed File Transfer Integration withWebSphere Connectivity for a Multi-EnterpriseSolutionMarch 2011SG24-7927-00
Note: Before using this information and the product it supports, read the information in “Notices” onpage ix.First Edition (March 2011)This book applies to IBM WebSphere Message Broker V7.0.0.1, IBM WebSphere MQ V7.0.1, IBM WebSphere MQ File Transfer Edition V7.0.3, IBM Sterling File Gateway V2.1, IBM Sterling B2B IntegratorV5.1, and IBM Sterling Connect:Direct V4. Copyright International Business Machines Corporation 2011. All rights reserved.Note to U.S. Government Users Restricted Rights -- Use, duplication or disclosure restricted by GSA ADP ScheduleContract with IBM Corp.
ContentsNotices . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ixTrademarks . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .xPreface . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xiThe team who wrote this book . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xiNow you can become a published author, too! . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xiiiComments welcome. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xiiiStay connected to IBM Redbooks . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xiiiChapter 1. File transfer concepts, technologies, and best practices. . . . . . . . . . . . . . . 11.1 Introduction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 21.1.1 Basic FTP . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 21.1.2 Managed file transfer . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 21.2 Brief history and challenges of file transfer . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 21.3 Overcoming FTP challenges with managed file transfer. . . . . . . . . . . . . . . . . . . . . . . . . 51.3.1 Improved reliability . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 51.3.2 Improved security . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 51.3.3 Improved auditability and visibility. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 61.3.4 Improved flexibility . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 61.3.5 Cost effectiveness. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 61.4 Managed file transfer best practices . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 61.4.1 Intra-enterprise managed file transfer best practices . . . . . . . . . . . . . . . . . . . . . . . 71.4.2 Multi-enterprise managed file transfer best practices . . . . . . . . . . . . . . . . . . . . . . . 81.5 Comparing intra-enterprise and multi-enterprise file transfers . . . . . . . . . . . . . . . . . . . . 91.5.1 Control . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 101.5.2 Authentication and data validation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 101.5.3 Network security . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 111.6 Recent additions to the managed file transfer portfolio . . . . . . . . . . . . . . . . . . . . . . . . . 111.7 Who should read this book . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 12Chapter 2. File transfer products overview . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .2.1 Sterling Connect:Direct . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .2.1.1 Sterling Connect:Direct additional features. . . . . . . . . . . . . . . . . . . . . . . . . . . . . .2.1.2 Scalability . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .2.1.3 Capabilities . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .2.1.4 Architectural overview . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .2.1.5 Connect:Direct process language . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .2.2 IBM Sterling B2B Integrator . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .2.2.1 Capabilities . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .2.2.2 Terminology . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .2.3 IBM Sterling File Gateway. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .2.3.1 How Sterling B2B Integrator and Sterling File Gateway work together. . . . . . . . .2.3.2 Capabilities . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .2.3.3 Terminology . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .2.4 IBM Sterling Secure Proxy . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .2.5 WebSphere MQ File Transfer Edition . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .2.5.1 Architecture of WebSphere MQ File Transfer Edition . . . . . . . . . . . . . . . . . . . . . .2.5.2 Using Apache Ant . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .2.5.3 Using file transfer pre-processing and post-processing tasks. . . . . . . . . . . . . . . . Copyright IBM Corp. 2011. All rights reserved.13141416171820242526272728293133343839iii
2.5.4 Using WebSphere MQ Advanced Message Security . . . . . . . . . . . . . . . . . . . . . .2.6 WebSphere Message Broker . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .2.6.1 Message flows with WebSphere Message Broker . . . . . . . . . . . . . . . . . . . . . . . .2.6.2 Runtime architecture of WebSphere Message Broker . . . . . . . . . . . . . . . . . . . . .2.6.3 Developing message flows with the WebSphere Message Broker Toolkit . . . . . .2.6.4 Deploying message flow applications . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .2.6.5 Administration with WebSphere Message Broker Explorer . . . . . . . . . . . . . . . . .39393940404141Chapter 3. Scenario topology overview . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 433.1 An introduction to the scenarios used in this book . . . . . . . . . . . . . . . . . . . . . . . . . . . . 443.1.1 Interal use of Sterling Connect:Direct and WebSphere MQ File Transfer Edition 443.1.2 Using Sterling Connect:Direct for multi-enterprise transfers . . . . . . . . . . . . . . . . . 443.1.3 Multi-Enterprise file transfer using Sterling Connect:Direct, Sterling File Gateway,and WebSphere MQ File Transfer Edition . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 453.1.4 Integrating multi-enterprise transfers with an enterprise service bus . . . . . . . . . . 453.2 Scenario architecture . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 463.2.1 The external partner: Company A . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 473.2.2 The protected network: Company B . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 473.2.3 DMZ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 49ivChapter 4. Managed file transfer within an enterprise. . . . . . . . . . . . . . . . . . . . . . . . . .4.1 Solution overview . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .4.1.1 Using Sterling Connect:Direct and WebSphere MQ File Transfer Edition . . . . . .4.1.2 Business value . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .4.2 Scenario details. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .4.2.1 Solution components . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .4.2.2 The Sterling Connect:Direct to Sterling Connect:Direct scenario . . . . . . . . . . . . .4.2.3 Sterling Connect:Direct push to WebSphere MQ File Transfer Edition . . . . . . . .4.2.4 Sterling Connect:Direct pulling from WebSphere MQ File Transfer Edition . . . . .4.2.5 WebSphere MQ File Transfer Edition pushing to Sterling Connect:Direct . . . . . .4.2.6 WebSphere MQ File Transfer Edition pulling from Sterling Connect:Direct . . . . .4.2.7 Protocols . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .4.2.8 Security . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .4.3 Configuring the solution components . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .4.3.1 Software prerequisites . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .4.3.2 Configuration prerequisites . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .4.3.3 Configuring Sterling Connect:Direct on SysD . . . . . . . . . . . . . . . . . . . . . . . . . . . .4.3.4 Configuring Sterling Connect:Direct on SysE . . . . . . . . . . . . . . . . . . . . . . . . . . . .4.3.5 Configuring WebSphere MQ File Transfer Edition . . . . . . . . . . . . . . . . . . . . . . . .4.4 Testing the flows . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .4.4.1 Sterling Connect:Direct push to Sterling Connect:Direct . . . . . . . . . . . . . . . . . . .4.4.2 Sterling Connect:Direct push file to WebSphere MQ File Transfer Edition. . . . . .4.4.3 Sterling Connect:Direct pull file from WebSphere MQ File Transfer Edition. . . . .4.4.4 WebSphere MQ File Transfer Edition push to Sterling Connect:Direct . . . . . . . .4.4.5 WebSphere MQ File Transfer Edition pull to Sterling Connect:Direct. . . . . . . . . .4.5 Troubleshooting tips . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 790Chapter 5. External transfers using IBM Sterling Connect:Direct andIBM Sterling File Gateway . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .5.1 Solution overview . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .5.1.1 Appropriate use of the scenario . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .5.1.2 Business value . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .5.1.3 Sterling File Gateway features . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .5.2 Scenario details. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .919292929394IBM Sterling Managed File Transfer Integration with WebSphere Connectivity for a Multi-Enterprise Solution
5.2.1 Solution components . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 955.2.2 Sterling Connect:Direct to Sterling Connect:Direct using Sterling Secure Proxy . 985.2.3 External Sterling Connect:Direct push to Sterling File Gateway using Sterling SecureProxy. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 995.2.4 Internal Sterling Connect:Direct push to Sterling File Gateway using Sterling SecureProxy. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1005.2.5 Protocols . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1015.2.6 Security . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1015.2.7 Software prerequisites . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1035.2.8 Configuring the solution components . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1035.2.9 Configuration prerequisites . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1035.2.10 Configuring Sterling Connect:Direct on SysA . . . . . . . . . . . . . . . . . . . . . . . . . . 1045.2.11 Configuring the Connect:Direct for Linux node SysE CD. . . . . . . . . . . . . . . . . 1155.2.12 Installing and configuring the Connect:Direct server adapter . . . . . . . . . . . . . . 1165.2.13 Configuring the proxy . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1285.2.14 Configuring Sterling File Gateway. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1295.3 Testing the flows . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1445.3.1 Sterling Connect:Direct push file to Sterling Connect:Direct. . . . . . . . . . . . . . . . 1455.3.2 External Sterling Connect:Direct push to Sterling File Gateway to internal SterlingConnect:Direct . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1515.3.3 Internal Sterling Connect:Direct push to Sterling File Gateway, to external SterlingConnect:Direct using Sterling Secure Proxy. . . . . . . . . . . . . . . . . . . . . . . . . . . . 1575.3.4 Creating the route in Sterling File Gateway . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1575.4 Troubleshooting . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 166Chapter 6. External Transfers with Protocol Switching between IBM SterlingConnect:Direct and WebSphere MQ File Transfer Edition via Sterling FileGateway . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1676.1 Solution overview . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1686.1.1 Appropriate use. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1686.1.2 Business value . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1696.2 Scenario details. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1716.2.1 Solution components . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1726.2.2 Inbound: Sterling Connect:Direct to WebSphere MQ File Transfer Edition . . . . 1766.2.3 Outbound: WebSphere MQ File Transfer Edition to Sterling Connect:Direct . . . 1776.2.4 Protocols . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1786.2.5 Security . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1786.3 Configuring the solution components . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1816.3.1 Software prerequisites . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1826.3.2 Configuration prerequisites . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1826.3.3 Sterling B2B Integrator and Sterling File Gateway customization. . . . . . . . . . . . 1826.3.4 Configuring Sterling Connect:Direct on SysA . . . . . . . . . . . . . . . . . . . . . . . . . . . 1846.3.5 Installing the Connect:Direct server adapter on Sterling B2B Integrator. . . . . . . 1936.3.6 Configuring the proxy . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1936.3.7 Configuring Sterling B2B Integrator to use the WebSphere MQ Adapter . . . . . . 1936.3.8 Configuring FTP Server adapter in Sterling B2B Integrator . . . . . . . . . . . . . . . . 1946.3.9 Configuring WebSphere MQ File Transfer Edition bridge agent. . . . . . . . . . . . . 1966.3.10 Creating custom WebSphere MQ File Transfer Edition protocol . . . . . . . . . . . 1996.3.11 Creating a WebSphere MQ reply queue . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2076.3.12 Configuring Sterling File Gateway. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2086.4 Testing the flows . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2296.4.1 Inbound scenario . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2296.4.2 Outbound scenario . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 238Contentsv
6.5 Troubleshooting tips . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 243Chapter 7. External transfers using IBM WebSphere Message Broker and IBM SterlingFile Gateway . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2457.1 Solution overview . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2467.1.1 Appropriate use. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2467.1.2 Business value . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2467.2 Scenario details. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2487.2.1 Solution components . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2497.2.2 Inbound file transfer flow . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2537.2.3 Outbound file transfer flow . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2547.2.4 Protocols . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2577.2.5 Security . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2577.3 Configuring the solution components . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2607.3.1 Software prerequisites . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2617.3.2 Configuration prerequisites . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2617.3.3 Creating the protocol bridge agent . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2617.3.4 Configuring a broker and execution group . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2667.3.5 WebSphere MQ File Transfer Edition with WebSphere Message Broker. . . . . . 2717.3.6 Creating message flows with WebSphere MQ File Transfer Edition nodes . . . . 2747.3.7 Creating a community in Sterling File Gateway . . . . . . . . . . . . . . . . . . . . . . . . . 2847.3.8 Creating routing channel templates in Sterling File Gateway . . . . . . . . . . . . . . . 2887.3.9 Enabling WebSphere MQ File Transfer Edition in Sterling File Gateway . . . . . . 2887.3.10 Modifying FirstCommunity in Sterling File Gateway . . . . . . . . . . . . . . . . . . . . . 2887.3.11 Creating a listener queue for Sterling B2B Integrator . . . . . . . . . . . . . . . . . . . . 2887.3.12 Setting up a trading partner for WebSphere Message Broker . . . . . . . . . . . . . 2897.3.13 Creating a trading partner for myFileGateway . . . . . . . . . . . . . . . . . . . . . . . . . 2967.3.14 Configuring Sterling B2B Integrator for SFTP communication . . . . . . . . . . . . . 2997.3.15 Creating the trading partner for SFTP. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3107.3.16 Creating an inbound routing channel . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3147.3.17 Creating an outbound routing channel . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3177.3.18 Importing key certificate files in Sterling B2B Integrator for HTTPS . . . . . . . . . 3197.3.19 Configuring Sterling B2B Integrator and myFileGateway for HTTPS . . . . . . . . 3247.4 Testing the flows . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3337.4.1 Testing the flow sending an output file over SFTP . . . . . . . . . . . . . . . . . . . . . . . 3347.4.2 Testing the scenario downloading a file using myFileGateway. . . . . . . . . . . . . . 3417.5 Troubleshooting tips . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 345Appendix A. Configuration of WebSphere MQ File Transfer Edition . . . . . . . . . . . . . 347Overview . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 348Configuring WebSphere MQ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 349Creating the queue managers . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 349Creating the queue manager objects . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 351Configuring WebSphere MQ File Transfer Edition . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 356Defining the coordination, command, and agent queue manager and WebSphere MQ FIleTransfer agents . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 356Starting the agent . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 362Appendix B. Building the WebSphere Message Broker flow . . . . . . . . . . . . . . . . . . .Overview of the flow modifications . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Modifying the sample . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Creating the ESQL module . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Other configuration tasks . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Example files to test the flow . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .viIBM Sterling Managed File Transfer Integration with WebSphere Connectivity for a Multi-Enterprise Solution365366367374376376
Appendix C. Troubleshooting . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Sterling File Gateway and Sterling B2B Integrator. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .WebSphere MQ File Transfer Edition . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Sterling Connect:Direct . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Check ports . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .WebSphere Message Broker tips . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Transfers do not appear in WebSphere MQ File Transfer Edition Explorer . . . . . . . . .379380384388395396396Appendix D. Sample files . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Sample Ant scripts . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Push to CD.xml script. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Pull from CD.xml script. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .InvokeCD.xml script . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Sample files used in WebSphere MQ File Transfer Edition within Sterling File Gateway .SFGFTECreateTransfer.xslt file . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .CustomFileGatewayDeliveryFTE.bmpl file. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Customer overrides.properties file . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .AFTExtensionsCustomer.properties source file . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .AFTExtensionsCustomer.xml source file . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .401402402404406406406408419421422Appendix E. Additional material . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Locating the web material . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Using the web material. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Downloading and extracting the web material . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .425425425426Related publications . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 427IBM Redbooks . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 427Online resources . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 427Contentsvii
viiiIBM Sterling Managed File Transfer Integration with WebSphere Connectivity for a Multi-Enterprise Solution
NoticesThis information was developed for products and services offered in the U.S.A.IBM may not offer the products, services, or features discussed in this document in other countries. Consultyour local IBM representative for information on the products and services currently available in your area. Anyreference to an IBM product, program, or service is not intended to state or imply that only that IBM product,program, or service may be used. Any functionally equivalent product, program, or service that does notinfringe any IBM intellectual property right may be used instead. However, it is the user's responsibility toevaluate and verify the operation of any non-IBM product, program, or service.IBM may have patents or pending patent applications covering subject matter described in this document. Thefurnishing of this document does not give you any license to these patents. You can send license inquiries, inwriting, to:IBM Director of Licensing, IBM Corporation, North Castle Drive, Armonk, NY 10504-1785 U.S.A.The following paragraph does not apply to the United Kingdom or any other country where suchprovisions are inconsistent with local law: INTERNATIONAL BUSINESS MACHINES CORPORATIONPROVIDES THIS PUBLICATION "AS IS" WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESS ORIMPLIED, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF NON-INFRINGEMENT,MERCHANTABILITY OR FITNESS FOR A PARTICULAR PURPOSE. Some states do not allow disclaimer ofexpress or implied warranties in certain transactions, therefore, this statement may not apply to you.This information could include technical inaccuracies or typographical errors. Changes are periodically madeto the information herein; these changes will be incorporated in new editions of the publication. IBM may makeimprovements and/or changes in the product(s) and/or the program(s) described in this publication at any timewithout notice.Any references in this information to non-IBM websites are provided for convenience only and do not in anymanner serve as an endorsement of those websites. The materials at those websites are not part of thematerials for this IBM product and use of those websites is at your own risk.IBM may use or distribute any of the information you supply in any way it believes appropriate without incurringany obligation to you.Information concerning non-IBM products was obtained from the suppliers of those products, their publishedannouncements or other publicly available sources. IBM has not tested those products and cannot confirm theaccuracy of performance, compatibility or any other claims related to non-IBM products. Questions on thecapabilities of non-IBM products should be addressed to the suppliers of those products.This information contains examples of data and reports used in daily business operations. To illustrate themas completely as possible, the examples include the names
IBM Sterling Managed File Transfer Integration with WebSphere Connectivity for a Multi-Enterprise Solution Jennifer Foley Kentaroh Kido Stephen Litzkow Kieran Scott Derek Tucker Using Sterling File Gateway and Sterling B2B Integrator for robust managed file transfer Extending file transfer capabilities with WebSphere Message Broker
- IBM Sterling B2B Integrator Version 5.2.3 - IBM Sterling File Gateway Version 2.2.3 - IBM Sterling Connect:Direct Version 4.6 - IBM WebSphere Message Queue Version 7.0.1 - IBM WebSphere Message Broker Version 8.0 - IBM WebSphere Transformation Extender Design Studio Version 8.4 - IBM WebS
The IBM Sterling Control Center System Administration Guide is for programmers, network operations staff, and system administrators—basi cally, everyone who maintains the IBM Sterling Control Center system and the managed servers it monitors. After you have planned your implementation, read the IBM Sterling Control Center Getting Started .
value with IBM Sterling B2B collaboration by improving business results and increasing their capacity and ability to exchange B2B documents. IDC calculates that interviewed IBM customers will realize value worth an annual average of 14.72 million per organization ( 108,700 per 100 employees whose work relies on IBM Sterling B2B collaboration and
Modi ed IBM IBM Informix Client SDK 4.10 03/2019 Modi ed IBM KVM for IBM z Systems 1.1 03/2019 Modi ed IBM IBM Tivoli Application Dependency Discovery Manager 7.3 03/2019 New added IBM IBM Workspace Analyzer for Banking 6.0 03/2019 New added IBM IBM StoredIQ Suite 7.6 03/2019 New added IBM IBM Rational Performance Test Server 9.5 03/2019 New .
IBM 360 IBM 370IBM 3033 IBM ES9000 Fujitsu VP2000 IBM 3090S NTT Fujitsu M-780 IBM 3090 CDC Cyber 205 IBM 4381 IBM 3081 Fujitsu M380 IBM RY5 IBM GP IBM RY6 Apache Pulsar Merced IBM RY7
Sterling B2B Integrator may be able to implement file transfers with IBM W ebSpher e MQ File T ransfer Edition. The instr uctions in this documentation ar e based on the following pr er equisites: v Y ou have a working knowledge of Sterling B2B Integrator . v Y ou have implemented Sterling B2B Integrator .
Aberdeen Group calls today's file transfer solutions the "modern plumbing" of the Internet6. When asked by Forrester Research about planned improvements for Global EDI/B2B, 81% of managers said that enhancing their Managed File Transfer The Solution: Managed File Transfer Figure 2: An Ideal MFT Solution Covers All Kinds of Transfers and Data
as advanced engineering mathematics and applied numerical methods. The greatest beneÞt to the reader will probably be derived through study of the programs relat-' 2003 by CRC Press LLC. ing mainly to physics and engineering applications. Furthermore, we believe that several of the MATLAB functions are useful as general utilities. Typical examples include routines for spline interpolation .
