Data Transformation Engine Resource Adapter Reference Guide

Resource Adapters Reference Guide
3
Contents
About This Document
Related References........................................................................................... 6
Chapter 1 - Resource Adapters
Overview ....................................................................................................... 8
Importers.................................................................................................. 9
System Requirements........................................................................................ 9
General Rules for Adapter Commands ...................................................................10
Command Syntax Summaries ..............................................................................10
Adapter Command Aliases .................................................................................11
Multiple Adapter Versions..................................................................................12
Editing the adapters.xml File.........................................................................12
Configuring Java-Based Adapters.........................................................................14
UNIX Only ................................................................................................14
API Usage.................................................................................................14
Encoding and Decoding Data...............................................................................15
Limitations...............................................................................................15
Encoding.................................................................................................. 16
Decoding .................................................................................................16
Transporting.............................................................................................17
Encode/Decode Scenarios..................................................................................18
Input Card or GET ...................................................................................... 18
Output Card or PUT ....................................................................................18
GET Function ............................................................................................18
Transport Encode/Decode Examples.....................................................................19
SOAP Input card.........................................................................................19
SOAP Output card.......................................................................................19
SOAP Request/Reply in a GET function.............................................................19
Chapter 2 - Resource Adapters Use
Using the Resource Adapters ..............................................................................20
Using an Adapter in the Map Designer ...................................................................20
Specifying the FTP Adapter in the Map Designer..................................................21
Using an Adapter in a Map or Component Rule.........................................................22
Using an Adapter in the Integration Flow Designer....................................................23
Specifying the TIB/RV Adapter in the Integration Flow Designer.............................. 24
On the Command Line ......................................................................................26
Database-specific Adapter Commands on the Command Line..................................26
For Windows Sources and Targets on the Command Line .......................................28
For UNIX Sources and Targets on the Command Line ............................................ 28
Functions......................................................................................................29
Using the GET Function................................................................................29
Using the PUT Function................................................................................29
Using the RUN Function................................................................................30
Using Wildcards ..............................................................................................30
Scope Settings and FetchUnit Interpretation...........................................................31
Using Global Transaction Management ..................................................................32
File Adapter ..................................................................................................33