iWay Release 7.0.x Technical Library
Navigation and Search Tips
Contact Us
Navigation and Search Tips
Contact Us
Introduction to iWay 7
Overview: iWay 7 Integration and Integrity Solutions
iWay 7 Integration and Integrity Solutions
Introducing iWay 7
The iWay 7 Solution
iWay 7 Product Overview
iWay Integration Suite
Introduction
iWay Service Manager
iWay Integration Tools
iWay DataMigrator
iWay Software Development Kit
Incremental Integration (Change Data Capture)
Data Connectors
Security
iWay Data Quality Suite
Introduction
iWay Data Quality Server
iWay Data Profiler
Remediation Portal
iWay Master Data Suite
Introduction
iWay Master Data Server
360 Viewer
Remediation Portal
iWay Integrity Management Central
Introduction
360 Viewer
Remediation Portal
Data Dictionary
iWay Sentinel
Overview
Centralized Monitoring
Remote Management
Automation Through Scripting
Key Features and Advantages
For More Information
Omni-Gen™ Master Data Management Edition
Overview
Key Features and Advantages
Launch PDF
Overview: iWay 7 Integration and Integrity Solutions
iWay 7 Integration and Integrity Solutions
Introducing iWay 7
The iWay 7 Solution
iWay 7 Product Overview
iWay Integration Suite
Introduction
iWay Service Manager
iWay Integration Tools
iWay DataMigrator
iWay Software Development Kit
Incremental Integration (Change Data Capture)
Data Connectors
Security
iWay Data Quality Suite
Introduction
iWay Data Quality Server
iWay Data Profiler
Remediation Portal
iWay Master Data Suite
Introduction
iWay Master Data Server
360 Viewer
Remediation Portal
iWay Integrity Management Central
Introduction
360 Viewer
Remediation Portal
Data Dictionary
iWay Sentinel
Overview
Centralized Monitoring
Remote Management
Automation Through Scripting
Key Features and Advantages
For More Information
Omni-Gen™ Master Data Management Edition
Overview
Key Features and Advantages
Launch PDF
Release Notes
Installation Notes
iWay Integration Suite
Launch PDF
Installation Notes
iWay Integration Suite
Launch PDF
iWay Sentinel
Documentation
iWay Sentinel User's Guide
Introducing iWay Sentinel
Overview
Key Terms
Quick Start Guide
Installing iWay Sentinel Components
Prerequisites
Installing the Envoy
Installing Sentinel
Managing and Monitoring Servers
Introduction
Server Connectivity
Analyzing Server Health
Managing Servers
Viewing and Modifying Server Properties
Managing and Monitoring Applications
Introduction
Monitoring Applications
Managing Applications
Viewing and Modifying Application Properties
Managing and Monitoring Channels
Introduction
Viewing and Modifying Channel Properties
Administration
Configuring Groups
Configuring Tasks
Configuring Users
Managing Files and Artifacts
Viewing Activity Feeds
Sentinel Configuration Properties
Configuring the Health Model Properties
Preserved Properties
General Notes Related to the User Interface
Filtering and Searching
Sorting and Ordering Columns
Groups
iWay Sentinel Scripting
Introduction
iWay Sentinel Classes
Task Script Examples
Other Script Examples
Launch PDF
Documentation
iWay Sentinel User's Guide
Introducing iWay Sentinel
Overview
Key Terms
Quick Start Guide
Installing iWay Sentinel Components
Prerequisites
Installing the Envoy
Installing Sentinel
Managing and Monitoring Servers
Introduction
Server Connectivity
Analyzing Server Health
Managing Servers
Viewing and Modifying Server Properties
Managing and Monitoring Applications
Introduction
Monitoring Applications
Managing Applications
Viewing and Modifying Application Properties
Managing and Monitoring Channels
Introduction
Viewing and Modifying Channel Properties
Administration
Configuring Groups
Configuring Tasks
Configuring Users
Managing Files and Artifacts
Viewing Activity Feeds
Sentinel Configuration Properties
Configuring the Health Model Properties
Preserved Properties
General Notes Related to the User Interface
Filtering and Searching
Sorting and Ordering Columns
Groups
iWay Sentinel Scripting
Introduction
iWay Sentinel Classes
Task Script Examples
Other Script Examples
Launch PDF
iWay Integration Suite
Service Manager
Getting Started
nHTTP Representational State Transfer Getting Started
Introducing nHTTP Representational State Transfer
Representational State Transfer (REST)
nHTTP REST Support
Configuration Overview
Configuring a Process Flow and nHTTP Channel
Configuring a Process Flow
Configuring an nHTTP Channel
Running a REST Style Service
Launch PDF
Non-blocking AS2 (NAS2) Getting Started Guide
Introducing Non-blocking AS2 (NAS2)
NAS2 Overview
Providers Overview
Namespaces Overview
Configuring Providers
Prerequisites
Importing Packages
Configuring NAS2 Channels
Importing Archives
Sender (iWay) Channel Overview
Receiver (Partner) Channel Overview
Testing and Viewing Results
Reviewing Registered Namespaces Within the Output Files
Launch PDF
Documentation
Installation and Configuration
iWay 7.0.7 Service Manager Installation Overview
iWay 7.0.7 Service Manager Products and Components
Installation and Configuration Overview
Installing iWay 7.0.7 Service Manager Components
Installation Requirements
Installing iWay 7.0.7 Service Manager
Installing iWay 7.0.7 Service Manager With iWay 5.x or 6.x Service Manager
Post-Installation Topics and Tasks
Registering iWay Software
Configuration Steps
Preparing Adapters
Preparing Adapters
Configuring iWay Components
Configuring and Verifying iWay Service Manager
Configuring iWay Application Server Components
Configuring iWay Explorer
Configuring iWay Explorer
Configuring Eclipse iWay Explorer
Configuring the iWay Repository
Configuring and Creating the Repository
Migrating Repositories
Launch PDF
User's Guide
Introducing iWay Service Manager
iWay Service Manager Functions
Understanding iWay Channels
Document Life Cycle
Understanding iWay Service Manager Thread Management
Introducing the iWay Service Manager Administration Console
Console Home Window
iWay Service Manager Help Window
iWay Service Manager Welcome Window
Internationalization
Encoding
Displaying License Information
Installation Verification Procedure
Accessing the iWay Service Manager Administration Console
Building and Deploying the File1 Channel
Testing iWay Service Manager
Configuring Basic Properties
Configuring Properties
Configuring Properties as Constant Values
Obtaining Configuration Properties From the File System
Obtaining Configuration Properties Using LDAP
Obtaining Configuration Properties Using XPath
Obtaining Configuration Properties Using Special Registers
Using Registers, Register Sets, and Parameters
Managing Configurations
Introducing iWay Service Manager Configurations
Creating a Configuration
Working With Configurations
Stopping a Service
Removing a Service and Configuration
Adding a User
Managing Configurations in Batch
Configuring General Properties Using the Console
Settings
Providers
Facilities
Configuring iWay Registry Components
Understanding the iWay Registry
Adding an Adapter
Decryptor
Adding an Ebix
Adding an Emitter
Encryptors
Adding a Listener
Adding a Preemitter
Adding a Preparser
Adding a Reviewer
Adding a Rule
Adding a Schema
Adding a Service
Viewing a Defined Transform
Defining a Process
Defining a Transformer
Using the Recycle Bin
Configuring Channels
Defining an Inlet
Defining a Route
Defining an Outlet
Constructing a Channel
Specifying Fixed or Dynamic Routing
Adding Register Sets
Adding Ebix Components
Building a Channel
Using iWay Service Manager Tools
Using the Log Viewer
Using the Package Manager
Using the Archive Manager
Using the Deployment Manager
Using the Enterprise Index Application
Operations and Monitoring
Understanding iWay Service Manager Restart Methods
Using iWay Service Manager Startup Command Line Switches
Starting and Stopping iWay Service Manager on Windows
Starting and Stopping Service Manager on UNIX, OS/400, and z/OS
Class Path and Service Manager Restart Issues
Understanding and Using the IWSRV Executable Program
Event Process Flows
Startup Process Flow
Closedown Process Flow
SNMP Provider
iWay Service Manager Failover
Channel Management
Service Management
Testing Web Services
Using the iWay Service Manager System Tray Application on Windows
Using the Telnet Management Connection
Overview
Configuring the Telnet Listener
Using the Telnet Management Connection
Diagnostics, Tracing, and Logging
Running in a Command Shell
Diagnostic Commands
Troubleshooting on Windows
Performing Diagnostic Functions
Measurements and Statistics
Using JConsole to Monitor iWay Service Manager
Testing Functions
Testing XPATH
Using Debug Nodes
Using the Log Viewer
Creating a Diagnostic Zip
Special Registers (SREGs)
Global SREGs
Transform SREGs
Process Flow SREGs
Running iWay Service Manager Under YARN Using Slider
Overview
Creating an iWay Service Manager Slider Package
Installing, Deploying, and Running iWay Service Manager With Slider
Sample Application Deployment
Launch PDF
Command Reference Guide
Introduction
iWay Service Manager Command Environment
Using Command Help
Managing Command Security
Creating and Using a Remote Command Console
Overview
Creating a Remote Command Console
Connecting to a Remote Command Console
Using the Scheduler
Using the iWay Service Manager Command Line Console
Command Line Schedule Examples
iWay Service Manager Commands Reference
Available iSM Commands
Calendar
Cron
Copy
Diagzip
Enqueue
Errors
Flow
GC
Help
Hidelog and Showlog
Info
Jdbc
Line
Package
Pull
Quit
Refresh
Remote
Run
Say
Schedule
Script
Set
Shell
Show
Sleep
Spool
Start
Stats
Stop
Time
Tool
Type
User Commands
Launch PDF
Component Reference Guide
iWay Services
Overview
Available Services
Parallel Control Services
iWay Preparsers
Overview
Available Preparsers
Streaming Preparsers
Splitter Preparsers
iWay Preemitters
Overview
Available Preemitters
PGPEncrypt Preemitter (com.ibi.preemit.PGPEncrypt)
Deflate (com.ibi.preemit.XDDeflate)
EDIX12 Preemitter (com.ibi.preemit.XDX12PreEmitter)
HIPAA Preemitter (com.ibi.preemit.XDHIPAAPreEmitter)
SWIFT Preemitter (com.ibi.preemit.SwiftPreEmitter)
XDSWIFT Preemitter (com.ibi.preemit.XDSwiftpreEmitter)
XDEDIFACT Preemitter (com.ibi.preemit.XDEDIFACTPreEmitter)
Entity Repl Preemitter (com.ibi.preemit.XDEntityRepl)
Constant PE (com.ibi.preemit.XDConstantPE)
Flat Delim Preemitter (com.ibi.preemit.XDFlatDelimPreEmitter)
Remove Outer Tag (com.ibi.preemit.XDDeTag)
Replaced Paired Characters (com.ibi.preemit.XDCharRepl)
Legacy Record Preemitter (com.ibi.preemit.LegacyRecordPreemitter)
Multi Part (com.ibi.preemit.XDMultiPart)
QA Print (com.ibi.preemit.XDQAPrint)
XSL Tpre (com.ibi.preemit.XDXSLTpreEmitter)
iWay Transformations Preemitter (com.ibi.preemit.XDXMLGpreEmitter)
iWay Iterators
Understanding Iterators
Iterator Parameters
Available Iterators
Iterator Example
Additional SQL Service Reference Information
SQL Service Edge Returns Sorted by XOPEN Code
Transaction Isolation Terminology
Apache Avro Components
Installation
Avro File Read Service
Avro File Emit Service
Avro File Iterator Service
Avro File Listener
Avro RPC HTTP Emit Service
Avro RPC Over HTTP Listener
Launch PDF
Functional Language Reference Guide
iWay Functions
Overview
Environmental Functions
Document Functions
String Functions
Time Service Functions
Math Functions
Decimal Math Functions
Encoding Functions
File Functions
System Information Functions
Security Functions
Other Functions
Arithmetic Expressions
Function Syntax and Return Values
IWXPATH Language Support
Launch PDF
Programmer's Guide
Programming Your Applications in iWay Service Manager
Overall Guidelines
Overview of the Adapter Process
Document Life Cycle
Developing For Your Own Needs
Protocol Components
Encoding
Routing
Terminology
Process Flows
Writing Business Components
Getting Started With Business Components
Programming Exit Components for iWay Service Manager
Common Methods
Configuration Parameters
Other Metadata Methods
The Executable Portion of an Exit
Status Documents
Business Agents Running in Transactions
Preparsers
Reviewers
Preemitters
Building the Exit
Writing Iterators
Writing Management Components
Getting Started With Management Components
Activity Log Writer
Activity Driver
XDSQLWriter Activity Driver
Trading Partner Agreement
Correlation Manager
Writing iWay Function Language (IFL)
Service Providers
Writing Protocol Components
Protocol Components
Programming Standards, General Rules of the Road
Build Environment
MasterInfo Class
Installing Components
Writing an iWay Service Manager Emitter
Writing an iWay Service Manager Listener
Writing an Extension Command
Running a Process Flow
Programming Objects
XDDocument
XDNode
XDNode and XDDom
XDOrgData
XDSpecReg
XDExitBase
iWay API Reference
Tracing
Special Registers
Pooling
Getting Server Information
QA Mode
Evaluating Expressions
Exit Attributes
Storing Objects
Service Functions
Creating Files With Unique Names
Safe Store Facility
Converting Between JDOM and XD Trees
Multithread Considerations
iWay Service Manager Rules System
Rules File
General Rule Set
Writing Rules in Java
Writing Rule Search Routines in Java
Building iWay Service Manager Components
Overview
Understanding the Registration Class
Sample ANT Build Script
Standard Business Exits
Business Exits Terminology
Business Agents
Protocol Business Agents
Preparsers
Splitter Preparsers
Preemitters
Reviewers
Supplied Tools
CreateMultipart
FromWhere
Signing Configuration Files
Testing Functions
Testing xpath
Debugging Tools
Tracing
Running in a Command Shell
Quality Assurance Mode
Gathering Support Information
Measuring Performance
Overview
Built-in Statistics
Memory Command
Threads Command
Deadlock Detector
Statistics
Using iFL to Measure Multiple Node Duration
Activity Log Timer
iWay Functional Language
The Rules
Creating Application Consoles for iWay Service Manager
Application Console Overview
Basic Techniques
Sample Application Console (Red Console)
Glossary
Launch PDF
Security Guide
Introducing Security
Confidentiality
Integrity
Authentication
Security in iWay Service Manager
Introducing Security Components
Areas of Responsibility
Message Acquisition and Disposition
Rejection of Spurious Messages
Secure Multi-Purpose Internet Mail Extension (S/MIME)
XML Digital Signature
Authentication and Authorization
Using Policies
Password Masking
Security Related iFL Functions
Restricted XPath Expressions
Security Providers
Keystore Provider
Directory CertStore Provider
SSL Context Provider
LDAP Certstore Provider
OCSP Responder Provider
Configuring Runtime Security Using Access Control
Overview
Logon Schemes
Configuring Credential Requirements
Realm Based Authentication
Role Based Authentication
Impersonation
Realm-based Security in the iSM Administration Console
Overview
Creating or Editing a Role in the Management Section of the Console
Configuring Authentication for a Base Configuration Using a Properties File Realm
Security Services
OAuth 1.0 Authentication Service
OAuth 2.0 Authentication Service
Insert WSSE Timestamp Service
Insert WSSE Token Service
Insert SAML Assertion Service
XML Digital Signature Create Service
XML Digital Signature Verify Service
XAdES Digital Signature Create Service
XAdES Digital Signature Verify Service
Authenticate/Impersonate Service
Security Tools
Overview
Signing Files
Keeping Values Secret
nCipher Configuration
Provider Initialization (Validating Signatures)
Java Configuration
Softcard for nCipher
Key Creation Using Keytool
Cryptography Provider
Troubleshooting (PKCS11 RSA Private Key Exception)
Authenticating an HTTP Client Using Kerberos
Overview
Kerberos Authentication
Sample Kerberos Configuration File
Sample JAAS Configuration File
Troubleshooting
WSO2 Identity Server Support
Introduction
Installing and Configuring WSO2 Identity Server
Configuring iWay Service Manager
Developer Notes
Launch PDF
Extensions User's Guide
Introducing iWay Service Manager Extensions
About iWay Service Manager Extensions
iWay RVI Proxy Extension
Overview
iWay PGP Extension
Overview
Installing and Configuring the iWay PGP Extension
Configuring a PGP Preemitter for Encryption
Configuring a PGP Preparser for Decryption
Testing Document Encryption and Decryption
Using the PGPEncrypt Service
Signing and Encrypting a Message Using Key Pair Encryption
Configuring ASCII Message Armoring
JCE Reference
iWay Telnet Extension
Overview
Installing and Configuring the iWay Telnet Extension
Configuring the Telnet Listener
Testing a Telnet Listener Channel
Connecting to iWay Service Manager Using a Telnet Client
Supported Commands
Telnet Scripting Example
iWay Security Extension
Overview
Installing the iWay Security Extension
Security Extensions - XDDevKit
iWay Compatibility Extension
Overview
Installing the iWay Compatibility Extension
iWay Scheduler Extension
Installing the iWay Scheduler Extension
Configuring the iWay Service Manager Scheduler
Using iWay Service Manager Command Line Console
Command Line Schedule Examples
iWay Migration Extension
Overview
Installing the iWay Migration Extension
iWay Real Time Data Replication Extension
Overview
Adding Data Integration Object Support for Process Flows
Creating a Connection Using the Data Source Explorer
Configuring a Data Integration Object
Looping
Connection Options
Sample Documents
Tips and Tricks
Launch PDF
Protocol Guide
iWay Protocol Adapters
Protocols Supported in iWay Service Manager
Configuring Channels
Defining an Inlet
Configuring Listeners
Defining a Route
Defining an Outlet
Configuring Emitters
Constructing a Channel
Building a Channel
Registering Library Files and Setting JVM Options
Configuring Local Transaction Management
e-Business Protocol Adapters
AS1 and AS2 Standards
Non-Blocking AS2 Adapter
Application Protocol Adapters
iWay Adapter for EDAAPI
iWay Adapter for RDBMS
iWay Application Adapter for MySAP
Schedule Listener
iWay Application Protocol Adapter for LDAP
iWay Hot Backup Listener
iWay LDAP High Water Mark Listener
iWay Relational Database High Water Mark Listener
iWay Application Adapter for Salesforce
iWay Enterprise Index
iWay Log Event Adapter for Oracle
Transport Utility Protocol Adapters
Email
File
FTP
SFTP
FTP Server
HTTP
nHTTP
SOAP
TCP
UDP
iWay Command Extension
iWay RVI Proxy Extension
Queuing Protocol Adapters
Introducing Queuing Protocol Adapters
JMSQ
MSMQ
Oracle Advanced Queuing
Sonic Message Queuing
TIBCO Rendezvous
RabbitMQ
WebSphere MQ and MQJMS
Internal and Ordered Queue Processing
Configuring Basic Properties
Configuring Properties
Configuring Properties as Constant Values
Obtaining Configuration Properties From the File System
Obtaining Configuration Properties Using LDAP
Obtaining Configuration Properties Using XPath
Obtaining Configuration Properties Using Special Registers
Using Registers, Register Sets, and Parameters
HTTP Headers and Special Registers
History
Issue to be Addressed
Special Registers and HTTP
Launch PDF
Flow Debugger User's Guide
Introducing the Flow Debugger
Introducing the Flow Debugger
Debugger Concepts
Flow Debugger Operations
Performing Basic Operations in Unit Testing Mode
Using Flow Debugger in Configuration Testing Mode
Tips and Usage Considerations
Documents
Sub-flows
Event Flows
Testing a Portion of the Flow
Development Cycle
Messages
Flow Debugger Reference
Debugger Tool
Syntax
Commands
iSM Architecture Considerations for Flow Debugger
iSM Architecture Considerations for Flow Debugger
Launch PDF
FTP Solutions Development Guide
Introducing iWay FTP Services (Adapters)
Overview
Understanding Differences Between FTP and SFTP
iWay Service Manager Suite of FTP Tools
Available Listeners Reference
Available Emitters Reference
Available Services Reference
Configuring FTP and FTPS Components
Overview
Configuring a FTP Listener
Configuring a FTP Emitter
Configuring a FTP Read Document Service
Configuring a FTP File Emit Service
Configuring a FTP File Operations for Process Flows Service
Configuring a FTP Direct Transfer to Disk Service
Configuring a FTP Connection Cache Service
Configuring a FTP Directory Contents Service
Configuring a FTP File Read for Process Flows Service
Configuring Secure FTP (SFTP) Components
Overview
Configuring a SFTP Listener
Configuring a SFTP Emitter
Configuring a SFTP Read Service
Configuring a SFTP Directory Contents Service
Configuring a SFTP Direct Transfer Service
Configuring a SFTP Connection Cache Service
Configuring a SFTP Emit Service
Configuring a SFTP File Ops Service
Configuring OpenSSH on Windows
Converting a Private Key to the OpenSSH Key Format
Configuring FTP Server Components
Overview
Configuring a FTP Server Listener
FTP Commands
Security Considerations
Using the Trading Partner Management Facility
Configuring a FTP SREG Service
Configuring Secure FTP (SFTP) Server Components
Overview
Configuring a SFTP Listener
Configuring the SSH Server Security Provider
Common Configuration Parameters
Listener Configuration Parameters
Configuring iWay Service Manager Components
Configuring Listeners
Configuring Services
Launch PDF
HTTP Solutions Guide
Introducing iWay HTTP Solutions
Overview
What is HTTP?
iWay Service Manager Suite of HTTP Tools
Table of HTTP Listeners
Table of HTTP Emitters
Table of HTTP Services
Table of HTTP Preparsers
Configuring HTTP Components
HTTP
nHTTP
Sonic Message Queuing
Configuring iWay HTTP Services (Adapters)
Overview
HTTP Services
Configuring HTTP Preparsers
Overview
HTTP Preparser (com.ibi.preparsers.XDHTTPpreParser)
Multipart for nHTTP Preparser (com.ibi.preparsers.XDMultiPartForNHTTP)
Configuring HTTP Headers and Special Registers
History
Issue to be Addressed
Special Registers and HTTP
Configuring Common Parameters
Listener Configuration Parameters
Configuring iWay Service Manager Components
Configuring Listeners
Configuring Services
Launch PDF
Cross-Channel Services Guide
Introducing iWay Service Manager Cross-Channel Services
Overview
Available Listeners Reference
Available Services Reference
Internal Queue Processing
Overview
Configuring an Internal Queue Listener
Configuring an Internal Emit Service
Ordered Queue Processing
Overview
Introducing the Ordered Queue Facility
Configuring an Ordered Queue Listener
Configuring an Ordered Emit Service
Reverse Invocation Queue Processing
Overview
Configuring the RVIAttach Listener
Configuring the RVI Relay Service
Configuring the RVIGateway Listener
Configuring a Service to Test the Reverse Invocation
Asynchronous Forward Transfer Invocation Queue Processing
Overview
Configuring a Marshall Service
Configuring an Unmarshall Service
Configuring iWay Service Manager Components
Configuring Listeners
Configuring Services
Common Configuration Parameters
Listener Configuration Parameters
Service Configuration Parameters
Deploying iWay in a High Availability Environment
Overview
Failover
Scaling and Load Balancing
Implementing High Availability
IP-based Horizontal Scaling
Web-based Horizontal Scaling Using iWay Performance Monitor
iWay Reverse Invocation Proxy and High Availability
Launch PDF
Business Activity Monitor User's Guide
Introducing iWay Business Activity Monitor
iWay Business Activity Monitor (BAM) Architecture
Installing iWay Business Activity Monitor
Installation Prerequisites
Installing iWay Business Activity Monitor
Configuring iWay Business Activity Monitor
Configuring the iWay Business Activity Monitor Web Application
Configuring and Using iWay Business Activity Monitor
Accessing the iWay Business Activity Monitor Console
Activity Management Tab
Administration Tab
Correlation Management Tab
BAM Driver Recovery
Using BAM Commands
Structure of the iWay Business Activity Monitor Database
BAM_ACTIVITY Table
BAM_ACTIVITY_CONTEXT Table
BAM_ACTIVITY_EXTENDED Table
Configuring User Authentication for iWay Business Activity Monitor
Overview
Creating an LDAP Directory Provider
Creating an LDAP Authentication Realm
Mapping LDAP Roles to iWay BAM Roles
Enabling iWay BAM Authentication Through an Authentication Realm
Launch PDF
Trading Partner Manager User's Guide
Introducing iWay Trading Partner Manager
About iWay Trading Partner Manager
iWay Trading Partner Manager Architecture
Installing iWay Trading Partner Manager
Prerequisites
Installing iWay Trading Partner Manager
Configuring and Using iWay Trading Partner Manager
Using the iWay Trading Partner Manager Web Console
Using Runtime Functions
iWay Trading Partner Manager Runtime Functions
JSON API Reference
Overview
Retrieving a Partner List
Retrieving a Partner System List
Retrieving a Partner Contact List
Creating a Partner
Deleting a Partner
Retrieving a Partner System
Adding MetaData
Adding MetaData Values
Adding a Partner Contact
Adding an Environment
Deleting an Environment
Retrieving an Environment
Adding a System
Adding a Partner System
Adding a Partner Certificate
Security
Recommended Practices
Debugging JSON
Launch PDF
Pretty Good Privacy (PGP) Extension User’s Guide
Introducing Pretty Good Privacy (PGP)
Overview
Cryptographic Services
Key Management
Supported Components
Configuring iWay Service Manager Components
Configuring the iWay Pretty Good Privacy (PGP) Extension
Configuring Bouncy Castle
Configuring Pretty Good Privacy (PGP)
Configuring the Java Runtime Environment
Configuring iSM Components for the iWay Pretty Good Privacy (PGP) Extension
Launch PDF
XML Archive User's Guide
Installing the iWay XML Archive
Installation Requirements
Installing iWay Service Manager
Installing mongoDB
Configuring the iWay XML Archive Application
Verifying the Installation
Using the iWay XML Archive
Architecture
XML and JSON
Loading Documents
Making Requests
The Query String
Query Grammar
Understanding the JSON Results
Returning XML Documents
Returning a Slice of XML With XQuery
Using the iWay XML Archive Test Client
Test Client Overview
Query Grammar in the Test Client
Launch PDF
Best Practices
Configuration and Usage Best Practices for iWay Service Manager
Ensuring Channels are Not Deployed to the iSM Base Configuration
Understanding the Base Configuration
Understanding the SOAP1 Listener
Adding an Error-to Agent to the SOAP1 Listener
Adding an Error-to Agent to the SOAP1 Listener
Using iWay Business Activity Monitor (BAM)
Overview
Best Practices
General Considerations Related to iWay BAM Performance
Using iWay Integration Applications (iIAs)
Overview
Best Practices
Configuring the Heap (Memory) Size
Overview
Setting the iSM Service Initial Heap Size
Benefits of Multiple Cores
Overview
Determining Core Usage on Windows Platforms
Determining Core Usage on Linux Platforms
Creating and Using a Remote Command Console
Overview
Creating a Remote Command Console
Connecting to a Remote Command Console
Using Event and Startup Process Flows
Event Process Flows
Startup Process Flow
Launch PDF
Troubleshooting and Debugging Best Practices for iWay Service Manager
Defining Troubleshooting and Debugging Strategies
Overview
Using iWay Service Manager Diagnostics, Tracing, and Logging Facilities
Running in a Command Shell
Diagnostic Commands
Troubleshooting on Windows
Performing Diagnostic Functions
Measurements and Statistics
Using the Log Viewer
Creating a Diagnostic Zip
Identifying Available Services for Troubleshooting and Debugging
Activity Log Entry Service (com.ibi.agents.XDXALogEvent)
Catch Service (com.bi.agents.XDCatchAgent)
Fail Service (com.ibi.agents.XDFailAgent)
QA Service (com.ibi.agents.XDQAAgent)
Trace Message Writer Service (com.ibi.agents.XDTraceAgent)
Identifying Available Commands and Functions for Troubleshooting and Debugging
Using the Testfuncs Tool
Using the Testxpath Tool
Using the Flow Command
Using the Line Command
Using the _eval() Function
Creating and Using a Remote Command Console
Overview
Creating a Remote Command Console
Connecting to a Remote Command Console
Using Event and Startup Process Flows
Event Process Flows
Startup Process Flow
Recommended Third-Party Tools for Troubleshooting and Debugging
JConsole
JVM Startup Options
SoapUI
KeyTool IUI
Operating System Commands
Wireshark
Tcpdump
Launch PDF
Integration Tools
Documentation
iWay Integration Tools User's Guide
Getting Started
Installing and Starting iIT
Configuring and Using iWay Integration Tools Suite
Concepts
Integration Perspective
Integration Explorer
Integration Projects
iWay Resources
Target Server Version
Customizations
Registry Explorer
Adapters
Schemas in Integration Projects
Register Sets
iWay Home Directory
Running iSM in iIT
Channel Editor
Library Manager
Tasks
Working With Integration Projects
Setting iWay Home Preferences
Setting a Default Target Server Version
Configuring Disposable Test Servers for Test Run Integration
Working With iWay Resources
Configuring and Using Schema Sets
Configuring and Using the Script Object
Importing iWay Archive Packages
Accessing iWay Service Manager Components in iWay Integration Tools
Launch PDF
iWay Integration Tools Designer User's Guide
Concepts
Introducing iIT Designer
The iIT Designer Environment
Defining Process Flow Objects
Tasks
Creating a Project
Managing Process Flows
Adding an Adapter to iIT Designer
Using Variables and XPath
Adding an Object to a Process Flow from an iSM Registry
Working with Customizations
Tutorial
An Example Process Flow
Process Flow Object Properties
Iterator Object Properties
SQL Object Properties
Launch PDF
iWay Integration Tools Transformer User's Guide
iWay Transformer Overview
About iWay Transformer
Getting Started With iWay Transformer
iWay Transformer Basic Tutorial
Project Configuration Tutorial
Dictionary Builder Tutorial
iWay Transformer Concepts
Transformation Process
iWay Transformer Mappings
iWay Transformer Supported Data Formats
Transform Component Dependencies
Using Namespaces in iWay Transformer
Transform Functions
Invisible Group
iWay Transformer Tasks
Creating a Transform Component
Configuring a Transform Component
Testing a Transform Component
Working With a Transform Component
Working With the Mapping Builder
Working With Namespaces
Working With Functions
iWay Transformer Tips and Tricks
XSLT Runtime Processing
Launch PDF
iWay Integration Application User's Guide
Getting Started
Basic iWay Integration Application Tutorial
Scripting Tutorial
Concepts
Contents
Tasks
Working With Applications
Working With Application Sources
Working With Ant Scripts
Working With Templates
Working With Admin Servers
Working With Remote Servers and Auto Updates
Reference
User Interface Information
Tips and Tricks
Introduction
Creating an iWay Integration Application
Creating Configuration Templates
Scripted Deployment
Launch PDF
Source Management (Version Control) Installation and Configuration Guide
Installing and Configuring a Source Management (Version Control) Repository for iWay Integration Tools
int_tools/source Management Overview
Installing Apache Subversion
Understanding the Physical Structure of Components in an Integration Project
Configuring and Working With Apache Subversion
Common Commands Used With Apache Subversion
Handling Conflict States
SVN Best Practices
Launch PDF
Software Development Kit
Documentation
iWay Software Development Kit User's Guide
Installing the iWay Software Development Kit
Overview
System Requirements
Installing the iWay SDK
Folder Structure
Getting Started With the iWay Software Development Kit
Understanding Apache Ant Tasks
Using Sample Integration Tasks
Creating Web Archives (WAR) Files
Using the iWay SDK
Launch PDF
Application Adapters
Documentation
Application Adapter for MUMPS User's Guide
Introducing the iWay Application Adapter for MUMPS
MUMPS Overview
Features of the iWay Application Adapter for MUMPS
Component Information for the iWay Application Adapter for MUMPS
Supported Platforms Matrix
Overview
Supported Versions
Operating Systems
Databases
Java Development Kit (JDK)
Communication Modes
Object Types and Interfaces
Communication Types
Operations
Data Types
Other Functions
Known Limitations
Related Information for Specific iWay Releases
Installing the iWay Application Adapter for MUMPS
Prerequisites
Installing the Server Component for the Adapter
Installing iWay Service Manager
Creating the Sample
MUMPS Adapter Services
RPCS Invocation
RPCD Invocation
Simple Query
Schema-Based Queries
Launch PDF
Application Adapter for Oracle E-Business Suite User's Guide
Introducing the iWay Application Adapter for Oracle E-Business Suite
Features of the iWay Application Adapter for Oracle E-Business Suite
Integration with Oracle E-Business Suite
Using the Adapter with Oracle APIs
iWay Oracle Wrapper Architecture
Component Architecture
Limitations and Best Practices
Integration Using OAGIS XML and EDI Documents
Deployment Information for Your iWay Adapter
Information Roadmap
Supported Platforms Matrix
Overview
Supported Versions
Operating Systems
Databases
Java Development Kit (JDK)
Communication Modes
Object Types and Interfaces
Communication Types
Operations
Data Types
Other Functions
Known Limitations
Related Information for Specific iWay Releases
Quick Start Guide
Overview
Quick Start Guide
Installing the iWay Oracle API Wrapper
Prerequisites
Installing the iWay Oracle Wrapper
Configuring and Managing Connections to Oracle E-Business Suite
Overview
Starting iWay Explorer
Creating a New Configuration
Connecting to a New Configuration
Connecting to Oracle E-Business Suite
Integrating With Oracle Interface Tables and Concurrent Programs
Browsing Interface Table Metadata
Generating XML Schemas for Interface Tables
Creating iWay Business Services for Interface Tables
Running a Submit Request
Integrating With Oracle APIs
Browsing Oracle API Metadata
Generating XML Schemas for Oracle APIs
Creating iWay Business Services for Oracle APIs
Integrating With Oracle Base Tables
Browsing Base Table Metadata
Generating XML Schemas for Base Tables
Creating iWay Business Services for Base Tables
Creating Prepared Statements and Batch Statements
Overview
Creating and Testing a Regular SQL Statement
Creating and Testing a Parameterized SQL Statement
Creating a Batch Statement and an Iterative Process
Listening for Oracle E-Business Suite Events
Understanding iWay Event Functionality
Creating an Event Port
Creating a Channel
Choosing a Listening Technique
Troubleshooting and Error Messages
Troubleshooting
iWay Business Services Provider Error Messages
Configuring the Adapter in an iWay Environment
Configuring the Adapter in iWay Service Manager
Configuring the Adapter in iWay Integration Tools Designer
Using the Adapter in iWay Integration Tools Designer
Supported Interface Tables for Oracle Release Apps 11i
Supported Interface Tables
Sample WSDL File
Sample WSDL File
Launch PDF
Application Adapter for PeopleSoft User's Guide
Introducing the iWay Application Adapter for PeopleSoft
Key Features of the iWay Application Adapter for PeopleSoft
How the iWay Application Adapter for PeopleSoft Works
Component Information
Supported Platforms Matrix
Overview
PeopleTools
Operating Systems
Databases
Java Development Kit (JDK)
Communication Modes
Object Types and Interfaces
Communication Types
Operations
Data Types
Other Functions
Known Limitations
Related Information for Specific iWay Releases
Quick Start Guide
Overview
Installing the Adapter
Configuring the Adapter
Upgrading PeopleTools
Configuring the iWay Application Adapter for PeopleSoft
Specifying the Version of PeopleSoft
Installing the Adapter Component Interfaces
Installing the TCP/IP Message Router for the iWay Application Adapter for PeopleSoft
Copying PeopleSoft Files Into the Lib Directory
Generating Component Interface APIs
Building the PeopleSoft API Java Programs
Compiling the PeopleSoft API Java Programs
Configuring the PeopleSoft Message Router
Configuring the TCP/IP or HTTP Target Connector for PeopleSoft 8.4
Configuring the TCP/IP Handler for PeopleSoft 8.1
Testing Your PeopleSoft Configuration
Creating XML Schemas or Web Services for PeopleSoft
Overview
Starting iWay Explorer
Establishing a Target for PeopleSoft
Modifying a Target
Viewing Application System Objects
Creating an XML Schema
Generating a Web Service for PeopleSoft
Listening for PeopleSoft Events
Understanding Event Functionality
Creating, Editing, or Deleting a Port
Creating, Editing, or Deleting a Channel
Configuring an HTTP Event Listener for PeopleSoft Using iWay Service Manager
Overview
Configuring an HTTP Listener
Troubleshooting and Error Messages
Error Messages in iWay Explorer
Error Messages in PeopleSoft
Error Messages in iBSP
Configuring the Adapter in an iWay Environment
Configuring the Adapter in iWay Service Manager
Using Component Interfaces
Creating a Component Interface
Viewing or Modifying Available Methods
Securing a Component Interface
Testing a Component Interface
Using PeopleSoft 8 Integration Broker
PeopleSoft Integration Broker
Configuring Integration Broker in PeopleSoft Release 8.4 (PeopleTools Releases 8.48 - 8.51)
Configuring Integration Broker in PeopleSoft Release 8.4 (PeopleTools Releases 8.40 - 8.47)
Configuring Application Messaging in PeopleSoft Release 8.1
Viewing the PeopleCode for a Message
Testing the Integration Broker
Using Outbound Synchronous Messages
PeopleTools Upgrade Considerations
Upgrading PeopleTools
Launch PDF
Application Adapter for Salesforce User's Guide
Introducing the iWay Application Adapter for Salesforce
Features of the iWay Application Adapter for Salesforce
Component Information for the iWay Application Adapter for Salesforce
Installing the iWay Application Adapter for Salesforce
Installation Prerequisites
Installing the Adapter
Configuring and Managing Connections to Salesforce
Starting iWay Explorer (Java Swing)
Creating a New Configuration
Connecting to a New Configuration
Connecting to Salesforce
Creating XML Schemas for Salesforce
Overview
Browsing Salesforce Business Objects
Generating XML Schemas for Salesforce Business Objects
Using the Upsert Function
Creating and Publishing iWay Business Services
Understanding iWay Business Services
Creating iWay Business Services
Configuring the Retrieve Function
Configuring Outbound Messaging and Workflow Rules in Salesforce
Overview
Creating an Outbound Message
Creating a Workflow Rule
Configuring Events for Salesforce
Overview
Creating an Event Port
Creating a Channel
Certificate Management
Prerequisites
Key Store Management
Trust Store Management
Salesforce Batch API
Using the Salesforce Batch API Services
Configuring the Adapter in an iWay Environment
Configuring the Adapter in iWay Service Manager
Launch PDF
Application Adapter for Siebel User's Guide
Introducing the iWay Application Adapter for Siebel
Features of the iWay Application Adapter for Siebel
Typical Siebel Server Deployment
The Siebel Application Model
Integrating With Siebel
Siebel EAI Architecture
Using iWay Explorer With the iWay Application Adapter for Siebel
Encoding Support on UNIX Platforms
Configuring Connection Pooling for Siebel
Siebel Version 6.2 and Lower Connectivity Prerequisites
Deployment Information for Your iWay Adapter
Information Roadmap
Supported Platforms Matrix
Overview
Siebel Versions
Operating Systems
Databases
Java Development Kit (JDK)
Communication Modes
Object Types and Interfaces
Communication Types
Operations
Other Functions
Known Limitations
Related Information for Specific iWay Releases
Creating XML Schemas and iWay Business Services
Processing Overview
Starting Servlet iWay Explorer
Managing a Siebel Connection
Viewing Metadata
Creating a Schema for a Siebel Business Component or Siebel Business Service
Creating an XML Schema for a Siebel Integration Object
Locating Schemas
Returning Fields in a Specified Order
Using the QueryWithView and QueryEx Methods
Understanding the ROW_ID and REASON Attributes
Creating iWay Business Services
Listening for Siebel Events
Understanding iWay Event Functionality
Creating an Event Port
Creating a Channel
Troubleshooting and Error Messages
Troubleshooting
Error Messages in iWay Explorer
Error Messages in Siebel
Error Messages in iBSP
Updating a Siebel Field
Configuring the Adapter in an iWay Environment
Configuring the Adapter in iWay Service Manager
Siebel Workflows
Overview
Creating a Siebel Workflow
Launch PDF
Application Adapter for Microsoft Exchange User's Guide
Introducing the iWay Application Adapter for Microsoft Exchange
iWay Application Adapter for Microsoft Exchange
About Microsoft Exchange Server
Features of the iWay Application Adapter for Microsoft Exchange
Microsoft Exchange Server Versions and Exchange Web Services API Files
Component Information
Supported Platforms Matrix
Overview
Supported Versions
Operating Systems
Databases
Java Development Kit (JDK)
Communication Modes
Object Types and Interfaces
Communication Types
Operations
Data Types
Security
Other Functions
Known Limitations
Related Information for Specific iWay Releases
Quick Start Guide
Overview
Quick Start Guide
Configuring the iWay Application Adapter for Microsoft Exchange
Copying the Exchange Web Services API Library Files
Defining a Keystore
Creating a Keystore
Generating a Certificate
Importing a Certificate to a Keystore
Importing the SSL Certificate
Creating XML Schemas and Business Services
Starting iWay Explorer
Adding the Microsoft Exchange Adapter to iWay Explorer
Working With a Target
Viewing Application System Objects
Creating an XML Schema
Creating Business Services
Configuring the Adapter in an iWay Environment
Defining the Microsoft Exchange Adapter in iWay Service Manager
Configuring the Microsoft Exchange Listener
Adding the Microsoft Exchange Listener to an Inlet
Configuring a Channel
Launch PDF
Application Adapter for Microsoft Dynamics CRM 2011 On-Premises User's Guide
Introducing the iWay Application Adapter for Microsoft Dynamics CRM 2011 On-Premises
Introduction
Supported Adapter Functionality
Installing the Adapter
Understanding the Microsoft Dynamics CRM Communication Model
Component Information for the Adapter
Supported Platforms Matrix
Overview
Supported Versions
Operating Systems
Databases
Java Development Kit (JDK)
Communication Modes
Communication Types
Object Types and Interfaces
Operations
Data Types
Other Functions
Known Limitations
Restrictions
Related Information for Specific iWay Releases
Quick Start Guide
Overview
Quick Start Guide
Design Time Concepts and Configuration Tasks
Starting iWay Explorer
Adding the Microsoft Dynamics CRM 2011 Adapter to iWay Explorer
Working With a Target
Navigating the Entity and Operation Tree
Creating an XML Schema
Creating Business Services
Run Time Concepts and Configuration Tasks
Create, Read, Update, and Delete Operations
Compound Operations
Advanced Operations
Operation Sets
Retrieving Multiple Requests
Validating Input Messages
Error Handling
Caching
Connection Pool
Executing Processes (Workflow)
Importing Bulk Data
Deleting Bulk Data
Optimizing Microsoft Dynamics CRM 2011 Using HTTP Compression
Configuring the iWay WCF Routing Service (WCF Router)
Overview
Installing the WCF Router
Configuring the WCF Router
Storing Administrator Credentials in the WCF Router
Using the WCF Router to Connect to MS CRM (Selecting the Connection Mode)
Using SSL Server Certificates
Configuring the WCF Router to Work With the Adapter Through HTTPS
Installing a Certificate as a Trusted Certificate in the Java Keystore
Samples and Reference Guide
Advanced Operations
Schemas for Advanced Operations
Global Operations
Filter Document Sample
Input Message Sample
Create and Update Operation Samples
Compound Operation Sample
Linked Operation Output Sample
Bulk Delete Sample
XML Request Schema Sample
XML Response Schema Sample
Manually Setting User Interface Languages
Known Issues and Limitations
General Known Issues
Unsupported Schemas
Launch PDF
Application Adapter for J.D. Edwards EnterpriseOne User's Guide
Introducing the iWay Application Adapter for J.D. Edwards EnterpriseOne
Executing a J.D. Edwards EnterpriseOne Master Business Function
J.D. Edwards EnterpriseOne Platforms, Products, and Releases Supported
J.D. Edwards EnterpriseOne Versions and Library Files
Accessing Data Stored in J.D. Edwards EnterpriseOne
J.D. Edwards EnterpriseOne Interoperability Framework
Deployment Information for Your iWay Adapter
Information Roadmap
Supported Platforms Matrix
Overview
Supported Versions
Operating Systems
Databases
Java Development Kit (JDK)
Communication Modes
Object Types and Interfaces
Communication Types
Operations
Data Types
Other Functions
Known Limitations
Related Information for Specific iWay Releases
Quick Start Guide
Overview
Quick Start Guide
Configuring Adapter Targets and Creating XML Schemas
Overview
Starting iWay Explorer
Adding the J.D. Edwards EnterpriseOne Adapter to iWay Explorer
Working With a Target
Viewing J.D. Edwards EnterpriseOne Business Functions
Creating an XML Schema
Creating XML Request Documents
Creating and Publishing iWay Business Services
Understanding iWay Business Services
Creating iWay Business Services
Connecting to the J.D. Edwards EnterpriseOne Client
Listening for Database Events
Understanding Event Functionality
Troubleshooting
Troubleshooting
Error Messages in iWay Explorer
Error Messages in J.D. Edwards EnterpriseOne
Error Messages in iWay Business Services Provider
Configuring the Adapter in an iWay Environment
Configuring and Deploying the iWay Application System Adapter for J.D. Edwards EnterpriseOne
Configuring the Adapter in iWay Integration Tools Designer
Using the Adapter in iWay Integration Tools Designer
Configuring EnterpriseOne for Outbound Transaction Processing
Specifying Outbound Functionality for a Business Function
Configuring an Event Listener for the iWay Application Adapter for J.D. Edwards EnterpriseOne
XML List Method Support
Modifying the EnterpriseOne jde.ini File
Sample Files
Issuing a Single-Function Request
Issuing a Multiple-Function Request
Sample Sales Order Request
Sample Sales Order Response
Launch PDF
Application Adapter for J.D. Edwards World User's Guide
Introducing the iWay Application Adapter for J.D. Edwards World
Introducing J.D. Edwards World
Supported Versions
Accessing Data Stored in J.D. Edwards World
J.D. Edwards World Interoperability Framework
Deployment Information for Your iWay Adapter
Information Roadmap
Supported Platforms Matrix
Overview
Supported Versions
Operating Systems
Databases
Java Development Kit (JDK)
Communication Modes
Object Types and Interfaces
Communication Types
Operations
Data Types
Other Functions
Security
Known Limitations
Related Information for Specific iWay Releases
Quick Start Guide
Overview
Quick Start Guide
Creating XML Schemas for J.D. Edwards World
Overview
Starting iWay Explorer
Establishing a Target for J.D. Edwards World
Modifying a Target
Viewing J.D. Edwards World Libraries
Creating an XML Schema
Generating an iWay Business Service for J.D Edwards World
Configuring Events for the iWay Application Adapter for J.D. Edwards World
Creating a Trigger on a Base Table
Creating a Custom Table for J.D. Edwards World
Understanding Event Functionality
Creating, Editing, or Deleting a Port
Creating, Editing, or Deleting a Channel
Configuring the Adapter in an iWay Environment
Configuring the Adapter in iWay Service Manager
Configuring the Adapter in iWay Integration Tools Designer
Using the Adapter in iWay Integration Tools Designer
Sample File
Sample XML File
Launch PDF
Application Adapter for SAP ERP User's Guide
Introducing the iWay Application Adapter for SAP ERP
Features of the iWay Application Adapter for SAP ERP
Classic SAP ERP Technologies for ABAP
Supported Versions and Platforms
Integrating With SAP ERP
Component Information for the iWay Application Adapter for SAP ERP
Web Services and Java Connector Architecture Functionality
Supported Platforms Matrix
Overview
Supported Versions
Operating Systems
Databases
Java Development Kit (JDK)
Communication Modes
Object Types and Interfaces
Communication Types
Operations
Data Types
Other Functions
Known Limitations
Related Information for Specific iWay Releases
Quick Start Guide
Overview
Quick Start Guide
Getting Started
Installing the iWay Application Adapter for SAP ERP
Installing the SAP Java Connector (SAP JCo) 3.x
Verifying the SAP Java Connector (SAP JCo)
Identifying SAP ERP Logon Parameters
Verifying Connections to SAP ERP
Configuring SAP ERP Inbound Processing
Adapter Process Overview
Configuring a Logical System
Configuring a Distribution Model
Defining a Partner Profile
Configuring Adapter Targets and Creating XML Schemas
Overview
Understanding SAP ERP Nested Structures and Nested Tables
Starting iWay Explorer
Adding the SAP ERP Adapter to iWay Explorer
Working With a Target
Viewing Application System Objects
Creating an XML Schema
Creating and Publishing iWay Business Services
Understanding iWay Business Services
Creating iWay Business Services
Understanding SAP ERP Events
Overview
Related Concepts and Terminology
Registering Your Program ID in SAP GUI
Testing the SAP ERP Event Adapter
Application Link Enabling Configuration for the Event Adapter
Testing the SAP ALE Configuration
Configuring Event Handling
Understanding iWay Event Functionality
Creating a Port
Creating a Channel
Synchronous Event Processing
Configuring the Adapter in an iWay Environment
Configuring the Adapter in iWay Service Manager
Troubleshooting Guidelines
Identifying the Issue
Design Time
Run Time
Debugging Error Messages
Gathering Information Before Calling Customer Support
Launch PDF
e-Business Adapters
Documentation
Integration Solution for SWIFT 2017 User's Guide
Introducing the iWay Integration Solution for SWIFT
A Brief History of SWIFT
Features of the iWay Integration Solution for SWIFT
Information Roadmap
Deployment Information for Your iWay Integration Solution
iWay Products
Using a Channel to Construct a Message Flow
Components of the iWay Integration Solution for SWIFT
Configuring the EDI Activity Driver
Overview
Configuring the EDI Data Provider Using iWay Service Manager
Configuring the EDI Activity Driver Using iWay Service Manager
Working With SWIFT Inbound and Outbound Applications Using iWay Integration Tools (iIT)
Overview
Prerequisites
Extracting SWIFT User Samples
Importing SWIFT User Samples to iWay Integration Tools as a Workspace
Publishing iWay Integration Applications to the iWay Service Manager Registry
Deploying iWay Integration Applications to iWay Service Manager
Setting Registers in the iWay Service Manager Administration Console
Stopping Inbound (SWIFT to XML) and Outbound (XML to SWIFT) Processing
Testing the Sample Applications
Inbound Processing: SWIFT to XML
Inbound Processing Overview
Sample Configuration for Inbound Processing: SWIFT to XML
Outbound Processing: XML to SWIFT
Outbound Processing Overview
Sample Configuration for Outbound Processing: XML to SWIFT
Ebix-Supported Transaction Sets
Transaction Set Support
Using iWay Integration Tools to Configure an Ebix for SWIFT
Overview
Prerequisites
Downloading and Extracting an Ebix
Working With iWay Integration Tools (iIT)
Sample SWIFT Documents
SWIFT MT950 (Statement of Cash) Sample Document
SWIFT MT535 (Statement of Holding) Sample Document
SWIFT MT541 (Receive Against Payment) Sample Document
Launch PDF
Integration Solution for EDI X12 User's Guide
Introducing the iWay Integration Solution for EDI X12
A Brief History of Electronic Data Interchange
Features of the iWay Integration Solution for EDI X12
Information Roadmap
Deployment Information for Your iWay Integration Solution
iWay Products and Components
Using a Channel to Construct a Message Flow
Components of the iWay Integration Solution for EDI
Configuring the EDI Activity Driver
Overview
Configuring the EDI Data Provider Using iWay Service Manager
Configuring the EDI Activity Driver Using iWay Service Manager
Working With EDI X12 Inbound and Outbound Applications Using iWay Integration Tools (iIT)
Overview
Prerequisites
Downloading and Extracting EDI X12 User Samples
Importing EDI X12 User Samples to iWay Integration Tools as a Workspace
Publishing iWay Integration Applications to the iWay Service Manager Registry
Deploying iWay Integration Applications to iWay Service Manager
Setting Registers in the iWay Service Manager Administration Console
Stopping Inbound (EDI X12 to XML) and Outbound (XML to EDI X12) Processing
Testing the Sample Applications
Inbound Processing: EDI X12 to XML
Inbound Processing Overview
Sample Configuration for Inbound Processing: EDI to XML
Outbound Processing: XML to EDI X12
Outbound Processing Overview
Sample Configuration for Outbound Processing: XML to EDI
Ebix-Supported Transaction Sets
Transaction Set and Acknowledgement Support
Using iWay Integration Tools to Configure an Ebix for EDI X12
Overview
Prerequisites
Downloading and Extracting an Ebix File
Working With iWay Integration Tools (iIT)
Separators and Terminators
Separators and Terminators
Special Register (SREG) Types
Special Register (SREG) Types
Sample EDI X12 Files
Sample EDI 4010 850 Purchase Order
Sample EDI 4010 810 Invoice
Sample EDI 4010 856 Advanced Ship Notice
Tutorial: Mapping an IDOC to an Invoice Document (810)
Overview
Creating a New Transform Project
Understanding EDI Invoice Mapping
Mapping the Control Segments
Mapping the Header Section
Mapping the ITEM Detail
Mapping the Invoice Summary Section
Testing the Transform Project
Tutorial: Mapping an IDOC to an Advanced Ship Notice (ASN)
Overview
Creating a New Transform Project
Maintaining the HL Counters in a Transform Project
Showing and Hiding Tags
Mapping the Control Segments
Initializing Constant Values
Mapping the Begin Ship Notice (BSN) Segments
Configuring Shipment Level Segments
Configuring Order Level Segments
Configuring Pack Level Segments
Configuring Item Level Segments
Configuring the Summary Level Segment
Publishing the Transform Project
IDoc Structure
Workflow
Transformation
The Final Results
Flattening the Output Structure
Tutorial: Adding a Detail Line Counter to a Purchase Order Transform
Configuring the Required Variables
Using the Graphical Mapping Builder
Launch PDF
Integration Solution for UN/EDIFACT User's Guide
Introducing the iWay Integration Solution for UN/EDIFACT
A Brief History of EDIFACT
Features of the iWay Integration Solution for UN/EDIFACT
Information Roadmap
Deployment Information for Your iWay Integration Solution
iWay Products and Components
Using a Channel to Construct a Message Flow
Components of the iWay Integration Solution for UN/EDIFACT
Configuring the EDI Activity Log
Overview
Configuring the EDI Activity Log Using iWay Service Manager
Working With UN/EDIFACT Inbound and Outbound Applications Using iWay Integration Tools (iIT)
Overview
Prerequisites
Extracting EDIFACT User Samples
Importing EDIFACT User Samples to iWay Integration Tools as a Workspace
Publishing iWay Integration Applications to the iWay Service Manager Registry
Deploying iWay Integration Applications to iWay Service Manager
Setting Registers in the iWay Service Manager Administration Console
Stopping Inbound (EDIFACT to XML) and Outbound (XML to EDIFACT) Processing
Testing the Sample Applications
Inbound Processing: UN/EDIFACT to XML
Inbound Processing Overview
Sample Configuration for Inbound Processing: EDIFACT to XML
Outbound Processing: XML to UN/EDIFACT
Outbound Processing Overview
Sample Configuration for Outbound Processing: XML to EDIFACT
UN/EDIFACT Supported Versions
UN/EDIFACT Version Support
Using iWay Integration Tools to Configure an Ebix for EDIFACT
Overview
Prerequisites
Downloading and Extracting an Ebix
Working With iWay Integration Tools (iIT)
Special Register (SREG) Types
Special Register (SREG) Types
Sample UN/EDIFACT Files
APERAK (Application Error and Acknowledgment)
Version 3 CONTRL
INVOIC (Invoice Message)
ORDERS (Purchase Order Message)
Launch PDF
Integration Solution for HIPAA User's Guide
Introducing the iWay Integration Solution for HIPAA
The HIPAA Mandate
Promoting HIPAA Compliance and Integration
Features of the iWay Integration Solution for HIPAA
Information Roadmap
Deployment Information for Your iWay Integration Solution
iWay Products
Using a Channel to Construct a Message Flow
Components of the iWay Integration Solution for HIPAA
Configuring the EDI Activity Driver
Overview
Configuring the EDI Data Provider Using iWay Service Manager
Configuring the EDI Activity Driver Using iWay Service Manager
Working With HIPAA Inbound and Outbound Applications Using iWay Integration Tools (iIT)
Overview
Prerequisites
Extracting HIPAA User Samples
Importing HIPAA User Samples to iWay Integration Tools as a Workspace
Publishing iWay Integration Applications to the iWay Service Manager Registry
Deploying iWay Integration Applications to iWay Service Manager
Setting Registers in the iWay Service Manager Administration Console
Stopping Inbound (HIPAA to XML) and Outbound (XML to HIPAA) Processing
Testing the Sample Applications
Inbound Processing: HIPAA to XML
Inbound Processing Overview
Sample Configuration for Inbound Processing: HIPAA to XML
Outbound Processing: XML to HIPAA
Outbound Processing Overview
Sample Configuration for Outbound Processing: XML to HIPAA
Ebix-Supported Transaction Sets
Supported HIPAA Transactions
Using iWay Integration Tools to Configure an Ebix for HIPAA
Overview
Prerequisites
Downloading and Extracting an Ebix
Working With iWay Integration Tools (iIT)
Special Register (SREG) Types
Special Register (SREG) Types
Separators and Terminators
Separators and Terminators
Sample HIPAA Files
Sample HIPAA Message
Sample 997 Functional Acknowledgment
Sample Output XML Document
Sample Output Validation Report
Tutorial: Adding a Detail Line Counter to a Purchase Order Transform
Configuring the Required Variables
Using the Graphical Mapping Builder
Launch PDF
Integration Solution for EDIHL7 User's Guide
Introducing the iWay Integration Solution for EDIHL7
Prerequisites
Understanding the HL7 Protocol
Components of an HL7 Message
Sample Integration Scenario
HL7 Inbound and Outbound Flows Using MLLP
Features of the iWay Integration Solution for EDIHL7
Components of the iWay Integration Solution for EDIHL7
Deployment Information for Your iWay Integration Solution
iWay Products and Components
Using a Channel to Construct a Message Flow
Downloading, Extracting, and Importing HL7 Sample Data
Downloading and Extracting HL7 Sample Data
Importing HL7 Sample Data to iWay Integration Tools as a Workspace
Configuring the EDI Activity Driver
Overview
Configuring the EDI Data Provider Using iWay Service Manager
Configuring the EDI Activity Driver Using iWay Service Manager
Inbound Processing: HL7 to XML
Configuring a Channel for Inbound Processing
Configuring Register Sets and Registers
Importing an Ebix Into the Workspace
Configuring an iWay Integration Application for Inbound Processing
Setting System Registers
Testing the Inbound Channel Application
Inbound Processing: HL7 to XML (Using MLLP)
Configuring a Channel for Inbound Processing
Configuring Register Sets and Registers
Importing an Ebix Into the Workspace
Configuring an iWay Integration Application for Inbound Processing
Setting System Registers
Testing the Inbound Channel Application Using MLLP
Outbound Processing: XML to HL7
Configuring a Channel for Outbound Processing
Configuring Register Sets and Registers
Importing an Ebix Into the Workspace
Configuring an iWay Integration Application for Outbound Processing
Setting System Registers
Testing the Outbound Channel Application
Outbound Processing: XML to HL7 (Using MLLP)
Configuring a Channel for Outbound Processing
Configuring Register Sets and Registers
Importing an Ebix Into the Workspace
Configuring an iWay Integration Application for Outbound Processing
Setting System Registers
Testing the Outbound Channel Application Using MLLP
Supported HL7 Versions
Supported HL7 Versions and Messages
Separators and Terminators
Separators and Terminators
Using iWay Integration Tools to Configure an Ebix for HL7
Overview
Prerequisites
Loading an Ebix
Working With iWay Integration Tools (iIT)
Launch PDF
Release Notes for iWay E-Business Adapters
Release Notes for iWay E-Business Adapters
Fixed, Resolved, or Included in This Release
Known Issues
ANSI X12, VICS, UCS, and HIPAA Documents
EDIFACT Documents
SWIFT Documents
HL7 Documents
EDIHL7 Documents
Separators and Delimiters for X12, HIPAA, EDIFACT, and EDIHL7
Launch PDF
Protocol Adapters
Documentation
iWay Application Protocol Adapter for LDAP User’s Guide
Introducing the iWay Application Protocol Adapter for LDAP
Features of the iWay Application Protocol Adapter for LDAP
Component Information for the iWay Application Protocol Adapter for LDAP
Supported Platforms Matrix
Overview
LDAP Versions
Operating Systems
Databases
Java Development Kit (JDK)
Communication Modes
Object Types and Interfaces
Communication Types
Operations
Data Types
Other Functions
Known Limitations
Related Information for Specific iWay Releases
Installing the iWay Application Protocol Adapter for LDAP
Installation Prerequisites
Installing the iWay Application Protocol Adapter for LDAP
Configuring and Managing Connections to an LDAP Server
Starting iWay Explorer
Adding the LDAP Adapter to iWay Explorer
Working With a Target
Initializing a Secure Connection to an LDAP Server
Prerequisites
Installing a Secure Certificate for an LDAP Server
Creating XML Schemas for LDAP
Overview
Browsing LDAP Entries
Generating XML Schemas for LDAP Operations
Creating and Publishing iWay Business Services
Understanding iWay Business Services
Creating iWay Business Services
Configuring Events for LDAP
Overview
Creating an Event Port
Creating a Channel
Configuring the Adapter in an iWay Environment
Configuring the Adapter in iWay Service Manager
Understanding Active Directory Error Messages
Error Messages
Launch PDF
iWay Application Protocol Adapter for ConnectDirect User’s Guide
Introducing the iWay Protocol Adapter for Connect:Direct
Features of the iWay Protocol Adapter for Connect:Direct
Understanding Connect:Direct
Service Adapter Functionality
Event Adapter Functionality
Supported Platforms Matrix
Overview
Supported Versions
Operating Systems
Databases
Java Development Kit (JDK)
Communication Modes
Object Types and Interfaces
Communication Types
Operations
Data Types
Other Functions
Known Limitations
Related Information for Specific iWay Releases
Installing the iWay Protocol Adapter for Connect:Direct
Prerequisites
Installation Files
Installing the Adapter
Creating XML Schemas and Business Services
Overview
Starting iWay Explorer
Adding the Connect:Direct Adapter to iWay Explorer
Working With a Target
Viewing Application System Objects
Creating an XML Schema
Creating Business Services
Sample XML Request and Response Schemas
Configuring Event Handling
Overview
Understanding Ports and Channels
Creating a Port
Creating a Channel
Launch PDF
Legacy Adapters
Documentation
iWay Emulation Adapter (3270/5250) User's Guide
Introducing the iWay Emulation Adapter (3270/5250)
Integrating Mainframe Logic
Remote Procedure Call Development Mode
Installing the iWay Emulation Adapter (3270/5250)
Deployment Information for the iWay Emulation Adapter (3270/5250)
Understanding Telnet Designer
Navigating Telnet Designer
Menu Options
Working With Telnet Designer Projects
Telnet Designer Tools
Using Remote Procedure Call Mode
Remote Procedure Call Mode Overview
Creating a Transaction Module
Creating XML Schemas and iWay Business Services
Creating an Adapter Transaction
Understanding iWay Business Services
Creating iWay Emulation Adapter (3270/5250) iWay Business Services
Using Emulation and Recorder Modes
Using Emulation Mode
About Recorder Mode
Creating a Prerecorded File
Developing Against a Prerecorded File
Emulator Keyboard Mapping
Emulator Keyboard Mapping
Launch PDF
Transaction Adapter for IMS User’s Guide
Introducing the Transaction Adapter for IMS
Overview
Understanding the iWay Transaction for IMS
Deployment Information for the iWay Transaction Adapter for IMS
Configuring the Adapter
Starting iWay Explorer (Java Servlet)
Configuring a Connection to IMS/TM
Managing a Connection to IMS/TM
Creating XML Schemas and iWay Business Services
Creating an Adapter Transaction
Creating Schemas for an Adapter Transaction
Understanding iWay Business Services
Event Processing With the IMS Adapter
Understanding IMS Events
Configuring IMS Events
Creating and Modifying an Event Port
Creating and Modifying a Channel
Testing IMS Events
Running IMS Events
Configuring the Adapter in an iWay Environment
Configuring the Adapter in iWay Service Manager
Using the IMS Sample Programs
IWTEST01 Sample Program
IWTEST05 Sample Program
IWTEST10 Sample Program
IWAYEVT0 Sample Program
IWAYEVT2 Sample Program
Sample Requests, Schemas, and COBOL File Descriptions
Request Document to Run PART as a Generic Transaction
Request Schema for Generic Transaction PART
Response Schema for Generic Transaction PART
Request Documents for Adapter Transaction PART
Request Schema for Adapter Transaction PART
Response Schema for Adapter Transaction PART
Sample COBOL File Descriptions for PART
Conversational Transaction Sample
Debugging and Troubleshooting
Troubleshooting
Launch PDF
Transaction Adapter for CICS User’s Guide
Introducing the iWay Transaction Adapter for CICS
Overview
The iWay Transaction Adapter for CICS
Deployment Information for Your iWay Adapter
Information Roadmap
Configuring the Adapter
Starting iWay Explorer (Java Servlet)
Configuring a Connection to CICS
Managing a Connection to CICS
Creating XML Schemas and iWay Business Services
Creating an Adapter Transaction
Creating Schemas for an Adapter Transaction
Understanding iWay Business Services
Event Processing With the CICS Adapter
Understanding CICS Events
Configuring CICS Events
Creating and Modifying an Event Port
Creating and Modifying a Channel
Testing CICS Events
Running CICS Events
Configuring the Adapter in an iWay Environment
Configuring the Adapter in Service Manager
Running the Adapter Using LU6.2 Communication
MVS OS/390 APPC Communication
Microsoft SNA Server Communication
Application Run-Time Requirements
Running the Adapter Using TCP/IP Communication
MVS OS/390 TCP/IP Communication
Using Adabas/Natural Programs
Overview
Installing the Adabas/Natural Interface
Writing and Configuring a Natural Program
Installing the Sample IWAYIVP and IWAYSRV0 Programs in CICS
Installing and Configuring IWAYIVP
Installing and Configuring IWAYSRV0
Sample Requests, Schemas, and COBOL File Descriptions
Request Document for the Generic Transaction, IWAYIVP
Request Schema for IWAYIVP
Response Schema for IWAYIVP
Request Documents for IWAYSRV0
Request Schema for IWAYSRV0
Response Schema for IWAYSRV0
Request Document for AASNATN
Request Schema for AASNATN
Response Schema for the Program AASNATN
Sample COBOL File Descriptions
Sample Programs
IWAYIVP Program
IWAYSRV0 Program
IWAYEVT0 Program
IWAYEVT1 Program
Natural Program
Debugging and Troubleshooting
Troubleshooting
Data Type Conversions
Launch PDF
Technology Adapters
Documentation
iWay Technology Adapter for .NET User's Guide
Introducing the iWay .NET Technology Adapter
Overview
Installing the iWay .NET Technology Adapter
Understanding the Technology of the iWay .NET Adapter
Component Information for the iWay .NET Technology Adapter
Supported Platforms Matrix
Overview
Supported Versions
Operating Systems
Databases
Java Development Kit (JDK)
Communication Modes
Object Types and Interfaces
Communication Types
Operations
Data Types
Other Functions
Known Limitations
Restrictions
Common Language Run-time Scope
Related Information for Specific iWay Releases
Design Time Concepts and Configuration Tasks
Exploring Assemblies
Starting iWay Explorer
Adding the .NET Adapter to iWay Explorer
Working With a Target
Understanding the Assembly Viewer in iWay Explorer
Controlling the Adapter Behavior Using a Properties File
Run Time Concepts and Configuration Tasks
Run Time Implementation
Understanding Design Time and Run Time Targets
Using the Persist Connection Parameter
Understanding the Relationship Between Java and .NET
Invoking the iWay .NET Technology Adapter
Configuring the Adapter in an iWay Environment
Configuring the Adapter in iWay Service Manager
Samples and Reference Guide
Using COM Interop in the iWay .NET Technology Adapter
Generating XML Schema in Legacy Mode
Generating XML Schema in the Current Adapter Version
Modifying XML Schemas
Additional Sample XML Documents
Known Issues and Limitations
Supported and Unsupported Areas
Tested Application Scope
Launch PDF
iWay Technology Adapter for ESRI User's Guide
Introducing the iWay Technology Adapter for ESRI
Introduction to ESRI and Geographic Information Systems
About the iWay Technology Adapter for ESRI
Installation Notes
Component Information for the iWay Technology Adapter for ESRI
Information Roadmap
Supported Platforms Matrix
Overview
Supported Versions
Operating Systems
Databases
Java Development Kit (JDK)
Communication Modes
Object Types and Interfaces
Communication Types
Operations
Data Types
Other Functions
Known Limitations
Related Information for Specific iWay Releases
Creating Targets
About Targets
Starting iWay Explorer
Creating a New Configuration in Java Swing iWay Explorer
Creating and Managing a Connection
Creating XML Schemas and iWay Business Services
Overview of Schemas and iWay Business Services
Generating Schemas
Creating an iWay Business Service
Using the Adapter - A Scenario
The Scenario Overview
Obtaining Geocoding Address Data
Delivering Geocoding Data to the ESRI Database
Manipulating Data in the ESRI Database
Configuring the Adapter in an iWay Environment
Configuring the Adapter in iWay Service Manager
Troubleshooting
Troubleshooting
iWay Business Services Provider Error Messages
Launch PDF
iWay Technology Adapter for RDBMS User's Guide
Introducing the iWay Technology Adapter for RDBMS
Introduction
Using the Adapter With Relational Databases
Using the Adapter to Access Non-relational Databases
Deployment Information for Your iWay Adapter
Information Roadmap
Creating XML Schemas or Business Services
Generating Schemas and Business Services
Starting iWay Explorer
Creating and Managing a Connection
Viewing Metadata
Understanding and Testing Stored Procedures
Understanding and Testing Stored Procedures and Functions Contained in an Oracle Package
Creating an SQL Statement and Generating Schemas
Understanding and Creating Batch Statements
Request and Response Documents
Understanding iWay Business Services
Listening for Database Events
Understanding iWay Event Functionality
Creating, Editing, or Deleting an Event Port
Creating, Editing, or Deleting an Event Channel
Choosing a Listening Technique
Standard Event Processing With Row Tracking
Standard Event Processing With Row Removal
Trigger-based Event Processing
Configuring the Adapter in an iWay Environment
Configuring the Adapter in iWay Service Manager
JDBC Drivers
Copying and Collecting a JDBC File
Launch PDF
Log Event Adapters
Documentation
Log Event Adapter for SQL Server
Introducing the iWay Log Event Adapter for Microsoft SQL Server
Overview
Architecture of the iWay Log Event Adapter for Microsoft SQL Server
Component Information for the iWay Log Event Adapter for Microsoft SQL Server
Installing and Configuring the iWay Log Event Adapter for Microsoft SQL
Prerequisites
Remote Component Installation Requirements
Installing the iWay Log Event Adapter for MS SQL
Constraints and Limitations
Apex Installation Troubleshooting
Configuring Components for the iWay Log Event Adapter for Microsoft SQL Server
Configuring the DOT NET Adapter
Configuring the iWay CDC SQL Batch Agent
Launch PDF
Log Event Adapter for Informix
Introducing the iWay Log Event Adapter for Informix
Features of the iWay Log Event Adapter for Informix
Architecture Overview of the iWay Log Event Adapter for Informix
Component Information for the iWay Log Event Adapter for Informix
Installing and Configuring the iWay Log Event Adapter for Informix
Prerequisites
Installing the iWay Log Event Adapter for Informix
Installing the iWay Informix CDC Agent
Configuring the iWay Log Event Adapter for Informix
Configuring Components for the iWay Log Event Adapter for Informix
Understanding the Table List Configuration File
Understanding CDC Subscription
Configuring the iWay Informix CDC Agent
Modifying an Informix Table Marked for Replication
Configuring the iWay Log Event Listener
Configuring the iWay CDC SQL Batch Agent
Launch PDF
Log Event Adapter for Oracle
Introducing the iWay Log Event Adapter for Oracle
Overview
Component Information for the iWay Log Event Adapter for Oracle
Installing and Configuring the iWay Log Event Adapter for Oracle
Prerequisites
Installing the iWay Log Event Adapter for Oracle
Using Oracle LogMiner
Importing a Sample Channel Archive Using iWay Service Manager
Building and Deploying a Channel
Configuring Components for the iWay Log Event Adapter for Oracle
Configuring the iWay Log Event Listener
Configuring the iWay CDC SQL Batch Agent
Launch PDF
DataMigrator
Documentation
DataMigrator User's Guide
Introduction to DataMigrator
Data Management and Migration Overview
What Is DataMigrator?
DataMigrator Architecture
DataMigrator Server
DataMigrator Data Management Console
Server Web Console
Designing Data Flows and Process Flows
Revised Functionality
Getting Help
Information Builders and iWay Software on the Web
Setting Up DataMigrator
DataMigrator Setup At a Glance
Remote Server Setup At a Glance
DataMigrator Setup
Initiating Server Administration Tasks
Authorizing DataMigrator Server Usage and Administration
Managing Application Directories and Configuring the Application Path
Configuring Data Adapters
Creating Metadata
Testing Sample Data and Process Flows
Performing Server Administration Tasks
Using Secure Shell FTP (SFTP)
Upgrading DataMigrator From Release 4.3 or 5.1
Upgrading DataMigrator from Release 5.2, 5.3, 7.1, or 7.6
Planning a DataMigrator Application
Designing Your Application
Using Synonyms for Data Sources and Data Targets
Reviewing Your Data Sources
Reviewing Your Data Targets
Establishing Security for DataMigrator
Working in the Data Management Console
Data Management Console Interface
Navigation Pane
DataMigrator Workspace
Text Editor
Aerial View
Ribbon Tabs
Metadata Tab
Text Editor Tab
Console Log
Setting Flow Properties
Viewing Properties
Setting User Preferences
User Privileges
License Code
Configuring National Language Support
Ending a Data Management Console Session
Designing a Data Flow
The Data Flow Interface
Simple Data Flow at a Glance
Complex Data Flow at a Glance
Creating a Data Flow
Specifying Data Sources
Creating a Source Transformation in a Data Source Object
Joining Data Sources
Adding a SELECT to a Data Flow
Adding a UNION to a Data Flow
Selecting Columns
Testing the SQL Statement
Specifying Filters in a Data Flow
Specifying Sorts
Selecting a Data Target
Specifying Data Target Options
Mapping Transformations
Using Variables in a Flow
Using Functions
Column Formats and Mapping
Setting Properties of a Flow
Running a Data Flow
Creating a Direct Load Flow
Creating a DBMS SQL Flow
Creating a Quick ETL Copy
Designing a Process Flow
Process Flow Methodology
Process Flow Interface
Simple Process Flow At a Glance
Complex Process Flow at a Glance
Creating a Process Flow
Adding a Saved Procedure to a Process Flow
Assigning and Using Variables in a Process Flow
Maintaining Continuous Processing in a Single Agent
Executing a Process Flow That Contains Only Procedures
Adding Email Messages to a Process Flow
Setting Connection Logic
Grouping and Controlling Simultaneous Execution of Flows
Running a Process Flow
Scheduling a Process Flow
Tutorial: Creating Data and Process Flows With DataMigrator
What You Are Going To Do
Startup and Setup Tasks
Exercise 1: Creating the Data Flow
Selecting and Joining Data Sources
Selecting and Managing Columns
Adding Data Targets
Submitting the Data Flow
Data Flow Review
Exercise 2: Creating the Process Flow
Starting the Process Flow
Adding a Data Flow Object to the Process Flow
Branching in the Process Flow
Submitting the Process Flow
Generating Reports, Viewing the Log File, and Printing Flows
DataMigrator Log, Statistics, and Summary Flow Reports
Scheduler Reports
Impact Analysis Reports on Synonyms, Procedures and Columns
Working With a Report
Viewing a Detailed Flow Report and Log File
Printing a Graphical Representation of a Data or Process Flow
Optimizing Performance
Improving Data Extraction Performance
Using Automatic Passthru
Improving Data Loading Performance
Improving Lookup Performance
Working With Synonyms
Synonym Editor Layout
Viewing and Editing Synonym Attributes
Using Variables in a Synonym
Variables Attribute Summary
How to Use a Variable in a Synonym
Creating, Enhancing, and Editing Synonyms Using Modeling View
Adding Indexes to a Synonym
Adding Virtual Columns (DEFINE) in a Synonym
Viewing Data Profiling Characteristics
Viewing Data Lineage for a Column
Advanced DataMigrator Tips and Techniques
Overview of Examples
Creating Sample Data and Metadata
Horizontal Partitioning with Multi-Table Load
Using the Decode Function
Generating a Surrogate Key
Generating a Surrogate Key Using Slowly Changing Dimensions
Mapping to a Sequential File of a Specific Format
Creating and Using Reusable Transformations
Using Multiple Targets to Create a Single File With Multiple Records Types
Creating a Target File With Multiple RECTYPEs
Combining Multiple Sources Rows in a Single Target Row
Using Lookups to Create Multi-Table Flows Without Joins
Record Logging
Using Variables in Data Flows
Creating a Data Flow Using a Target Based on a Predefined XML Schema
Loading a Target Table Using the File Listener
Sending a Target File to an FTP or SFTP Server
Loading a Star Schema
Iterating Through Multiple Tables
Using Subqueries
Loading Images Into a Database Table
Change Data Capture
Enabling the Database for Logging in Relational Databases
Enabling the Database for Logging in VSAM
Properties of a Table Log Record Synonym
Tutorial: Using Change Data Capture with Relational Databases
Tutorial: Using Change Data Capture With VSAM
DataMigrator Log Statistics and Tables
Log and Statistics Tables
Event-Based Scheduling
Starting Flows With CMRUN
Starting Flows With CMASAP
Starting Flows From FOCUS
Determining the Status of an Event-Based Flow
Problems, Errors, and Troubleshooting
DataMigrator Status Codes and Server Messages
Server Run-Time Error Codes
DataMigrator Management Problem Resolution
Including Run-Time Messages in the ETL Log
Performing a Trace to Diagnose Server Problems
Customizing Your Environment
DataMigrator Parameters
Source Management
Overview of Source Management
Source Control Security Server and Client Setup
Configuring Source Management and Setting Up Source Control
Using a Source Control System to Manage Procedures and Synonyms
Launch PDF
Functions Reference
Functions Overview
Function Arguments
Function Categories
Character Chart for ASCII and EBCDIC
Character Functions
ARGLEN: Measuring the Length of a String
ASIS: Distinguishing Between Space and Zero
BITSON: Determining If a Bit Is On or Off
BITVAL: Evaluating a Bit String as an Integer
BYTVAL: Translating a Character to Decimal
CHKFMT: Checking the Format of a String
CHKNUM: Checking a String for Numeric Format
CTRAN: Translating One Character to Another
CTRFLD: Centering a Character String
EDIT: Extracting or Adding Characters
GETTOK: Extracting a Substring (Token)
LCWORD: Converting a String to Mixed-Case
LCWORD2: Converting a String to Mixed-Case
LCWORD3: Converting a String to Mixed-Case
LJUST: Left-Justifying a String
LOCASE: Converting Text to Lowercase
OVRLAY: Overlaying a Character String
PARAG: Dividing Text Into Smaller Lines
PATTERN: Generating a Pattern From a String
POSIT: Finding the Beginning of a Substring
REVERSE: Reversing the Characters in a String
RJUST: Right-Justifying a Character String
SOUNDEX: Comparing Character Strings Phonetically
SPELLNM: Spelling Out a Dollar Amount
SQUEEZ: Reducing Multiple Spaces to a Single Space
STRIP: Removing a Character From a String
STRREP: Replacing Character Strings
SUBSTR: Extracting a Substring
TRIM: Removing Leading and Trailing Occurrences
UPCASE: Converting Text to Uppercase
XMLDECOD: Decoding XML-Encoded Characters
XMLENCOD: XML-Encoding Characters
Variable Length Character Functions
Overview
LENV: Returning the Length of an Alphanumeric Field
LOCASV: Creating a Variable Length Lowercase String
POSITV: Finding the Beginning of a Variable Length Substring
SUBSTV: Extracting a Variable Length Substring
TRIMV: Removing Characters From a String
UPCASV: Creating a Variable Length Uppercase String
Simplified Character Functions
CHAR_LENGTH: Returning the Length in Characters of a String
DIGITS: Converting a Number to a Character String
LOWER: Returning a String With All Letters Lowercase
LPAD: Left-Padding a Character String
LTRIM: Removing Blanks From the Left End of a String
POSITION: Returning the First Position of a Substring in a Source String
RPAD: Right-Padding a Character String
RTRIM: Removing Blanks From the Right End of a String
SUBSTRING: Extracting a Substring From a Source String
TOKEN: Extracting a Token From a String
TRIM_: Removing a Leading Character, Trailing Character, or Both From a String
UPPER: Returning a String With All Letters Uppercase
Character Functions for DBCS Code Pages
DCTRAN: Translating A Single-Byte or Double-Byte Character to Another
DEDIT: Extracting or Adding Characters
DSTRIP: Removing a Single-Byte or Double-Byte Character From a String
DSUBSTR: Extracting a Substring
JPTRANS: Converting Japanese Specific Characters
KKFCUT: Truncating a String
SFTDEL: Deleting the Shift Code From DBCS Data
SFTINS: Inserting the Shift Code Into DBCS Data
Data Source and Decoding Functions
DB_EXPR: Inserting an SQL Expression Into a Request
DB_INFILE: Testing Values Against a File or an SQL Subquery
DB_LOOKUP: Retrieving Data Source Values
DECODE: Decoding Values
FIND: Verifying the Existence of a Value in a Data Source
LAST: Retrieving the Preceding Value
LOOKUP: Retrieving a Value From a Cross-referenced Data Source
Date Functions
Overview of Date Functions
Using Standard Date Functions
DATEADD: Adding or Subtracting a Date Unit to or From a Date
DATECVT: Converting the Format of a Date
DATEDIF: Finding the Difference Between Two Dates
DATEMOV: Moving a Date to a Significant Point
DATETRAN: Formatting Dates in International Formats
FIYR: Obtaining the Financial Year
FIQTR: Obtaining the Financial Quarter
FIYYQ: Converting a Calendar Date to a Financial Date
TODAY: Returning the Current Date
Using Legacy Date Functions
AYM: Adding or Subtracting Months
AYMD: Adding or Subtracting Days
CHGDAT: Changing How a Date String Displays
DA Functions: Converting a Legacy Date to an Integer
DMY, MDY, YMD: Calculating the Difference Between Two Dates
DOWK and DOWKL: Finding the Day of the Week
DT Functions: Converting an Integer to a Date
GREGDT: Converting From Julian to Gregorian Format
JULDAT: Converting From Gregorian to Julian Format
YM: Calculating Elapsed Months
Date-Time Functions
Using Date-Time Functions
HADD: Incrementing a Date-Time Value
HCNVRT: Converting a Date-Time Value to Alphanumeric Format
HDATE: Converting the Date Portion of a Date-Time Value to a Date Format
HDIFF: Finding the Number of Units Between Two Date-Time Values
HDTTM: Converting a Date Value to a Date-Time Value
HGETC: Storing the Current Date and Time in a Date-Time Field
HGETZ: Storing the Current Coordinated Universal Time in a Date-Time Field
HHMMSS: Retrieving the Current Time
HHMS: Converting a Date-Time Value to a Time Value
HINPUT: Converting an Alphanumeric String to a Date-Time Value
HMIDNT: Setting the Time Portion of a Date-Time Value to Midnight
HNAME: Retrieving a Date-Time Component in Alphanumeric Format
HPART: Retrieving a Date-Time Component as a Numeric Value
HSETPT: Inserting a Component Into a Date-Time Value
HTIME: Converting the Time Portion of a Date-Time Value to a Number
HTMTOTS: Converting a Time to a Timestamp
HYYWD: Returning the Year and Week Number From a Date-Time Value
Simplified Date and Date-Time Functions
DTADD: Incrementing a Date or Date-Time Component
DTDIFF: Returning the Number of Component Boundaries Between Date or Date-Time Values
DTPART: Returning a Date or Date-Time Component in Integer Format
DTRUNC: Returning the Start of a Date Period for a Given Date
Format Conversion Functions
ATODBL: Converting an Alphanumeric String to Double-Precision Format
EDIT: Converting the Format of a Field
FPRINT: Converting Fields to Alphanumeric Format
FTOA: Converting a Number to Alphanumeric Format
HEXBYT: Converting a Decimal Integer to a Character
ITONUM: Converting a Large Number to Double-Precision Format
ITOPACK: Converting a Large Binary Integer to Packed-Decimal Format
ITOZ: Converting a Number to Zoned Format
PCKOUT: Writing a Packed Number of Variable Length
PTOA: Converting a Packed-Decimal Number to Alphanumeric Format
TSTOPACK: Converting an MSSQL or Sybase Timestamp Column to Packed Decimal
UFMT: Converting an Alphanumeric String to Hexadecimal
XTPACK: Writing a Packed Number With Up to 31 Significant Digits to an Output File
Numeric Functions
ABS: Calculating Absolute Value
CHKPCK: Validating a Packed Field
DMOD, FMOD, and IMOD: Calculating the Remainder From a Division
EXP: Raising e to the Nth Power
EXPN: Evaluating a Number in Scientific Notation
INT: Finding the Greatest Integer
LOG: Calculating the Natural Logarithm
MAX and MIN: Finding the Maximum or Minimum Value
NORMSDST and NORMSINV: Calculating Normal Distributions
PRDNOR and PRDUNI: Generating Reproducible Random Numbers
RDNORM and RDUNIF: Generating Random Numbers
SQRT: Calculating the Square Root
System Functions
CLSDDREC: Closing All Files Opened by the PUTDDREC Function
FEXERR: Retrieving an Error Message
FGETENV: Retrieving the Value of an Environment Variable
FPUTENV: Assigning a Value to an Environment Variable
GETUSER: Retrieving a User ID
JOBNAME: Retrieving the Current Process Identification String
PUTDDREC: Writing a Character String as a Record in a Sequential File
SLEEP: Suspending Execution for a Given Number of Seconds
SYSVAR: Retrieving the Value of a z/OS System Variable
SQL Character Functions
CHAR_LENGTH: Finding the Length of a Character String
CONCAT: Concatenating Two Character Strings
DIGITS: Converting a Numeric Value to a Character String
EDIT: Editing a Value According to a Format (SQL)
LCASE: Converting a Character String to Lowercase
LTRIM: Removing Leading Spaces
POSITION: Finding the Position of a Substring
RTRIM: Removing Trailing Spaces
SUBSTR: Extracting a Substring From a String Value (SQL)
TRIM: Removing Leading or Trailing Characters (SQL)
UCASE: Converting a Character String to Uppercase
VARGRAPHIC: Converting to Double-byte Character Data
SQL Date and Time Functions
CURRENT_DATE: Obtaining the Date
CURRENT_TIME: Obtaining the Time
CURRENT_TIMESTAMP: Obtaining the Timestamp (Date/Time)
DAY: Obtaining the Day of the Month From a Date/Timestamp
DAYS: Obtaining the Number of Days Since January 1, 0001
EXTRACT: Obtaining a Datetime Field From Date/Time/Timestamp
HOUR: Obtaining the Hour From Time/Timestamp
MICROSECOND: Obtaining Microseconds From Time/Timestamp
MILLISECOND: Obtaining Milliseconds From Time/Timestamp
MINUTE: Obtaining the Minute From Time/Timestamp
MONTH: Obtaining the Month From Date/Timestamp
SECOND: Obtaining the Second Field From Time/Timestamp
QUARTER: Returning the Quarter of the Year
WEEKDAY: Returning the Day of the Week
YEAR: Obtaining the Year From a Date or Timestamp
SQL Data Type Conversion Functions
CAST: Converting to a Specific Data Type
CHAR: Converting to a Character String
CHAR: Converting to a Standard Date-Time Format
DATE: Converting to a Date
DECIMAL: Converting to Decimal Format
FLOAT: Converting to Floating Point Format
INT: Converting to an Integer
SMALLINT: Converting to a Small Integer
TIME: Converting to a Time
TIMESTAMP: Converting to a Timestamp
SQL Numeric Functions
ABS: Returning an Absolute Value (SQL)
LOG: Returning a Logarithm (SQL)
EXP: Returning e Raised to a Power
POWER: Raising a Value to a Power
SQRT: Returning a Square Root (SQL)
SQL Miscellaneous Functions
COUNTBY: Incrementing Column Values Row by Row
HEX: Converting to Hexadecimal
IF: Testing a Condition
LENGTH: Obtaining the Physical Length of a Data Item
VALUE: Coalescing Data Values
SQL Operators
CASE: SQL Case Operator
COALESCE: Coalescing Data Values
NULLIF: NULLIF Operator
Launch PDF
Service Manager
Getting Started
nHTTP Representational State Transfer Getting Started
Introducing nHTTP Representational State Transfer
Representational State Transfer (REST)
nHTTP REST Support
Configuration Overview
Configuring a Process Flow and nHTTP Channel
Configuring a Process Flow
Configuring an nHTTP Channel
Running a REST Style Service
Launch PDF
Non-blocking AS2 (NAS2) Getting Started Guide
Introducing Non-blocking AS2 (NAS2)
NAS2 Overview
Providers Overview
Namespaces Overview
Configuring Providers
Prerequisites
Importing Packages
Configuring NAS2 Channels
Importing Archives
Sender (iWay) Channel Overview
Receiver (Partner) Channel Overview
Testing and Viewing Results
Reviewing Registered Namespaces Within the Output Files
Launch PDF
Documentation
Installation and Configuration
iWay 7.0.7 Service Manager Installation Overview
iWay 7.0.7 Service Manager Products and Components
Installation and Configuration Overview
Installing iWay 7.0.7 Service Manager Components
Installation Requirements
Installing iWay 7.0.7 Service Manager
Installing iWay 7.0.7 Service Manager With iWay 5.x or 6.x Service Manager
Post-Installation Topics and Tasks
Registering iWay Software
Configuration Steps
Preparing Adapters
Preparing Adapters
Configuring iWay Components
Configuring and Verifying iWay Service Manager
Configuring iWay Application Server Components
Configuring iWay Explorer
Configuring iWay Explorer
Configuring Eclipse iWay Explorer
Configuring the iWay Repository
Configuring and Creating the Repository
Migrating Repositories
Launch PDF
User's Guide
Introducing iWay Service Manager
iWay Service Manager Functions
Understanding iWay Channels
Document Life Cycle
Understanding iWay Service Manager Thread Management
Introducing the iWay Service Manager Administration Console
Console Home Window
iWay Service Manager Help Window
iWay Service Manager Welcome Window
Internationalization
Encoding
Displaying License Information
Installation Verification Procedure
Accessing the iWay Service Manager Administration Console
Building and Deploying the File1 Channel
Testing iWay Service Manager
Configuring Basic Properties
Configuring Properties
Configuring Properties as Constant Values
Obtaining Configuration Properties From the File System
Obtaining Configuration Properties Using LDAP
Obtaining Configuration Properties Using XPath
Obtaining Configuration Properties Using Special Registers
Using Registers, Register Sets, and Parameters
Managing Configurations
Introducing iWay Service Manager Configurations
Creating a Configuration
Working With Configurations
Stopping a Service
Removing a Service and Configuration
Adding a User
Managing Configurations in Batch
Configuring General Properties Using the Console
Settings
Providers
Facilities
Configuring iWay Registry Components
Understanding the iWay Registry
Adding an Adapter
Decryptor
Adding an Ebix
Adding an Emitter
Encryptors
Adding a Listener
Adding a Preemitter
Adding a Preparser
Adding a Reviewer
Adding a Rule
Adding a Schema
Adding a Service
Viewing a Defined Transform
Defining a Process
Defining a Transformer
Using the Recycle Bin
Configuring Channels
Defining an Inlet
Defining a Route
Defining an Outlet
Constructing a Channel
Specifying Fixed or Dynamic Routing
Adding Register Sets
Adding Ebix Components
Building a Channel
Using iWay Service Manager Tools
Using the Log Viewer
Using the Package Manager
Using the Archive Manager
Using the Deployment Manager
Using the Enterprise Index Application
Operations and Monitoring
Understanding iWay Service Manager Restart Methods
Using iWay Service Manager Startup Command Line Switches
Starting and Stopping iWay Service Manager on Windows
Starting and Stopping Service Manager on UNIX, OS/400, and z/OS
Class Path and Service Manager Restart Issues
Understanding and Using the IWSRV Executable Program
Event Process Flows
Startup Process Flow
Closedown Process Flow
SNMP Provider
iWay Service Manager Failover
Channel Management
Service Management
Testing Web Services
Using the iWay Service Manager System Tray Application on Windows
Using the Telnet Management Connection
Overview
Configuring the Telnet Listener
Using the Telnet Management Connection
Diagnostics, Tracing, and Logging
Running in a Command Shell
Diagnostic Commands
Troubleshooting on Windows
Performing Diagnostic Functions
Measurements and Statistics
Using JConsole to Monitor iWay Service Manager
Testing Functions
Testing XPATH
Using Debug Nodes
Using the Log Viewer
Creating a Diagnostic Zip
Special Registers (SREGs)
Global SREGs
Transform SREGs
Process Flow SREGs
Running iWay Service Manager Under YARN Using Slider
Overview
Creating an iWay Service Manager Slider Package
Installing, Deploying, and Running iWay Service Manager With Slider
Sample Application Deployment
Launch PDF
Command Reference Guide
Introduction
iWay Service Manager Command Environment
Using Command Help
Managing Command Security
Creating and Using a Remote Command Console
Overview
Creating a Remote Command Console
Connecting to a Remote Command Console
Using the Scheduler
Using the iWay Service Manager Command Line Console
Command Line Schedule Examples
iWay Service Manager Commands Reference
Available iSM Commands
Calendar
Cron
Copy
Diagzip
Enqueue
Errors
Flow
GC
Help
Hidelog and Showlog
Info
Jdbc
Line
Package
Pull
Quit
Refresh
Remote
Run
Say
Schedule
Script
Set
Shell
Show
Sleep
Spool
Start
Stats
Stop
Time
Tool
Type
User Commands
Launch PDF
Component Reference Guide
iWay Services
Overview
Available Services
Parallel Control Services
iWay Preparsers
Overview
Available Preparsers
Streaming Preparsers
Splitter Preparsers
iWay Preemitters
Overview
Available Preemitters
PGPEncrypt Preemitter (com.ibi.preemit.PGPEncrypt)
Deflate (com.ibi.preemit.XDDeflate)
EDIX12 Preemitter (com.ibi.preemit.XDX12PreEmitter)
HIPAA Preemitter (com.ibi.preemit.XDHIPAAPreEmitter)
SWIFT Preemitter (com.ibi.preemit.SwiftPreEmitter)
XDSWIFT Preemitter (com.ibi.preemit.XDSwiftpreEmitter)
XDEDIFACT Preemitter (com.ibi.preemit.XDEDIFACTPreEmitter)
Entity Repl Preemitter (com.ibi.preemit.XDEntityRepl)
Constant PE (com.ibi.preemit.XDConstantPE)
Flat Delim Preemitter (com.ibi.preemit.XDFlatDelimPreEmitter)
Remove Outer Tag (com.ibi.preemit.XDDeTag)
Replaced Paired Characters (com.ibi.preemit.XDCharRepl)
Legacy Record Preemitter (com.ibi.preemit.LegacyRecordPreemitter)
Multi Part (com.ibi.preemit.XDMultiPart)
QA Print (com.ibi.preemit.XDQAPrint)
XSL Tpre (com.ibi.preemit.XDXSLTpreEmitter)
iWay Transformations Preemitter (com.ibi.preemit.XDXMLGpreEmitter)
iWay Iterators
Understanding Iterators
Iterator Parameters
Available Iterators
Iterator Example
Additional SQL Service Reference Information
SQL Service Edge Returns Sorted by XOPEN Code
Transaction Isolation Terminology
Apache Avro Components
Installation
Avro File Read Service
Avro File Emit Service
Avro File Iterator Service
Avro File Listener
Avro RPC HTTP Emit Service
Avro RPC Over HTTP Listener
Launch PDF
Functional Language Reference Guide
iWay Functions
Overview
Environmental Functions
Document Functions
String Functions
Time Service Functions
Math Functions
Decimal Math Functions
Encoding Functions
File Functions
System Information Functions
Security Functions
Other Functions
Arithmetic Expressions
Function Syntax and Return Values
IWXPATH Language Support
Launch PDF
Programmer's Guide
Programming Your Applications in iWay Service Manager
Overall Guidelines
Overview of the Adapter Process
Document Life Cycle
Developing For Your Own Needs
Protocol Components
Encoding
Routing
Terminology
Process Flows
Writing Business Components
Getting Started With Business Components
Programming Exit Components for iWay Service Manager
Common Methods
Configuration Parameters
Other Metadata Methods
The Executable Portion of an Exit
Status Documents
Business Agents Running in Transactions
Preparsers
Reviewers
Preemitters
Building the Exit
Writing Iterators
Writing Management Components
Getting Started With Management Components
Activity Log Writer
Activity Driver
XDSQLWriter Activity Driver
Trading Partner Agreement
Correlation Manager
Writing iWay Function Language (IFL)
Service Providers
Writing Protocol Components
Protocol Components
Programming Standards, General Rules of the Road
Build Environment
MasterInfo Class
Installing Components
Writing an iWay Service Manager Emitter
Writing an iWay Service Manager Listener
Writing an Extension Command
Running a Process Flow
Programming Objects
XDDocument
XDNode
XDNode and XDDom
XDOrgData
XDSpecReg
XDExitBase
iWay API Reference
Tracing
Special Registers
Pooling
Getting Server Information
QA Mode
Evaluating Expressions
Exit Attributes
Storing Objects
Service Functions
Creating Files With Unique Names
Safe Store Facility
Converting Between JDOM and XD Trees
Multithread Considerations
iWay Service Manager Rules System
Rules File
General Rule Set
Writing Rules in Java
Writing Rule Search Routines in Java
Building iWay Service Manager Components
Overview
Understanding the Registration Class
Sample ANT Build Script
Standard Business Exits
Business Exits Terminology
Business Agents
Protocol Business Agents
Preparsers
Splitter Preparsers
Preemitters
Reviewers
Supplied Tools
CreateMultipart
FromWhere
Signing Configuration Files
Testing Functions
Testing xpath
Debugging Tools
Tracing
Running in a Command Shell
Quality Assurance Mode
Gathering Support Information
Measuring Performance
Overview
Built-in Statistics
Memory Command
Threads Command
Deadlock Detector
Statistics
Using iFL to Measure Multiple Node Duration
Activity Log Timer
iWay Functional Language
The Rules
Creating Application Consoles for iWay Service Manager
Application Console Overview
Basic Techniques
Sample Application Console (Red Console)
Glossary
Launch PDF
Security Guide
Introducing Security
Confidentiality
Integrity
Authentication
Security in iWay Service Manager
Introducing Security Components
Areas of Responsibility
Message Acquisition and Disposition
Rejection of Spurious Messages
Secure Multi-Purpose Internet Mail Extension (S/MIME)
XML Digital Signature
Authentication and Authorization
Using Policies
Password Masking
Security Related iFL Functions
Restricted XPath Expressions
Security Providers
Keystore Provider
Directory CertStore Provider
SSL Context Provider
LDAP Certstore Provider
OCSP Responder Provider
Configuring Runtime Security Using Access Control
Overview
Logon Schemes
Configuring Credential Requirements
Realm Based Authentication
Role Based Authentication
Impersonation
Realm-based Security in the iSM Administration Console
Overview
Creating or Editing a Role in the Management Section of the Console
Configuring Authentication for a Base Configuration Using a Properties File Realm
Security Services
OAuth 1.0 Authentication Service
OAuth 2.0 Authentication Service
Insert WSSE Timestamp Service
Insert WSSE Token Service
Insert SAML Assertion Service
XML Digital Signature Create Service
XML Digital Signature Verify Service
XAdES Digital Signature Create Service
XAdES Digital Signature Verify Service
Authenticate/Impersonate Service
Security Tools
Overview
Signing Files
Keeping Values Secret
nCipher Configuration
Provider Initialization (Validating Signatures)
Java Configuration
Softcard for nCipher
Key Creation Using Keytool
Cryptography Provider
Troubleshooting (PKCS11 RSA Private Key Exception)
Authenticating an HTTP Client Using Kerberos
Overview
Kerberos Authentication
Sample Kerberos Configuration File
Sample JAAS Configuration File
Troubleshooting
WSO2 Identity Server Support
Introduction
Installing and Configuring WSO2 Identity Server
Configuring iWay Service Manager
Developer Notes
Launch PDF
Extensions User's Guide
Introducing iWay Service Manager Extensions
About iWay Service Manager Extensions
iWay RVI Proxy Extension
Overview
iWay PGP Extension
Overview
Installing and Configuring the iWay PGP Extension
Configuring a PGP Preemitter for Encryption
Configuring a PGP Preparser for Decryption
Testing Document Encryption and Decryption
Using the PGPEncrypt Service
Signing and Encrypting a Message Using Key Pair Encryption
Configuring ASCII Message Armoring
JCE Reference
iWay Telnet Extension
Overview
Installing and Configuring the iWay Telnet Extension
Configuring the Telnet Listener
Testing a Telnet Listener Channel
Connecting to iWay Service Manager Using a Telnet Client
Supported Commands
Telnet Scripting Example
iWay Security Extension
Overview
Installing the iWay Security Extension
Security Extensions - XDDevKit
iWay Compatibility Extension
Overview
Installing the iWay Compatibility Extension
iWay Scheduler Extension
Installing the iWay Scheduler Extension
Configuring the iWay Service Manager Scheduler
Using iWay Service Manager Command Line Console
Command Line Schedule Examples
iWay Migration Extension
Overview
Installing the iWay Migration Extension
iWay Real Time Data Replication Extension
Overview
Adding Data Integration Object Support for Process Flows
Creating a Connection Using the Data Source Explorer
Configuring a Data Integration Object
Looping
Connection Options
Sample Documents
Tips and Tricks
Launch PDF
Protocol Guide
iWay Protocol Adapters
Protocols Supported in iWay Service Manager
Configuring Channels
Defining an Inlet
Configuring Listeners
Defining a Route
Defining an Outlet
Configuring Emitters
Constructing a Channel
Building a Channel
Registering Library Files and Setting JVM Options
Configuring Local Transaction Management
e-Business Protocol Adapters
AS1 and AS2 Standards
Non-Blocking AS2 Adapter
Application Protocol Adapters
iWay Adapter for EDAAPI
iWay Adapter for RDBMS
iWay Application Adapter for MySAP
Schedule Listener
iWay Application Protocol Adapter for LDAP
iWay Hot Backup Listener
iWay LDAP High Water Mark Listener
iWay Relational Database High Water Mark Listener
iWay Application Adapter for Salesforce
iWay Enterprise Index
iWay Log Event Adapter for Oracle
Transport Utility Protocol Adapters
Email
File
FTP
SFTP
FTP Server
HTTP
nHTTP
SOAP
TCP
UDP
iWay Command Extension
iWay RVI Proxy Extension
Queuing Protocol Adapters
Introducing Queuing Protocol Adapters
JMSQ
MSMQ
Oracle Advanced Queuing
Sonic Message Queuing
TIBCO Rendezvous
RabbitMQ
WebSphere MQ and MQJMS
Internal and Ordered Queue Processing
Configuring Basic Properties
Configuring Properties
Configuring Properties as Constant Values
Obtaining Configuration Properties From the File System
Obtaining Configuration Properties Using LDAP
Obtaining Configuration Properties Using XPath
Obtaining Configuration Properties Using Special Registers
Using Registers, Register Sets, and Parameters
HTTP Headers and Special Registers
History
Issue to be Addressed
Special Registers and HTTP
Launch PDF
Flow Debugger User's Guide
Introducing the Flow Debugger
Introducing the Flow Debugger
Debugger Concepts
Flow Debugger Operations
Performing Basic Operations in Unit Testing Mode
Using Flow Debugger in Configuration Testing Mode
Tips and Usage Considerations
Documents
Sub-flows
Event Flows
Testing a Portion of the Flow
Development Cycle
Messages
Flow Debugger Reference
Debugger Tool
Syntax
Commands
iSM Architecture Considerations for Flow Debugger
iSM Architecture Considerations for Flow Debugger
Launch PDF
FTP Solutions Development Guide
Introducing iWay FTP Services (Adapters)
Overview
Understanding Differences Between FTP and SFTP
iWay Service Manager Suite of FTP Tools
Available Listeners Reference
Available Emitters Reference
Available Services Reference
Configuring FTP and FTPS Components
Overview
Configuring a FTP Listener
Configuring a FTP Emitter
Configuring a FTP Read Document Service
Configuring a FTP File Emit Service
Configuring a FTP File Operations for Process Flows Service
Configuring a FTP Direct Transfer to Disk Service
Configuring a FTP Connection Cache Service
Configuring a FTP Directory Contents Service
Configuring a FTP File Read for Process Flows Service
Configuring Secure FTP (SFTP) Components
Overview
Configuring a SFTP Listener
Configuring a SFTP Emitter
Configuring a SFTP Read Service
Configuring a SFTP Directory Contents Service
Configuring a SFTP Direct Transfer Service
Configuring a SFTP Connection Cache Service
Configuring a SFTP Emit Service
Configuring a SFTP File Ops Service
Configuring OpenSSH on Windows
Converting a Private Key to the OpenSSH Key Format
Configuring FTP Server Components
Overview
Configuring a FTP Server Listener
FTP Commands
Security Considerations
Using the Trading Partner Management Facility
Configuring a FTP SREG Service
Configuring Secure FTP (SFTP) Server Components
Overview
Configuring a SFTP Listener
Configuring the SSH Server Security Provider
Common Configuration Parameters
Listener Configuration Parameters
Configuring iWay Service Manager Components
Configuring Listeners
Configuring Services
Launch PDF
HTTP Solutions Guide
Introducing iWay HTTP Solutions
Overview
What is HTTP?
iWay Service Manager Suite of HTTP Tools
Table of HTTP Listeners
Table of HTTP Emitters
Table of HTTP Services
Table of HTTP Preparsers
Configuring HTTP Components
HTTP
nHTTP
Sonic Message Queuing
Configuring iWay HTTP Services (Adapters)
Overview
HTTP Services
Configuring HTTP Preparsers
Overview
HTTP Preparser (com.ibi.preparsers.XDHTTPpreParser)
Multipart for nHTTP Preparser (com.ibi.preparsers.XDMultiPartForNHTTP)
Configuring HTTP Headers and Special Registers
History
Issue to be Addressed
Special Registers and HTTP
Configuring Common Parameters
Listener Configuration Parameters
Configuring iWay Service Manager Components
Configuring Listeners
Configuring Services
Launch PDF
Cross-Channel Services Guide
Introducing iWay Service Manager Cross-Channel Services
Overview
Available Listeners Reference
Available Services Reference
Internal Queue Processing
Overview
Configuring an Internal Queue Listener
Configuring an Internal Emit Service
Ordered Queue Processing
Overview
Introducing the Ordered Queue Facility
Configuring an Ordered Queue Listener
Configuring an Ordered Emit Service
Reverse Invocation Queue Processing
Overview
Configuring the RVIAttach Listener
Configuring the RVI Relay Service
Configuring the RVIGateway Listener
Configuring a Service to Test the Reverse Invocation
Asynchronous Forward Transfer Invocation Queue Processing
Overview
Configuring a Marshall Service
Configuring an Unmarshall Service
Configuring iWay Service Manager Components
Configuring Listeners
Configuring Services
Common Configuration Parameters
Listener Configuration Parameters
Service Configuration Parameters
Deploying iWay in a High Availability Environment
Overview
Failover
Scaling and Load Balancing
Implementing High Availability
IP-based Horizontal Scaling
Web-based Horizontal Scaling Using iWay Performance Monitor
iWay Reverse Invocation Proxy and High Availability
Launch PDF
Business Activity Monitor User's Guide
Introducing iWay Business Activity Monitor
iWay Business Activity Monitor (BAM) Architecture
Installing iWay Business Activity Monitor
Installation Prerequisites
Installing iWay Business Activity Monitor
Configuring iWay Business Activity Monitor
Configuring the iWay Business Activity Monitor Web Application
Configuring and Using iWay Business Activity Monitor
Accessing the iWay Business Activity Monitor Console
Activity Management Tab
Administration Tab
Correlation Management Tab
BAM Driver Recovery
Using BAM Commands
Structure of the iWay Business Activity Monitor Database
BAM_ACTIVITY Table
BAM_ACTIVITY_CONTEXT Table
BAM_ACTIVITY_EXTENDED Table
Configuring User Authentication for iWay Business Activity Monitor
Overview
Creating an LDAP Directory Provider
Creating an LDAP Authentication Realm
Mapping LDAP Roles to iWay BAM Roles
Enabling iWay BAM Authentication Through an Authentication Realm
Launch PDF
Trading Partner Manager User's Guide
Introducing iWay Trading Partner Manager
About iWay Trading Partner Manager
iWay Trading Partner Manager Architecture
Installing iWay Trading Partner Manager
Prerequisites
Installing iWay Trading Partner Manager
Configuring and Using iWay Trading Partner Manager
Using the iWay Trading Partner Manager Web Console
Using Runtime Functions
iWay Trading Partner Manager Runtime Functions
JSON API Reference
Overview
Retrieving a Partner List
Retrieving a Partner System List
Retrieving a Partner Contact List
Creating a Partner
Deleting a Partner
Retrieving a Partner System
Adding MetaData
Adding MetaData Values
Adding a Partner Contact
Adding an Environment
Deleting an Environment
Retrieving an Environment
Adding a System
Adding a Partner System
Adding a Partner Certificate
Security
Recommended Practices
Debugging JSON
Launch PDF
Pretty Good Privacy (PGP) Extension User’s Guide
Introducing Pretty Good Privacy (PGP)
Overview
Cryptographic Services
Key Management
Supported Components
Configuring iWay Service Manager Components
Configuring the iWay Pretty Good Privacy (PGP) Extension
Configuring Bouncy Castle
Configuring Pretty Good Privacy (PGP)
Configuring the Java Runtime Environment
Configuring iSM Components for the iWay Pretty Good Privacy (PGP) Extension
Launch PDF
XML Archive User's Guide
Installing the iWay XML Archive
Installation Requirements
Installing iWay Service Manager
Installing mongoDB
Configuring the iWay XML Archive Application
Verifying the Installation
Using the iWay XML Archive
Architecture
XML and JSON
Loading Documents
Making Requests
The Query String
Query Grammar
Understanding the JSON Results
Returning XML Documents
Returning a Slice of XML With XQuery
Using the iWay XML Archive Test Client
Test Client Overview
Query Grammar in the Test Client
Launch PDF
Best Practices
Configuration and Usage Best Practices for iWay Service Manager
Ensuring Channels are Not Deployed to the iSM Base Configuration
Understanding the Base Configuration
Understanding the SOAP1 Listener
Adding an Error-to Agent to the SOAP1 Listener
Adding an Error-to Agent to the SOAP1 Listener
Using iWay Business Activity Monitor (BAM)
Overview
Best Practices
General Considerations Related to iWay BAM Performance
Using iWay Integration Applications (iIAs)
Overview
Best Practices
Configuring the Heap (Memory) Size
Overview
Setting the iSM Service Initial Heap Size
Benefits of Multiple Cores
Overview
Determining Core Usage on Windows Platforms
Determining Core Usage on Linux Platforms
Creating and Using a Remote Command Console
Overview
Creating a Remote Command Console
Connecting to a Remote Command Console
Using Event and Startup Process Flows
Event Process Flows
Startup Process Flow
Launch PDF
Troubleshooting and Debugging Best Practices for iWay Service Manager
Defining Troubleshooting and Debugging Strategies
Overview
Using iWay Service Manager Diagnostics, Tracing, and Logging Facilities
Running in a Command Shell
Diagnostic Commands
Troubleshooting on Windows
Performing Diagnostic Functions
Measurements and Statistics
Using the Log Viewer
Creating a Diagnostic Zip
Identifying Available Services for Troubleshooting and Debugging
Activity Log Entry Service (com.ibi.agents.XDXALogEvent)
Catch Service (com.bi.agents.XDCatchAgent)
Fail Service (com.ibi.agents.XDFailAgent)
QA Service (com.ibi.agents.XDQAAgent)
Trace Message Writer Service (com.ibi.agents.XDTraceAgent)
Identifying Available Commands and Functions for Troubleshooting and Debugging
Using the Testfuncs Tool
Using the Testxpath Tool
Using the Flow Command
Using the Line Command
Using the _eval() Function
Creating and Using a Remote Command Console
Overview
Creating a Remote Command Console
Connecting to a Remote Command Console
Using Event and Startup Process Flows
Event Process Flows
Startup Process Flow
Recommended Third-Party Tools for Troubleshooting and Debugging
JConsole
JVM Startup Options
SoapUI
KeyTool IUI
Operating System Commands
Wireshark
Tcpdump
Launch PDF
Integration Tools
Documentation
iWay Integration Tools User's Guide
Getting Started
Installing and Starting iIT
Configuring and Using iWay Integration Tools Suite
Concepts
Integration Perspective
Integration Explorer
Integration Projects
iWay Resources
Target Server Version
Customizations
Registry Explorer
Adapters
Schemas in Integration Projects
Register Sets
iWay Home Directory
Running iSM in iIT
Channel Editor
Library Manager
Tasks
Working With Integration Projects
Setting iWay Home Preferences
Setting a Default Target Server Version
Configuring Disposable Test Servers for Test Run Integration
Working With iWay Resources
Configuring and Using Schema Sets
Configuring and Using the Script Object
Importing iWay Archive Packages
Accessing iWay Service Manager Components in iWay Integration Tools
Launch PDF
iWay Integration Tools Designer User's Guide
Concepts
Introducing iIT Designer
The iIT Designer Environment
Defining Process Flow Objects
Tasks
Creating a Project
Managing Process Flows
Adding an Adapter to iIT Designer
Using Variables and XPath
Adding an Object to a Process Flow from an iSM Registry
Working with Customizations
Tutorial
An Example Process Flow
Process Flow Object Properties
Iterator Object Properties
SQL Object Properties
Launch PDF
iWay Integration Tools Transformer User's Guide
iWay Transformer Overview
About iWay Transformer
Getting Started With iWay Transformer
iWay Transformer Basic Tutorial
Project Configuration Tutorial
Dictionary Builder Tutorial
iWay Transformer Concepts
Transformation Process
iWay Transformer Mappings
iWay Transformer Supported Data Formats
Transform Component Dependencies
Using Namespaces in iWay Transformer
Transform Functions
Invisible Group
iWay Transformer Tasks
Creating a Transform Component
Configuring a Transform Component
Testing a Transform Component
Working With a Transform Component
Working With the Mapping Builder
Working With Namespaces
Working With Functions
iWay Transformer Tips and Tricks
XSLT Runtime Processing
Launch PDF
iWay Integration Application User's Guide
Getting Started
Basic iWay Integration Application Tutorial
Scripting Tutorial
Concepts
Contents
Tasks
Working With Applications
Working With Application Sources
Working With Ant Scripts
Working With Templates
Working With Admin Servers
Working With Remote Servers and Auto Updates
Reference
User Interface Information
Tips and Tricks
Introduction
Creating an iWay Integration Application
Creating Configuration Templates
Scripted Deployment
Launch PDF
Source Management (Version Control) Installation and Configuration Guide
Installing and Configuring a Source Management (Version Control) Repository for iWay Integration Tools
int_tools/source Management Overview
Installing Apache Subversion
Understanding the Physical Structure of Components in an Integration Project
Configuring and Working With Apache Subversion
Common Commands Used With Apache Subversion
Handling Conflict States
SVN Best Practices
Launch PDF
Software Development Kit
Documentation
iWay Software Development Kit User's Guide
Installing the iWay Software Development Kit
Overview
System Requirements
Installing the iWay SDK
Folder Structure
Getting Started With the iWay Software Development Kit
Understanding Apache Ant Tasks
Using Sample Integration Tasks
Creating Web Archives (WAR) Files
Using the iWay SDK
Launch PDF
Application Adapters
Documentation
Application Adapter for MUMPS User's Guide
Introducing the iWay Application Adapter for MUMPS
MUMPS Overview
Features of the iWay Application Adapter for MUMPS
Component Information for the iWay Application Adapter for MUMPS
Supported Platforms Matrix
Overview
Supported Versions
Operating Systems
Databases
Java Development Kit (JDK)
Communication Modes
Object Types and Interfaces
Communication Types
Operations
Data Types
Other Functions
Known Limitations
Related Information for Specific iWay Releases
Installing the iWay Application Adapter for MUMPS
Prerequisites
Installing the Server Component for the Adapter
Installing iWay Service Manager
Creating the Sample
MUMPS Adapter Services
RPCS Invocation
RPCD Invocation
Simple Query
Schema-Based Queries
Launch PDF
Application Adapter for Oracle E-Business Suite User's Guide
Introducing the iWay Application Adapter for Oracle E-Business Suite
Features of the iWay Application Adapter for Oracle E-Business Suite
Integration with Oracle E-Business Suite
Using the Adapter with Oracle APIs
iWay Oracle Wrapper Architecture
Component Architecture
Limitations and Best Practices
Integration Using OAGIS XML and EDI Documents
Deployment Information for Your iWay Adapter
Information Roadmap
Supported Platforms Matrix
Overview
Supported Versions
Operating Systems
Databases
Java Development Kit (JDK)
Communication Modes
Object Types and Interfaces
Communication Types
Operations
Data Types
Other Functions
Known Limitations
Related Information for Specific iWay Releases
Quick Start Guide
Overview
Quick Start Guide
Installing the iWay Oracle API Wrapper
Prerequisites
Installing the iWay Oracle Wrapper
Configuring and Managing Connections to Oracle E-Business Suite
Overview
Starting iWay Explorer
Creating a New Configuration
Connecting to a New Configuration
Connecting to Oracle E-Business Suite
Integrating With Oracle Interface Tables and Concurrent Programs
Browsing Interface Table Metadata
Generating XML Schemas for Interface Tables
Creating iWay Business Services for Interface Tables
Running a Submit Request
Integrating With Oracle APIs
Browsing Oracle API Metadata
Generating XML Schemas for Oracle APIs
Creating iWay Business Services for Oracle APIs
Integrating With Oracle Base Tables
Browsing Base Table Metadata
Generating XML Schemas for Base Tables
Creating iWay Business Services for Base Tables
Creating Prepared Statements and Batch Statements
Overview
Creating and Testing a Regular SQL Statement
Creating and Testing a Parameterized SQL Statement
Creating a Batch Statement and an Iterative Process
Listening for Oracle E-Business Suite Events
Understanding iWay Event Functionality
Creating an Event Port
Creating a Channel
Choosing a Listening Technique
Troubleshooting and Error Messages
Troubleshooting
iWay Business Services Provider Error Messages
Configuring the Adapter in an iWay Environment
Configuring the Adapter in iWay Service Manager
Configuring the Adapter in iWay Integration Tools Designer
Using the Adapter in iWay Integration Tools Designer
Supported Interface Tables for Oracle Release Apps 11i
Supported Interface Tables
Sample WSDL File
Sample WSDL File
Launch PDF
Application Adapter for PeopleSoft User's Guide
Introducing the iWay Application Adapter for PeopleSoft
Key Features of the iWay Application Adapter for PeopleSoft
How the iWay Application Adapter for PeopleSoft Works
Component Information
Supported Platforms Matrix
Overview
PeopleTools
Operating Systems
Databases
Java Development Kit (JDK)
Communication Modes
Object Types and Interfaces
Communication Types
Operations
Data Types
Other Functions
Known Limitations
Related Information for Specific iWay Releases
Quick Start Guide
Overview
Installing the Adapter
Configuring the Adapter
Upgrading PeopleTools
Configuring the iWay Application Adapter for PeopleSoft
Specifying the Version of PeopleSoft
Installing the Adapter Component Interfaces
Installing the TCP/IP Message Router for the iWay Application Adapter for PeopleSoft
Copying PeopleSoft Files Into the Lib Directory
Generating Component Interface APIs
Building the PeopleSoft API Java Programs
Compiling the PeopleSoft API Java Programs
Configuring the PeopleSoft Message Router
Configuring the TCP/IP or HTTP Target Connector for PeopleSoft 8.4
Configuring the TCP/IP Handler for PeopleSoft 8.1
Testing Your PeopleSoft Configuration
Creating XML Schemas or Web Services for PeopleSoft
Overview
Starting iWay Explorer
Establishing a Target for PeopleSoft
Modifying a Target
Viewing Application System Objects
Creating an XML Schema
Generating a Web Service for PeopleSoft
Listening for PeopleSoft Events
Understanding Event Functionality
Creating, Editing, or Deleting a Port
Creating, Editing, or Deleting a Channel
Configuring an HTTP Event Listener for PeopleSoft Using iWay Service Manager
Overview
Configuring an HTTP Listener
Troubleshooting and Error Messages
Error Messages in iWay Explorer
Error Messages in PeopleSoft
Error Messages in iBSP
Configuring the Adapter in an iWay Environment
Configuring the Adapter in iWay Service Manager
Using Component Interfaces
Creating a Component Interface
Viewing or Modifying Available Methods
Securing a Component Interface
Testing a Component Interface
Using PeopleSoft 8 Integration Broker
PeopleSoft Integration Broker
Configuring Integration Broker in PeopleSoft Release 8.4 (PeopleTools Releases 8.48 - 8.51)
Configuring Integration Broker in PeopleSoft Release 8.4 (PeopleTools Releases 8.40 - 8.47)
Configuring Application Messaging in PeopleSoft Release 8.1
Viewing the PeopleCode for a Message
Testing the Integration Broker
Using Outbound Synchronous Messages
PeopleTools Upgrade Considerations
Upgrading PeopleTools
Launch PDF
Application Adapter for Salesforce User's Guide
Introducing the iWay Application Adapter for Salesforce
Features of the iWay Application Adapter for Salesforce
Component Information for the iWay Application Adapter for Salesforce
Installing the iWay Application Adapter for Salesforce
Installation Prerequisites
Installing the Adapter
Configuring and Managing Connections to Salesforce
Starting iWay Explorer (Java Swing)
Creating a New Configuration
Connecting to a New Configuration
Connecting to Salesforce
Creating XML Schemas for Salesforce
Overview
Browsing Salesforce Business Objects
Generating XML Schemas for Salesforce Business Objects
Using the Upsert Function
Creating and Publishing iWay Business Services
Understanding iWay Business Services
Creating iWay Business Services
Configuring the Retrieve Function
Configuring Outbound Messaging and Workflow Rules in Salesforce
Overview
Creating an Outbound Message
Creating a Workflow Rule
Configuring Events for Salesforce
Overview
Creating an Event Port
Creating a Channel
Certificate Management
Prerequisites
Key Store Management
Trust Store Management
Salesforce Batch API
Using the Salesforce Batch API Services
Configuring the Adapter in an iWay Environment
Configuring the Adapter in iWay Service Manager
Launch PDF
Application Adapter for Siebel User's Guide
Introducing the iWay Application Adapter for Siebel
Features of the iWay Application Adapter for Siebel
Typical Siebel Server Deployment
The Siebel Application Model
Integrating With Siebel
Siebel EAI Architecture
Using iWay Explorer With the iWay Application Adapter for Siebel
Encoding Support on UNIX Platforms
Configuring Connection Pooling for Siebel
Siebel Version 6.2 and Lower Connectivity Prerequisites
Deployment Information for Your iWay Adapter
Information Roadmap
Supported Platforms Matrix
Overview
Siebel Versions
Operating Systems
Databases
Java Development Kit (JDK)
Communication Modes
Object Types and Interfaces
Communication Types
Operations
Other Functions
Known Limitations
Related Information for Specific iWay Releases
Creating XML Schemas and iWay Business Services
Processing Overview
Starting Servlet iWay Explorer
Managing a Siebel Connection
Viewing Metadata
Creating a Schema for a Siebel Business Component or Siebel Business Service
Creating an XML Schema for a Siebel Integration Object
Locating Schemas
Returning Fields in a Specified Order
Using the QueryWithView and QueryEx Methods
Understanding the ROW_ID and REASON Attributes
Creating iWay Business Services
Listening for Siebel Events
Understanding iWay Event Functionality
Creating an Event Port
Creating a Channel
Troubleshooting and Error Messages
Troubleshooting
Error Messages in iWay Explorer
Error Messages in Siebel
Error Messages in iBSP
Updating a Siebel Field
Configuring the Adapter in an iWay Environment
Configuring the Adapter in iWay Service Manager
Siebel Workflows
Overview
Creating a Siebel Workflow
Launch PDF
Application Adapter for Microsoft Exchange User's Guide
Introducing the iWay Application Adapter for Microsoft Exchange
iWay Application Adapter for Microsoft Exchange
About Microsoft Exchange Server
Features of the iWay Application Adapter for Microsoft Exchange
Microsoft Exchange Server Versions and Exchange Web Services API Files
Component Information
Supported Platforms Matrix
Overview
Supported Versions
Operating Systems
Databases
Java Development Kit (JDK)
Communication Modes
Object Types and Interfaces
Communication Types
Operations
Data Types
Security
Other Functions
Known Limitations
Related Information for Specific iWay Releases
Quick Start Guide
Overview
Quick Start Guide
Configuring the iWay Application Adapter for Microsoft Exchange
Copying the Exchange Web Services API Library Files
Defining a Keystore
Creating a Keystore
Generating a Certificate
Importing a Certificate to a Keystore
Importing the SSL Certificate
Creating XML Schemas and Business Services
Starting iWay Explorer
Adding the Microsoft Exchange Adapter to iWay Explorer
Working With a Target
Viewing Application System Objects
Creating an XML Schema
Creating Business Services
Configuring the Adapter in an iWay Environment
Defining the Microsoft Exchange Adapter in iWay Service Manager
Configuring the Microsoft Exchange Listener
Adding the Microsoft Exchange Listener to an Inlet
Configuring a Channel
Launch PDF
Application Adapter for Microsoft Dynamics CRM 2011 On-Premises User's Guide
Introducing the iWay Application Adapter for Microsoft Dynamics CRM 2011 On-Premises
Introduction
Supported Adapter Functionality
Installing the Adapter
Understanding the Microsoft Dynamics CRM Communication Model
Component Information for the Adapter
Supported Platforms Matrix
Overview
Supported Versions
Operating Systems
Databases
Java Development Kit (JDK)
Communication Modes
Communication Types
Object Types and Interfaces
Operations
Data Types
Other Functions
Known Limitations
Restrictions
Related Information for Specific iWay Releases
Quick Start Guide
Overview
Quick Start Guide
Design Time Concepts and Configuration Tasks
Starting iWay Explorer
Adding the Microsoft Dynamics CRM 2011 Adapter to iWay Explorer
Working With a Target
Navigating the Entity and Operation Tree
Creating an XML Schema
Creating Business Services
Run Time Concepts and Configuration Tasks
Create, Read, Update, and Delete Operations
Compound Operations
Advanced Operations
Operation Sets
Retrieving Multiple Requests
Validating Input Messages
Error Handling
Caching
Connection Pool
Executing Processes (Workflow)
Importing Bulk Data
Deleting Bulk Data
Optimizing Microsoft Dynamics CRM 2011 Using HTTP Compression
Configuring the iWay WCF Routing Service (WCF Router)
Overview
Installing the WCF Router
Configuring the WCF Router
Storing Administrator Credentials in the WCF Router
Using the WCF Router to Connect to MS CRM (Selecting the Connection Mode)
Using SSL Server Certificates
Configuring the WCF Router to Work With the Adapter Through HTTPS
Installing a Certificate as a Trusted Certificate in the Java Keystore
Samples and Reference Guide
Advanced Operations
Schemas for Advanced Operations
Global Operations
Filter Document Sample
Input Message Sample
Create and Update Operation Samples
Compound Operation Sample
Linked Operation Output Sample
Bulk Delete Sample
XML Request Schema Sample
XML Response Schema Sample
Manually Setting User Interface Languages
Known Issues and Limitations
General Known Issues
Unsupported Schemas
Launch PDF
Application Adapter for J.D. Edwards EnterpriseOne User's Guide
Introducing the iWay Application Adapter for J.D. Edwards EnterpriseOne
Executing a J.D. Edwards EnterpriseOne Master Business Function
J.D. Edwards EnterpriseOne Platforms, Products, and Releases Supported
J.D. Edwards EnterpriseOne Versions and Library Files
Accessing Data Stored in J.D. Edwards EnterpriseOne
J.D. Edwards EnterpriseOne Interoperability Framework
Deployment Information for Your iWay Adapter
Information Roadmap
Supported Platforms Matrix
Overview
Supported Versions
Operating Systems
Databases
Java Development Kit (JDK)
Communication Modes
Object Types and Interfaces
Communication Types
Operations
Data Types
Other Functions
Known Limitations
Related Information for Specific iWay Releases
Quick Start Guide
Overview
Quick Start Guide
Configuring Adapter Targets and Creating XML Schemas
Overview
Starting iWay Explorer
Adding the J.D. Edwards EnterpriseOne Adapter to iWay Explorer
Working With a Target
Viewing J.D. Edwards EnterpriseOne Business Functions
Creating an XML Schema
Creating XML Request Documents
Creating and Publishing iWay Business Services
Understanding iWay Business Services
Creating iWay Business Services
Connecting to the J.D. Edwards EnterpriseOne Client
Listening for Database Events
Understanding Event Functionality
Troubleshooting
Troubleshooting
Error Messages in iWay Explorer
Error Messages in J.D. Edwards EnterpriseOne
Error Messages in iWay Business Services Provider
Configuring the Adapter in an iWay Environment
Configuring and Deploying the iWay Application System Adapter for J.D. Edwards EnterpriseOne
Configuring the Adapter in iWay Integration Tools Designer
Using the Adapter in iWay Integration Tools Designer
Configuring EnterpriseOne for Outbound Transaction Processing
Specifying Outbound Functionality for a Business Function
Configuring an Event Listener for the iWay Application Adapter for J.D. Edwards EnterpriseOne
XML List Method Support
Modifying the EnterpriseOne jde.ini File
Sample Files
Issuing a Single-Function Request
Issuing a Multiple-Function Request
Sample Sales Order Request
Sample Sales Order Response
Launch PDF
Application Adapter for J.D. Edwards World User's Guide
Introducing the iWay Application Adapter for J.D. Edwards World
Introducing J.D. Edwards World
Supported Versions
Accessing Data Stored in J.D. Edwards World
J.D. Edwards World Interoperability Framework
Deployment Information for Your iWay Adapter
Information Roadmap
Supported Platforms Matrix
Overview
Supported Versions
Operating Systems
Databases
Java Development Kit (JDK)
Communication Modes
Object Types and Interfaces
Communication Types
Operations
Data Types
Other Functions
Security
Known Limitations
Related Information for Specific iWay Releases
Quick Start Guide
Overview
Quick Start Guide
Creating XML Schemas for J.D. Edwards World
Overview
Starting iWay Explorer
Establishing a Target for J.D. Edwards World
Modifying a Target
Viewing J.D. Edwards World Libraries
Creating an XML Schema
Generating an iWay Business Service for J.D Edwards World
Configuring Events for the iWay Application Adapter for J.D. Edwards World
Creating a Trigger on a Base Table
Creating a Custom Table for J.D. Edwards World
Understanding Event Functionality
Creating, Editing, or Deleting a Port
Creating, Editing, or Deleting a Channel
Configuring the Adapter in an iWay Environment
Configuring the Adapter in iWay Service Manager
Configuring the Adapter in iWay Integration Tools Designer
Using the Adapter in iWay Integration Tools Designer
Sample File
Sample XML File
Launch PDF
Application Adapter for SAP ERP User's Guide
Introducing the iWay Application Adapter for SAP ERP
Features of the iWay Application Adapter for SAP ERP
Classic SAP ERP Technologies for ABAP
Supported Versions and Platforms
Integrating With SAP ERP
Component Information for the iWay Application Adapter for SAP ERP
Web Services and Java Connector Architecture Functionality
Supported Platforms Matrix
Overview
Supported Versions
Operating Systems
Databases
Java Development Kit (JDK)
Communication Modes
Object Types and Interfaces
Communication Types
Operations
Data Types
Other Functions
Known Limitations
Related Information for Specific iWay Releases
Quick Start Guide
Overview
Quick Start Guide
Getting Started
Installing the iWay Application Adapter for SAP ERP
Installing the SAP Java Connector (SAP JCo) 3.x
Verifying the SAP Java Connector (SAP JCo)
Identifying SAP ERP Logon Parameters
Verifying Connections to SAP ERP
Configuring SAP ERP Inbound Processing
Adapter Process Overview
Configuring a Logical System
Configuring a Distribution Model
Defining a Partner Profile
Configuring Adapter Targets and Creating XML Schemas
Overview
Understanding SAP ERP Nested Structures and Nested Tables
Starting iWay Explorer
Adding the SAP ERP Adapter to iWay Explorer
Working With a Target
Viewing Application System Objects
Creating an XML Schema
Creating and Publishing iWay Business Services
Understanding iWay Business Services
Creating iWay Business Services
Understanding SAP ERP Events
Overview
Related Concepts and Terminology
Registering Your Program ID in SAP GUI
Testing the SAP ERP Event Adapter
Application Link Enabling Configuration for the Event Adapter
Testing the SAP ALE Configuration
Configuring Event Handling
Understanding iWay Event Functionality
Creating a Port
Creating a Channel
Synchronous Event Processing
Configuring the Adapter in an iWay Environment
Configuring the Adapter in iWay Service Manager
Troubleshooting Guidelines
Identifying the Issue
Design Time
Run Time
Debugging Error Messages
Gathering Information Before Calling Customer Support
Launch PDF
e-Business Adapters
Documentation
Integration Solution for SWIFT 2017 User's Guide
Introducing the iWay Integration Solution for SWIFT
A Brief History of SWIFT
Features of the iWay Integration Solution for SWIFT
Information Roadmap
Deployment Information for Your iWay Integration Solution
iWay Products
Using a Channel to Construct a Message Flow
Components of the iWay Integration Solution for SWIFT
Configuring the EDI Activity Driver
Overview
Configuring the EDI Data Provider Using iWay Service Manager
Configuring the EDI Activity Driver Using iWay Service Manager
Working With SWIFT Inbound and Outbound Applications Using iWay Integration Tools (iIT)
Overview
Prerequisites
Extracting SWIFT User Samples
Importing SWIFT User Samples to iWay Integration Tools as a Workspace
Publishing iWay Integration Applications to the iWay Service Manager Registry
Deploying iWay Integration Applications to iWay Service Manager
Setting Registers in the iWay Service Manager Administration Console
Stopping Inbound (SWIFT to XML) and Outbound (XML to SWIFT) Processing
Testing the Sample Applications
Inbound Processing: SWIFT to XML
Inbound Processing Overview
Sample Configuration for Inbound Processing: SWIFT to XML
Outbound Processing: XML to SWIFT
Outbound Processing Overview
Sample Configuration for Outbound Processing: XML to SWIFT
Ebix-Supported Transaction Sets
Transaction Set Support
Using iWay Integration Tools to Configure an Ebix for SWIFT
Overview
Prerequisites
Downloading and Extracting an Ebix
Working With iWay Integration Tools (iIT)
Sample SWIFT Documents
SWIFT MT950 (Statement of Cash) Sample Document
SWIFT MT535 (Statement of Holding) Sample Document
SWIFT MT541 (Receive Against Payment) Sample Document
Launch PDF
Integration Solution for EDI X12 User's Guide
Introducing the iWay Integration Solution for EDI X12
A Brief History of Electronic Data Interchange
Features of the iWay Integration Solution for EDI X12
Information Roadmap
Deployment Information for Your iWay Integration Solution
iWay Products and Components
Using a Channel to Construct a Message Flow
Components of the iWay Integration Solution for EDI
Configuring the EDI Activity Driver
Overview
Configuring the EDI Data Provider Using iWay Service Manager
Configuring the EDI Activity Driver Using iWay Service Manager
Working With EDI X12 Inbound and Outbound Applications Using iWay Integration Tools (iIT)
Overview
Prerequisites
Downloading and Extracting EDI X12 User Samples
Importing EDI X12 User Samples to iWay Integration Tools as a Workspace
Publishing iWay Integration Applications to the iWay Service Manager Registry
Deploying iWay Integration Applications to iWay Service Manager
Setting Registers in the iWay Service Manager Administration Console
Stopping Inbound (EDI X12 to XML) and Outbound (XML to EDI X12) Processing
Testing the Sample Applications
Inbound Processing: EDI X12 to XML
Inbound Processing Overview
Sample Configuration for Inbound Processing: EDI to XML
Outbound Processing: XML to EDI X12
Outbound Processing Overview
Sample Configuration for Outbound Processing: XML to EDI
Ebix-Supported Transaction Sets
Transaction Set and Acknowledgement Support
Using iWay Integration Tools to Configure an Ebix for EDI X12
Overview
Prerequisites
Downloading and Extracting an Ebix File
Working With iWay Integration Tools (iIT)
Separators and Terminators
Separators and Terminators
Special Register (SREG) Types
Special Register (SREG) Types
Sample EDI X12 Files
Sample EDI 4010 850 Purchase Order
Sample EDI 4010 810 Invoice
Sample EDI 4010 856 Advanced Ship Notice
Tutorial: Mapping an IDOC to an Invoice Document (810)
Overview
Creating a New Transform Project
Understanding EDI Invoice Mapping
Mapping the Control Segments
Mapping the Header Section
Mapping the ITEM Detail
Mapping the Invoice Summary Section
Testing the Transform Project
Tutorial: Mapping an IDOC to an Advanced Ship Notice (ASN)
Overview
Creating a New Transform Project
Maintaining the HL Counters in a Transform Project
Showing and Hiding Tags
Mapping the Control Segments
Initializing Constant Values
Mapping the Begin Ship Notice (BSN) Segments
Configuring Shipment Level Segments
Configuring Order Level Segments
Configuring Pack Level Segments
Configuring Item Level Segments
Configuring the Summary Level Segment
Publishing the Transform Project
IDoc Structure
Workflow
Transformation
The Final Results
Flattening the Output Structure
Tutorial: Adding a Detail Line Counter to a Purchase Order Transform
Configuring the Required Variables
Using the Graphical Mapping Builder
Launch PDF
Integration Solution for UN/EDIFACT User's Guide
Introducing the iWay Integration Solution for UN/EDIFACT
A Brief History of EDIFACT
Features of the iWay Integration Solution for UN/EDIFACT
Information Roadmap
Deployment Information for Your iWay Integration Solution
iWay Products and Components
Using a Channel to Construct a Message Flow
Components of the iWay Integration Solution for UN/EDIFACT
Configuring the EDI Activity Log
Overview
Configuring the EDI Activity Log Using iWay Service Manager
Working With UN/EDIFACT Inbound and Outbound Applications Using iWay Integration Tools (iIT)
Overview
Prerequisites
Extracting EDIFACT User Samples
Importing EDIFACT User Samples to iWay Integration Tools as a Workspace
Publishing iWay Integration Applications to the iWay Service Manager Registry
Deploying iWay Integration Applications to iWay Service Manager
Setting Registers in the iWay Service Manager Administration Console
Stopping Inbound (EDIFACT to XML) and Outbound (XML to EDIFACT) Processing
Testing the Sample Applications
Inbound Processing: UN/EDIFACT to XML
Inbound Processing Overview
Sample Configuration for Inbound Processing: EDIFACT to XML
Outbound Processing: XML to UN/EDIFACT
Outbound Processing Overview
Sample Configuration for Outbound Processing: XML to EDIFACT
UN/EDIFACT Supported Versions
UN/EDIFACT Version Support
Using iWay Integration Tools to Configure an Ebix for EDIFACT
Overview
Prerequisites
Downloading and Extracting an Ebix
Working With iWay Integration Tools (iIT)
Special Register (SREG) Types
Special Register (SREG) Types
Sample UN/EDIFACT Files
APERAK (Application Error and Acknowledgment)
Version 3 CONTRL
INVOIC (Invoice Message)
ORDERS (Purchase Order Message)
Launch PDF
Integration Solution for HIPAA User's Guide
Introducing the iWay Integration Solution for HIPAA
The HIPAA Mandate
Promoting HIPAA Compliance and Integration
Features of the iWay Integration Solution for HIPAA
Information Roadmap
Deployment Information for Your iWay Integration Solution
iWay Products
Using a Channel to Construct a Message Flow
Components of the iWay Integration Solution for HIPAA
Configuring the EDI Activity Driver
Overview
Configuring the EDI Data Provider Using iWay Service Manager
Configuring the EDI Activity Driver Using iWay Service Manager
Working With HIPAA Inbound and Outbound Applications Using iWay Integration Tools (iIT)
Overview
Prerequisites
Extracting HIPAA User Samples
Importing HIPAA User Samples to iWay Integration Tools as a Workspace
Publishing iWay Integration Applications to the iWay Service Manager Registry
Deploying iWay Integration Applications to iWay Service Manager
Setting Registers in the iWay Service Manager Administration Console
Stopping Inbound (HIPAA to XML) and Outbound (XML to HIPAA) Processing
Testing the Sample Applications
Inbound Processing: HIPAA to XML
Inbound Processing Overview
Sample Configuration for Inbound Processing: HIPAA to XML
Outbound Processing: XML to HIPAA
Outbound Processing Overview
Sample Configuration for Outbound Processing: XML to HIPAA
Ebix-Supported Transaction Sets
Supported HIPAA Transactions
Using iWay Integration Tools to Configure an Ebix for HIPAA
Overview
Prerequisites
Downloading and Extracting an Ebix
Working With iWay Integration Tools (iIT)
Special Register (SREG) Types
Special Register (SREG) Types
Separators and Terminators
Separators and Terminators
Sample HIPAA Files
Sample HIPAA Message
Sample 997 Functional Acknowledgment
Sample Output XML Document
Sample Output Validation Report
Tutorial: Adding a Detail Line Counter to a Purchase Order Transform
Configuring the Required Variables
Using the Graphical Mapping Builder
Launch PDF
Integration Solution for EDIHL7 User's Guide
Introducing the iWay Integration Solution for EDIHL7
Prerequisites
Understanding the HL7 Protocol
Components of an HL7 Message
Sample Integration Scenario
HL7 Inbound and Outbound Flows Using MLLP
Features of the iWay Integration Solution for EDIHL7
Components of the iWay Integration Solution for EDIHL7
Deployment Information for Your iWay Integration Solution
iWay Products and Components
Using a Channel to Construct a Message Flow
Downloading, Extracting, and Importing HL7 Sample Data
Downloading and Extracting HL7 Sample Data
Importing HL7 Sample Data to iWay Integration Tools as a Workspace
Configuring the EDI Activity Driver
Overview
Configuring the EDI Data Provider Using iWay Service Manager
Configuring the EDI Activity Driver Using iWay Service Manager
Inbound Processing: HL7 to XML
Configuring a Channel for Inbound Processing
Configuring Register Sets and Registers
Importing an Ebix Into the Workspace
Configuring an iWay Integration Application for Inbound Processing
Setting System Registers
Testing the Inbound Channel Application
Inbound Processing: HL7 to XML (Using MLLP)
Configuring a Channel for Inbound Processing
Configuring Register Sets and Registers
Importing an Ebix Into the Workspace
Configuring an iWay Integration Application for Inbound Processing
Setting System Registers
Testing the Inbound Channel Application Using MLLP
Outbound Processing: XML to HL7
Configuring a Channel for Outbound Processing
Configuring Register Sets and Registers
Importing an Ebix Into the Workspace
Configuring an iWay Integration Application for Outbound Processing
Setting System Registers
Testing the Outbound Channel Application
Outbound Processing: XML to HL7 (Using MLLP)
Configuring a Channel for Outbound Processing
Configuring Register Sets and Registers
Importing an Ebix Into the Workspace
Configuring an iWay Integration Application for Outbound Processing
Setting System Registers
Testing the Outbound Channel Application Using MLLP
Supported HL7 Versions
Supported HL7 Versions and Messages
Separators and Terminators
Separators and Terminators
Using iWay Integration Tools to Configure an Ebix for HL7
Overview
Prerequisites
Loading an Ebix
Working With iWay Integration Tools (iIT)
Launch PDF
Release Notes for iWay E-Business Adapters
Release Notes for iWay E-Business Adapters
Fixed, Resolved, or Included in This Release
Known Issues
ANSI X12, VICS, UCS, and HIPAA Documents
EDIFACT Documents
SWIFT Documents
HL7 Documents
EDIHL7 Documents
Separators and Delimiters for X12, HIPAA, EDIFACT, and EDIHL7
Launch PDF
Protocol Adapters
Documentation
iWay Application Protocol Adapter for LDAP User’s Guide
Introducing the iWay Application Protocol Adapter for LDAP
Features of the iWay Application Protocol Adapter for LDAP
Component Information for the iWay Application Protocol Adapter for LDAP
Supported Platforms Matrix
Overview
LDAP Versions
Operating Systems
Databases
Java Development Kit (JDK)
Communication Modes
Object Types and Interfaces
Communication Types
Operations
Data Types
Other Functions
Known Limitations
Related Information for Specific iWay Releases
Installing the iWay Application Protocol Adapter for LDAP
Installation Prerequisites
Installing the iWay Application Protocol Adapter for LDAP
Configuring and Managing Connections to an LDAP Server
Starting iWay Explorer
Adding the LDAP Adapter to iWay Explorer
Working With a Target
Initializing a Secure Connection to an LDAP Server
Prerequisites
Installing a Secure Certificate for an LDAP Server
Creating XML Schemas for LDAP
Overview
Browsing LDAP Entries
Generating XML Schemas for LDAP Operations
Creating and Publishing iWay Business Services
Understanding iWay Business Services
Creating iWay Business Services
Configuring Events for LDAP
Overview
Creating an Event Port
Creating a Channel
Configuring the Adapter in an iWay Environment
Configuring the Adapter in iWay Service Manager
Understanding Active Directory Error Messages
Error Messages
Launch PDF
iWay Application Protocol Adapter for ConnectDirect User’s Guide
Introducing the iWay Protocol Adapter for Connect:Direct
Features of the iWay Protocol Adapter for Connect:Direct
Understanding Connect:Direct
Service Adapter Functionality
Event Adapter Functionality
Supported Platforms Matrix
Overview
Supported Versions
Operating Systems
Databases
Java Development Kit (JDK)
Communication Modes
Object Types and Interfaces
Communication Types
Operations
Data Types
Other Functions
Known Limitations
Related Information for Specific iWay Releases
Installing the iWay Protocol Adapter for Connect:Direct
Prerequisites
Installation Files
Installing the Adapter
Creating XML Schemas and Business Services
Overview
Starting iWay Explorer
Adding the Connect:Direct Adapter to iWay Explorer
Working With a Target
Viewing Application System Objects
Creating an XML Schema
Creating Business Services
Sample XML Request and Response Schemas
Configuring Event Handling
Overview
Understanding Ports and Channels
Creating a Port
Creating a Channel
Launch PDF
Legacy Adapters
Documentation
iWay Emulation Adapter (3270/5250) User's Guide
Introducing the iWay Emulation Adapter (3270/5250)
Integrating Mainframe Logic
Remote Procedure Call Development Mode
Installing the iWay Emulation Adapter (3270/5250)
Deployment Information for the iWay Emulation Adapter (3270/5250)
Understanding Telnet Designer
Navigating Telnet Designer
Menu Options
Working With Telnet Designer Projects
Telnet Designer Tools
Using Remote Procedure Call Mode
Remote Procedure Call Mode Overview
Creating a Transaction Module
Creating XML Schemas and iWay Business Services
Creating an Adapter Transaction
Understanding iWay Business Services
Creating iWay Emulation Adapter (3270/5250) iWay Business Services
Using Emulation and Recorder Modes
Using Emulation Mode
About Recorder Mode
Creating a Prerecorded File
Developing Against a Prerecorded File
Emulator Keyboard Mapping
Emulator Keyboard Mapping
Launch PDF
Transaction Adapter for IMS User’s Guide
Introducing the Transaction Adapter for IMS
Overview
Understanding the iWay Transaction for IMS
Deployment Information for the iWay Transaction Adapter for IMS
Configuring the Adapter
Starting iWay Explorer (Java Servlet)
Configuring a Connection to IMS/TM
Managing a Connection to IMS/TM
Creating XML Schemas and iWay Business Services
Creating an Adapter Transaction
Creating Schemas for an Adapter Transaction
Understanding iWay Business Services
Event Processing With the IMS Adapter
Understanding IMS Events
Configuring IMS Events
Creating and Modifying an Event Port
Creating and Modifying a Channel
Testing IMS Events
Running IMS Events
Configuring the Adapter in an iWay Environment
Configuring the Adapter in iWay Service Manager
Using the IMS Sample Programs
IWTEST01 Sample Program
IWTEST05 Sample Program
IWTEST10 Sample Program
IWAYEVT0 Sample Program
IWAYEVT2 Sample Program
Sample Requests, Schemas, and COBOL File Descriptions
Request Document to Run PART as a Generic Transaction
Request Schema for Generic Transaction PART
Response Schema for Generic Transaction PART
Request Documents for Adapter Transaction PART
Request Schema for Adapter Transaction PART
Response Schema for Adapter Transaction PART
Sample COBOL File Descriptions for PART
Conversational Transaction Sample
Debugging and Troubleshooting
Troubleshooting
Launch PDF
Transaction Adapter for CICS User’s Guide
Introducing the iWay Transaction Adapter for CICS
Overview
The iWay Transaction Adapter for CICS
Deployment Information for Your iWay Adapter
Information Roadmap
Configuring the Adapter
Starting iWay Explorer (Java Servlet)
Configuring a Connection to CICS
Managing a Connection to CICS
Creating XML Schemas and iWay Business Services
Creating an Adapter Transaction
Creating Schemas for an Adapter Transaction
Understanding iWay Business Services
Event Processing With the CICS Adapter
Understanding CICS Events
Configuring CICS Events
Creating and Modifying an Event Port
Creating and Modifying a Channel
Testing CICS Events
Running CICS Events
Configuring the Adapter in an iWay Environment
Configuring the Adapter in Service Manager
Running the Adapter Using LU6.2 Communication
MVS OS/390 APPC Communication
Microsoft SNA Server Communication
Application Run-Time Requirements
Running the Adapter Using TCP/IP Communication
MVS OS/390 TCP/IP Communication
Using Adabas/Natural Programs
Overview
Installing the Adabas/Natural Interface
Writing and Configuring a Natural Program
Installing the Sample IWAYIVP and IWAYSRV0 Programs in CICS
Installing and Configuring IWAYIVP
Installing and Configuring IWAYSRV0
Sample Requests, Schemas, and COBOL File Descriptions
Request Document for the Generic Transaction, IWAYIVP
Request Schema for IWAYIVP
Response Schema for IWAYIVP
Request Documents for IWAYSRV0
Request Schema for IWAYSRV0
Response Schema for IWAYSRV0
Request Document for AASNATN
Request Schema for AASNATN
Response Schema for the Program AASNATN
Sample COBOL File Descriptions
Sample Programs
IWAYIVP Program
IWAYSRV0 Program
IWAYEVT0 Program
IWAYEVT1 Program
Natural Program
Debugging and Troubleshooting
Troubleshooting
Data Type Conversions
Launch PDF
Technology Adapters
Documentation
iWay Technology Adapter for .NET User's Guide
Introducing the iWay .NET Technology Adapter
Overview
Installing the iWay .NET Technology Adapter
Understanding the Technology of the iWay .NET Adapter
Component Information for the iWay .NET Technology Adapter
Supported Platforms Matrix
Overview
Supported Versions
Operating Systems
Databases
Java Development Kit (JDK)
Communication Modes
Object Types and Interfaces
Communication Types
Operations
Data Types
Other Functions
Known Limitations
Restrictions
Common Language Run-time Scope
Related Information for Specific iWay Releases
Design Time Concepts and Configuration Tasks
Exploring Assemblies
Starting iWay Explorer
Adding the .NET Adapter to iWay Explorer
Working With a Target
Understanding the Assembly Viewer in iWay Explorer
Controlling the Adapter Behavior Using a Properties File
Run Time Concepts and Configuration Tasks
Run Time Implementation
Understanding Design Time and Run Time Targets
Using the Persist Connection Parameter
Understanding the Relationship Between Java and .NET
Invoking the iWay .NET Technology Adapter
Configuring the Adapter in an iWay Environment
Configuring the Adapter in iWay Service Manager
Samples and Reference Guide
Using COM Interop in the iWay .NET Technology Adapter
Generating XML Schema in Legacy Mode
Generating XML Schema in the Current Adapter Version
Modifying XML Schemas
Additional Sample XML Documents
Known Issues and Limitations
Supported and Unsupported Areas
Tested Application Scope
Launch PDF
iWay Technology Adapter for ESRI User's Guide
Introducing the iWay Technology Adapter for ESRI
Introduction to ESRI and Geographic Information Systems
About the iWay Technology Adapter for ESRI
Installation Notes
Component Information for the iWay Technology Adapter for ESRI
Information Roadmap
Supported Platforms Matrix
Overview
Supported Versions
Operating Systems
Databases
Java Development Kit (JDK)
Communication Modes
Object Types and Interfaces
Communication Types
Operations
Data Types
Other Functions
Known Limitations
Related Information for Specific iWay Releases
Creating Targets
About Targets
Starting iWay Explorer
Creating a New Configuration in Java Swing iWay Explorer
Creating and Managing a Connection
Creating XML Schemas and iWay Business Services
Overview of Schemas and iWay Business Services
Generating Schemas
Creating an iWay Business Service
Using the Adapter - A Scenario
The Scenario Overview
Obtaining Geocoding Address Data
Delivering Geocoding Data to the ESRI Database
Manipulating Data in the ESRI Database
Configuring the Adapter in an iWay Environment
Configuring the Adapter in iWay Service Manager
Troubleshooting
Troubleshooting
iWay Business Services Provider Error Messages
Launch PDF
iWay Technology Adapter for RDBMS User's Guide
Introducing the iWay Technology Adapter for RDBMS
Introduction
Using the Adapter With Relational Databases
Using the Adapter to Access Non-relational Databases
Deployment Information for Your iWay Adapter
Information Roadmap
Creating XML Schemas or Business Services
Generating Schemas and Business Services
Starting iWay Explorer
Creating and Managing a Connection
Viewing Metadata
Understanding and Testing Stored Procedures
Understanding and Testing Stored Procedures and Functions Contained in an Oracle Package
Creating an SQL Statement and Generating Schemas
Understanding and Creating Batch Statements
Request and Response Documents
Understanding iWay Business Services
Listening for Database Events
Understanding iWay Event Functionality
Creating, Editing, or Deleting an Event Port
Creating, Editing, or Deleting an Event Channel
Choosing a Listening Technique
Standard Event Processing With Row Tracking
Standard Event Processing With Row Removal
Trigger-based Event Processing
Configuring the Adapter in an iWay Environment
Configuring the Adapter in iWay Service Manager
JDBC Drivers
Copying and Collecting a JDBC File
Launch PDF
Log Event Adapters
Documentation
Log Event Adapter for SQL Server
Introducing the iWay Log Event Adapter for Microsoft SQL Server
Overview
Architecture of the iWay Log Event Adapter for Microsoft SQL Server
Component Information for the iWay Log Event Adapter for Microsoft SQL Server
Installing and Configuring the iWay Log Event Adapter for Microsoft SQL
Prerequisites
Remote Component Installation Requirements
Installing the iWay Log Event Adapter for MS SQL
Constraints and Limitations
Apex Installation Troubleshooting
Configuring Components for the iWay Log Event Adapter for Microsoft SQL Server
Configuring the DOT NET Adapter
Configuring the iWay CDC SQL Batch Agent
Launch PDF
Log Event Adapter for Informix
Introducing the iWay Log Event Adapter for Informix
Features of the iWay Log Event Adapter for Informix
Architecture Overview of the iWay Log Event Adapter for Informix
Component Information for the iWay Log Event Adapter for Informix
Installing and Configuring the iWay Log Event Adapter for Informix
Prerequisites
Installing the iWay Log Event Adapter for Informix
Installing the iWay Informix CDC Agent
Configuring the iWay Log Event Adapter for Informix
Configuring Components for the iWay Log Event Adapter for Informix
Understanding the Table List Configuration File
Understanding CDC Subscription
Configuring the iWay Informix CDC Agent
Modifying an Informix Table Marked for Replication
Configuring the iWay Log Event Listener
Configuring the iWay CDC SQL Batch Agent
Launch PDF
Log Event Adapter for Oracle
Introducing the iWay Log Event Adapter for Oracle
Overview
Component Information for the iWay Log Event Adapter for Oracle
Installing and Configuring the iWay Log Event Adapter for Oracle
Prerequisites
Installing the iWay Log Event Adapter for Oracle
Using Oracle LogMiner
Importing a Sample Channel Archive Using iWay Service Manager
Building and Deploying a Channel
Configuring Components for the iWay Log Event Adapter for Oracle
Configuring the iWay Log Event Listener
Configuring the iWay CDC SQL Batch Agent
Launch PDF
DataMigrator
Documentation
DataMigrator User's Guide
Introduction to DataMigrator
Data Management and Migration Overview
What Is DataMigrator?
DataMigrator Architecture
DataMigrator Server
DataMigrator Data Management Console
Server Web Console
Designing Data Flows and Process Flows
Revised Functionality
Getting Help
Information Builders and iWay Software on the Web
Setting Up DataMigrator
DataMigrator Setup At a Glance
Remote Server Setup At a Glance
DataMigrator Setup
Initiating Server Administration Tasks
Authorizing DataMigrator Server Usage and Administration
Managing Application Directories and Configuring the Application Path
Configuring Data Adapters
Creating Metadata
Testing Sample Data and Process Flows
Performing Server Administration Tasks
Using Secure Shell FTP (SFTP)
Upgrading DataMigrator From Release 4.3 or 5.1
Upgrading DataMigrator from Release 5.2, 5.3, 7.1, or 7.6
Planning a DataMigrator Application
Designing Your Application
Using Synonyms for Data Sources and Data Targets
Reviewing Your Data Sources
Reviewing Your Data Targets
Establishing Security for DataMigrator
Working in the Data Management Console
Data Management Console Interface
Navigation Pane
DataMigrator Workspace
Text Editor
Aerial View
Ribbon Tabs
Metadata Tab
Text Editor Tab
Console Log
Setting Flow Properties
Viewing Properties
Setting User Preferences
User Privileges
License Code
Configuring National Language Support
Ending a Data Management Console Session
Designing a Data Flow
The Data Flow Interface
Simple Data Flow at a Glance
Complex Data Flow at a Glance
Creating a Data Flow
Specifying Data Sources
Creating a Source Transformation in a Data Source Object
Joining Data Sources
Adding a SELECT to a Data Flow
Adding a UNION to a Data Flow
Selecting Columns
Testing the SQL Statement
Specifying Filters in a Data Flow
Specifying Sorts
Selecting a Data Target
Specifying Data Target Options
Mapping Transformations
Using Variables in a Flow
Using Functions
Column Formats and Mapping
Setting Properties of a Flow
Running a Data Flow
Creating a Direct Load Flow
Creating a DBMS SQL Flow
Creating a Quick ETL Copy
Designing a Process Flow
Process Flow Methodology
Process Flow Interface
Simple Process Flow At a Glance
Complex Process Flow at a Glance
Creating a Process Flow
Adding a Saved Procedure to a Process Flow
Assigning and Using Variables in a Process Flow
Maintaining Continuous Processing in a Single Agent
Executing a Process Flow That Contains Only Procedures
Adding Email Messages to a Process Flow
Setting Connection Logic
Grouping and Controlling Simultaneous Execution of Flows
Running a Process Flow
Scheduling a Process Flow
Tutorial: Creating Data and Process Flows With DataMigrator
What You Are Going To Do
Startup and Setup Tasks
Exercise 1: Creating the Data Flow
Selecting and Joining Data Sources
Selecting and Managing Columns
Adding Data Targets
Submitting the Data Flow
Data Flow Review
Exercise 2: Creating the Process Flow
Starting the Process Flow
Adding a Data Flow Object to the Process Flow
Branching in the Process Flow
Submitting the Process Flow
Generating Reports, Viewing the Log File, and Printing Flows
DataMigrator Log, Statistics, and Summary Flow Reports
Scheduler Reports
Impact Analysis Reports on Synonyms, Procedures and Columns
Working With a Report
Viewing a Detailed Flow Report and Log File
Printing a Graphical Representation of a Data or Process Flow
Optimizing Performance
Improving Data Extraction Performance
Using Automatic Passthru
Improving Data Loading Performance
Improving Lookup Performance
Working With Synonyms
Synonym Editor Layout
Viewing and Editing Synonym Attributes
Using Variables in a Synonym
Variables Attribute Summary
How to Use a Variable in a Synonym
Creating, Enhancing, and Editing Synonyms Using Modeling View
Adding Indexes to a Synonym
Adding Virtual Columns (DEFINE) in a Synonym
Viewing Data Profiling Characteristics
Viewing Data Lineage for a Column
Advanced DataMigrator Tips and Techniques
Overview of Examples
Creating Sample Data and Metadata
Horizontal Partitioning with Multi-Table Load
Using the Decode Function
Generating a Surrogate Key
Generating a Surrogate Key Using Slowly Changing Dimensions
Mapping to a Sequential File of a Specific Format
Creating and Using Reusable Transformations
Using Multiple Targets to Create a Single File With Multiple Records Types
Creating a Target File With Multiple RECTYPEs
Combining Multiple Sources Rows in a Single Target Row
Using Lookups to Create Multi-Table Flows Without Joins
Record Logging
Using Variables in Data Flows
Creating a Data Flow Using a Target Based on a Predefined XML Schema
Loading a Target Table Using the File Listener
Sending a Target File to an FTP or SFTP Server
Loading a Star Schema
Iterating Through Multiple Tables
Using Subqueries
Loading Images Into a Database Table
Change Data Capture
Enabling the Database for Logging in Relational Databases
Enabling the Database for Logging in VSAM
Properties of a Table Log Record Synonym
Tutorial: Using Change Data Capture with Relational Databases
Tutorial: Using Change Data Capture With VSAM
DataMigrator Log Statistics and Tables
Log and Statistics Tables
Event-Based Scheduling
Starting Flows With CMRUN
Starting Flows With CMASAP
Starting Flows From FOCUS
Determining the Status of an Event-Based Flow
Problems, Errors, and Troubleshooting
DataMigrator Status Codes and Server Messages
Server Run-Time Error Codes
DataMigrator Management Problem Resolution
Including Run-Time Messages in the ETL Log
Performing a Trace to Diagnose Server Problems
Customizing Your Environment
DataMigrator Parameters
Source Management
Overview of Source Management
Source Control Security Server and Client Setup
Configuring Source Management and Setting Up Source Control
Using a Source Control System to Manage Procedures and Synonyms
Launch PDF
Functions Reference
Functions Overview
Function Arguments
Function Categories
Character Chart for ASCII and EBCDIC
Character Functions
ARGLEN: Measuring the Length of a String
ASIS: Distinguishing Between Space and Zero
BITSON: Determining If a Bit Is On or Off
BITVAL: Evaluating a Bit String as an Integer
BYTVAL: Translating a Character to Decimal
CHKFMT: Checking the Format of a String
CHKNUM: Checking a String for Numeric Format
CTRAN: Translating One Character to Another
CTRFLD: Centering a Character String
EDIT: Extracting or Adding Characters
GETTOK: Extracting a Substring (Token)
LCWORD: Converting a String to Mixed-Case
LCWORD2: Converting a String to Mixed-Case
LCWORD3: Converting a String to Mixed-Case
LJUST: Left-Justifying a String
LOCASE: Converting Text to Lowercase
OVRLAY: Overlaying a Character String
PARAG: Dividing Text Into Smaller Lines
PATTERN: Generating a Pattern From a String
POSIT: Finding the Beginning of a Substring
REVERSE: Reversing the Characters in a String
RJUST: Right-Justifying a Character String
SOUNDEX: Comparing Character Strings Phonetically
SPELLNM: Spelling Out a Dollar Amount
SQUEEZ: Reducing Multiple Spaces to a Single Space
STRIP: Removing a Character From a String
STRREP: Replacing Character Strings
SUBSTR: Extracting a Substring
TRIM: Removing Leading and Trailing Occurrences
UPCASE: Converting Text to Uppercase
XMLDECOD: Decoding XML-Encoded Characters
XMLENCOD: XML-Encoding Characters
Variable Length Character Functions
Overview
LENV: Returning the Length of an Alphanumeric Field
LOCASV: Creating a Variable Length Lowercase String
POSITV: Finding the Beginning of a Variable Length Substring
SUBSTV: Extracting a Variable Length Substring
TRIMV: Removing Characters From a String
UPCASV: Creating a Variable Length Uppercase String
Simplified Character Functions
CHAR_LENGTH: Returning the Length in Characters of a String
DIGITS: Converting a Number to a Character String
LOWER: Returning a String With All Letters Lowercase
LPAD: Left-Padding a Character String
LTRIM: Removing Blanks From the Left End of a String
POSITION: Returning the First Position of a Substring in a Source String
RPAD: Right-Padding a Character String
RTRIM: Removing Blanks From the Right End of a String
SUBSTRING: Extracting a Substring From a Source String
TOKEN: Extracting a Token From a String
TRIM_: Removing a Leading Character, Trailing Character, or Both From a String
UPPER: Returning a String With All Letters Uppercase
Character Functions for DBCS Code Pages
DCTRAN: Translating A Single-Byte or Double-Byte Character to Another
DEDIT: Extracting or Adding Characters
DSTRIP: Removing a Single-Byte or Double-Byte Character From a String
DSUBSTR: Extracting a Substring
JPTRANS: Converting Japanese Specific Characters
KKFCUT: Truncating a String
SFTDEL: Deleting the Shift Code From DBCS Data
SFTINS: Inserting the Shift Code Into DBCS Data
Data Source and Decoding Functions
DB_EXPR: Inserting an SQL Expression Into a Request
DB_INFILE: Testing Values Against a File or an SQL Subquery
DB_LOOKUP: Retrieving Data Source Values
DECODE: Decoding Values
FIND: Verifying the Existence of a Value in a Data Source
LAST: Retrieving the Preceding Value
LOOKUP: Retrieving a Value From a Cross-referenced Data Source
Date Functions
Overview of Date Functions
Using Standard Date Functions
DATEADD: Adding or Subtracting a Date Unit to or From a Date
DATECVT: Converting the Format of a Date
DATEDIF: Finding the Difference Between Two Dates
DATEMOV: Moving a Date to a Significant Point
DATETRAN: Formatting Dates in International Formats
FIYR: Obtaining the Financial Year
FIQTR: Obtaining the Financial Quarter
FIYYQ: Converting a Calendar Date to a Financial Date
TODAY: Returning the Current Date
Using Legacy Date Functions
AYM: Adding or Subtracting Months
AYMD: Adding or Subtracting Days
CHGDAT: Changing How a Date String Displays
DA Functions: Converting a Legacy Date to an Integer
DMY, MDY, YMD: Calculating the Difference Between Two Dates
DOWK and DOWKL: Finding the Day of the Week
DT Functions: Converting an Integer to a Date
GREGDT: Converting From Julian to Gregorian Format
JULDAT: Converting From Gregorian to Julian Format
YM: Calculating Elapsed Months
Date-Time Functions
Using Date-Time Functions
HADD: Incrementing a Date-Time Value
HCNVRT: Converting a Date-Time Value to Alphanumeric Format
HDATE: Converting the Date Portion of a Date-Time Value to a Date Format
HDIFF: Finding the Number of Units Between Two Date-Time Values
HDTTM: Converting a Date Value to a Date-Time Value
HGETC: Storing the Current Date and Time in a Date-Time Field
HGETZ: Storing the Current Coordinated Universal Time in a Date-Time Field
HHMMSS: Retrieving the Current Time
HHMS: Converting a Date-Time Value to a Time Value
HINPUT: Converting an Alphanumeric String to a Date-Time Value
HMIDNT: Setting the Time Portion of a Date-Time Value to Midnight
HNAME: Retrieving a Date-Time Component in Alphanumeric Format
HPART: Retrieving a Date-Time Component as a Numeric Value
HSETPT: Inserting a Component Into a Date-Time Value
HTIME: Converting the Time Portion of a Date-Time Value to a Number
HTMTOTS: Converting a Time to a Timestamp
HYYWD: Returning the Year and Week Number From a Date-Time Value
Simplified Date and Date-Time Functions
DTADD: Incrementing a Date or Date-Time Component
DTDIFF: Returning the Number of Component Boundaries Between Date or Date-Time Values
DTPART: Returning a Date or Date-Time Component in Integer Format
DTRUNC: Returning the Start of a Date Period for a Given Date
Format Conversion Functions
ATODBL: Converting an Alphanumeric String to Double-Precision Format
EDIT: Converting the Format of a Field
FPRINT: Converting Fields to Alphanumeric Format
FTOA: Converting a Number to Alphanumeric Format
HEXBYT: Converting a Decimal Integer to a Character
ITONUM: Converting a Large Number to Double-Precision Format
ITOPACK: Converting a Large Binary Integer to Packed-Decimal Format
ITOZ: Converting a Number to Zoned Format
PCKOUT: Writing a Packed Number of Variable Length
PTOA: Converting a Packed-Decimal Number to Alphanumeric Format
TSTOPACK: Converting an MSSQL or Sybase Timestamp Column to Packed Decimal
UFMT: Converting an Alphanumeric String to Hexadecimal
XTPACK: Writing a Packed Number With Up to 31 Significant Digits to an Output File
Numeric Functions
ABS: Calculating Absolute Value
CHKPCK: Validating a Packed Field
DMOD, FMOD, and IMOD: Calculating the Remainder From a Division
EXP: Raising e to the Nth Power
EXPN: Evaluating a Number in Scientific Notation
INT: Finding the Greatest Integer
LOG: Calculating the Natural Logarithm
MAX and MIN: Finding the Maximum or Minimum Value
NORMSDST and NORMSINV: Calculating Normal Distributions
PRDNOR and PRDUNI: Generating Reproducible Random Numbers
RDNORM and RDUNIF: Generating Random Numbers
SQRT: Calculating the Square Root
System Functions
CLSDDREC: Closing All Files Opened by the PUTDDREC Function
FEXERR: Retrieving an Error Message
FGETENV: Retrieving the Value of an Environment Variable
FPUTENV: Assigning a Value to an Environment Variable
GETUSER: Retrieving a User ID
JOBNAME: Retrieving the Current Process Identification String
PUTDDREC: Writing a Character String as a Record in a Sequential File
SLEEP: Suspending Execution for a Given Number of Seconds
SYSVAR: Retrieving the Value of a z/OS System Variable
SQL Character Functions
CHAR_LENGTH: Finding the Length of a Character String
CONCAT: Concatenating Two Character Strings
DIGITS: Converting a Numeric Value to a Character String
EDIT: Editing a Value According to a Format (SQL)
LCASE: Converting a Character String to Lowercase
LTRIM: Removing Leading Spaces
POSITION: Finding the Position of a Substring
RTRIM: Removing Trailing Spaces
SUBSTR: Extracting a Substring From a String Value (SQL)
TRIM: Removing Leading or Trailing Characters (SQL)
UCASE: Converting a Character String to Uppercase
VARGRAPHIC: Converting to Double-byte Character Data
SQL Date and Time Functions
CURRENT_DATE: Obtaining the Date
CURRENT_TIME: Obtaining the Time
CURRENT_TIMESTAMP: Obtaining the Timestamp (Date/Time)
DAY: Obtaining the Day of the Month From a Date/Timestamp
DAYS: Obtaining the Number of Days Since January 1, 0001
EXTRACT: Obtaining a Datetime Field From Date/Time/Timestamp
HOUR: Obtaining the Hour From Time/Timestamp
MICROSECOND: Obtaining Microseconds From Time/Timestamp
MILLISECOND: Obtaining Milliseconds From Time/Timestamp
MINUTE: Obtaining the Minute From Time/Timestamp
MONTH: Obtaining the Month From Date/Timestamp
SECOND: Obtaining the Second Field From Time/Timestamp
QUARTER: Returning the Quarter of the Year
WEEKDAY: Returning the Day of the Week
YEAR: Obtaining the Year From a Date or Timestamp
SQL Data Type Conversion Functions
CAST: Converting to a Specific Data Type
CHAR: Converting to a Character String
CHAR: Converting to a Standard Date-Time Format
DATE: Converting to a Date
DECIMAL: Converting to Decimal Format
FLOAT: Converting to Floating Point Format
INT: Converting to an Integer
SMALLINT: Converting to a Small Integer
TIME: Converting to a Time
TIMESTAMP: Converting to a Timestamp
SQL Numeric Functions
ABS: Returning an Absolute Value (SQL)
LOG: Returning a Logarithm (SQL)
EXP: Returning e Raised to a Power
POWER: Raising a Value to a Power
SQRT: Returning a Square Root (SQL)
SQL Miscellaneous Functions
COUNTBY: Incrementing Column Values Row by Row
HEX: Converting to Hexadecimal
IF: Testing a Condition
LENGTH: Obtaining the Physical Length of a Data Item
VALUE: Coalescing Data Values
SQL Operators
CASE: SQL Case Operator
COALESCE: Coalescing Data Values
NULLIF: NULLIF Operator
Launch PDF
iWay Data Quality Suite
Data Quality Server
Getting Started
iWay Data Quality Server (DQS) Getting Started Guide
Introduction
What Is iWay DQS?
Additional Help Resources
User Interface Overview
Overview
Working with Projects
Switching the Workspace
Creating a New Project
Working with Plans
Starting a Plan File
Plan Editor
Working With Data Files
Tips for Using Steps
Using Functions
Using Regular Expressions
Running a Plan and Errors
Creating a Profile
Creating a Quick Profile
Creating a Profile With a Plan
Reading a Profile
Column Analysis
Advanced Analysis
Working With Databases
Installing Database Connectivity Drivers
Connecting to a Database
Drill-through Tables
Teamwork and Using SVN
Overview
Sharing a Project Using SVN
Importing a Project Using SVN
Updating and Committing
Launch PDF
Documentation
iWay Data Quality Server (DQS) Installation Guide
Introduction
System Requirements
Understanding iWay Data Quality Server Installation
Installing iWay Data Quality Server
Accessing Documentation
Launch PDF
iWay Data Quality Server (DQS) Frequently Asked Questions (FAQ)
Frequently Asked Questions (FAQ)
Can DQS connect directly to an external version control system such as Subversion?
How can I add the SVN view to the perspective?
Is it possible to perform SVN commands without changing the perspective?
Can I change the time zone settings to obtain the exact time as in the DB?
Is there a function that could give me the name of the plan I am in from within a plan step?
How can I pass external parameters to DQS plans?
How can I parameterize DQS components?
How can I parameterize a SQL query?
What password encryptions can I use?
How do I import data from MS Access and create Metadata?
How I can call, execute, terminate, or restart an online service (services .online file) using the command line?
Launch PDF
iWay Data Quality Server (DQS) Cheat Sheets Reference Guide
Functions
Basic String Functions
Regular Expression Functions
Conversion Functions
Datetime Functions
String Distance Functions
Set Distance Functions
Conditionals
Regular Expressions
Metacharacters Defined
Character Escapes
Character Classes
Launch PDF
iWay Data Quality Server (DQS) Upgrade Guide
Upgrading iWay Data Quality Server (DQS) Version 7 and 8
Server Configuration
Launch PDF
Data Profiler
Getting Started
Data Profiler Getting Started Guide
Introducing iWay Data Profiler
iWay Data Profiler Overview
Using iWay Data Profiler
Understanding the Console Layout and User Interface
Logging On to iWay Data Profiler
Navigating the Home Page
iWay Data Profiler Features
Pagination Buttons
Launch PDF
Documentation
iWay Data Profiler Installation and Configuration Guide
Prerequisites
Hardware Requirements
Operating System Requirements
Java Requirements
WebFOCUS Requirements
Application Server Requirements
Database Requirements
Other Requirements
Platform Matrix
Installing and Uninstalling iWay Data Profiler
Windows
UNIX or Linux for iWay Data Profiler Version 9.0.1
Post-Installation Database Configuration
Specifying Identical or Unique Schema Values With Corresponding User IDs and Passwords
Integrating iWay Data Profiler With the Web and Application Server
Overview
Integrating iWay Data Profiler With Apache Tomcat
Integrating WebFOCUS Client With Apache Tomcat
Overview
Creating the ibi_apps.xml File
Creating the ibi_help.xml File
Creating the ibi_html.xml File
Integrating iWay Data Profiler With WebFOCUS
Adding License Keys for WebFOCUS Active Technologies Reports
Configuring the WebFOCUS Client
Configuring Linux for WebFOCUS With Respect to iWay Data Profiler Version 9.0.1
Appending the iDP Folder to the Application Directories
Mapping iWay Data Profiler With WebFOCUS Reporting Server
Configuring Data Services
Configuring iWay Data Profiler With Databases
Configuring iWay Data Profiler With MySQL Server 5.5
Configuring iWay Data Profiler With MS SQL Server 2005 or MS SQL Server 2008
Configuring iWay Data Profiler With Oracle 11g
Configuring iWay Data Profiler With Teradata Server Version 13.10.00.14
Installation and Configuration Verification Process of iWay Data Profiler
Testing and Verifying the iWay Data Profiler Installation and Configuration
Configuring iWay Data Quality Server for Plans
Prerequisites
Configuring iWay Data Profiler Properties Using the Server Manager Console
Accessing the iWay Data Profiler - Server Manager Console
Configuring Data Profiler Settings
Configuring Logger Settings
Configuring Mail Settings
Configuring LDAP Settings
Enforcing Security in WebFOCUS
Enforcing Security in WebFOCUS
Starting WebFOCUS as a Windows Service
Starting WebFOCUS as a Windows Service
Configuring the Drill-Through Adapter in WebFOCUS
Prerequisites
Configuring the Drill-Through Adapter in WebFOCUS Using the Same Database Type
Configuring the Drill-Through Adapter in WebFOCUS Using Different Database Types
Configuring WebFOCUS, Apache Tomcat, and Oracle 11g for Multilingual Support Using UTF-8
Configuring WebFOCUS Reporting Server to Use UTF-8
Configuring WebFOCUS Client to Use UTF-8
Configuring Apache Tomcat to Use UTF-8
Configuring Oracle 11g to Use UTF-8
Using Test Cases to Ensure the Proper Installation of WebFOCUS
Testing Java Services
Testing APP HOLD
Resolving Java Virtual Memory Issues With WebFOCUS and iWay DQS
Java Virtual Memory Issues
Setting the Maximum Heap Size in WebFOCUS
Setting the Maximum Heap Size in iWay DQS
Installing and Configuring iWay Data Profiler on a Linux Platform With an Oracle RAC Database
Prerequisites
Installing iWay Data Profiler Version 9.0.1 on Linux
Post-Installation Configuration Tasks
Launch PDF
iWay Data Profiler User's Guide
Managing Data Quality Profiles
Overview
Displaying Data Quality Profiles
Creating Data Quality Profiles
Editing Data Quality Profiles
Viewing Data Quality Profiles
Exporting Data Quality Profiles
Deleting Data Quality Profiles
Viewing Process Results
Comparing Data Quality Profiles
Using Compare Data Quality Profiles
Managing Data Quality Metrics
Overview
Creating Data Quality Metrics
Editing Data Quality Metrics
Viewing Data Quality Metrics
Exporting Data Quality Metrics
Deleting Data Quality Metrics
Viewing Process Results
Comparing Data Quality Metrics
Using Compare
Managing Data Quality Plans for Data Quality Profiles
Plans for Data Quality Profiles
Viewing Data Quality Profile Process Results
Managing Plans for Data Quality Metrics
Plans for Data Quality Metrics
Viewing Data Quality Metrics Process Results
Managing WebFOCUS Custom Reports
Overview
Displaying Custom Reports
Creating Custom Reports
Editing Custom Reports
Viewing Custom Reports
Deleting Custom Reports
Viewing Process Results
Managing the Security Center
Overview
Managing Users
Managing Groups
Managing Roles
Managing Folders
Using the WebFOCUS appBranding Kit
Overview
Creating and Exporting Data Quality Profiles Using iWay Data Quality Server
Overview
Creating a DQS Plan Using the Profiling Step
Exporting the Data Quality Profile XML File
Creating and Exporting Data Quality Metrics Using iWay Data Quality Server
Overview
Creating a DQS Plan Using the Data Quality Metric Step
Importing the Data Quality Metric Text File to iWay Data Profiler
Generating Data Profiles Automatically Using the Data Profiler Service
Overview
Configuring iWay Service Manager to Support iWay Data Profiler Automation
Creating a Process Flow for iDP Automation
Configuring a Channel to View a Data Quality Profile
Drill-through Behavior Reference
Roll-up Behavior Reference
Generating Data Quality Profiles Automatically Using the Insert Into iDP Utility Service
Overview
Configuring the Insert Into iDP Utility to Support iWay Data Profiler Automation
Launch PDF
Data Quality Server
Getting Started
iWay Data Quality Server (DQS) Getting Started Guide
Introduction
What Is iWay DQS?
Additional Help Resources
User Interface Overview
Overview
Working with Projects
Switching the Workspace
Creating a New Project
Working with Plans
Starting a Plan File
Plan Editor
Working With Data Files
Tips for Using Steps
Using Functions
Using Regular Expressions
Running a Plan and Errors
Creating a Profile
Creating a Quick Profile
Creating a Profile With a Plan
Reading a Profile
Column Analysis
Advanced Analysis
Working With Databases
Installing Database Connectivity Drivers
Connecting to a Database
Drill-through Tables
Teamwork and Using SVN
Overview
Sharing a Project Using SVN
Importing a Project Using SVN
Updating and Committing
Launch PDF
Documentation
iWay Data Quality Server (DQS) Installation Guide
Introduction
System Requirements
Understanding iWay Data Quality Server Installation
Installing iWay Data Quality Server
Accessing Documentation
Launch PDF
iWay Data Quality Server (DQS) Frequently Asked Questions (FAQ)
Frequently Asked Questions (FAQ)
Can DQS connect directly to an external version control system such as Subversion?
How can I add the SVN view to the perspective?
Is it possible to perform SVN commands without changing the perspective?
Can I change the time zone settings to obtain the exact time as in the DB?
Is there a function that could give me the name of the plan I am in from within a plan step?
How can I pass external parameters to DQS plans?
How can I parameterize DQS components?
How can I parameterize a SQL query?
What password encryptions can I use?
How do I import data from MS Access and create Metadata?
How I can call, execute, terminate, or restart an online service (services .online file) using the command line?
Launch PDF
iWay Data Quality Server (DQS) Cheat Sheets Reference Guide
Functions
Basic String Functions
Regular Expression Functions
Conversion Functions
Datetime Functions
String Distance Functions
Set Distance Functions
Conditionals
Regular Expressions
Metacharacters Defined
Character Escapes
Character Classes
Launch PDF
iWay Data Quality Server (DQS) Upgrade Guide
Upgrading iWay Data Quality Server (DQS) Version 7 and 8
Server Configuration
Launch PDF
Data Profiler
Getting Started
Data Profiler Getting Started Guide
Introducing iWay Data Profiler
iWay Data Profiler Overview
Using iWay Data Profiler
Understanding the Console Layout and User Interface
Logging On to iWay Data Profiler
Navigating the Home Page
iWay Data Profiler Features
Pagination Buttons
Launch PDF
Documentation
iWay Data Profiler Installation and Configuration Guide
Prerequisites
Hardware Requirements
Operating System Requirements
Java Requirements
WebFOCUS Requirements
Application Server Requirements
Database Requirements
Other Requirements
Platform Matrix
Installing and Uninstalling iWay Data Profiler
Windows
UNIX or Linux for iWay Data Profiler Version 9.0.1
Post-Installation Database Configuration
Specifying Identical or Unique Schema Values With Corresponding User IDs and Passwords
Integrating iWay Data Profiler With the Web and Application Server
Overview
Integrating iWay Data Profiler With Apache Tomcat
Integrating WebFOCUS Client With Apache Tomcat
Overview
Creating the ibi_apps.xml File
Creating the ibi_help.xml File
Creating the ibi_html.xml File
Integrating iWay Data Profiler With WebFOCUS
Adding License Keys for WebFOCUS Active Technologies Reports
Configuring the WebFOCUS Client
Configuring Linux for WebFOCUS With Respect to iWay Data Profiler Version 9.0.1
Appending the iDP Folder to the Application Directories
Mapping iWay Data Profiler With WebFOCUS Reporting Server
Configuring Data Services
Configuring iWay Data Profiler With Databases
Configuring iWay Data Profiler With MySQL Server 5.5
Configuring iWay Data Profiler With MS SQL Server 2005 or MS SQL Server 2008
Configuring iWay Data Profiler With Oracle 11g
Configuring iWay Data Profiler With Teradata Server Version 13.10.00.14
Installation and Configuration Verification Process of iWay Data Profiler
Testing and Verifying the iWay Data Profiler Installation and Configuration
Configuring iWay Data Quality Server for Plans
Prerequisites
Configuring iWay Data Profiler Properties Using the Server Manager Console
Accessing the iWay Data Profiler - Server Manager Console
Configuring Data Profiler Settings
Configuring Logger Settings
Configuring Mail Settings
Configuring LDAP Settings
Enforcing Security in WebFOCUS
Enforcing Security in WebFOCUS
Starting WebFOCUS as a Windows Service
Starting WebFOCUS as a Windows Service
Configuring the Drill-Through Adapter in WebFOCUS
Prerequisites
Configuring the Drill-Through Adapter in WebFOCUS Using the Same Database Type
Configuring the Drill-Through Adapter in WebFOCUS Using Different Database Types
Configuring WebFOCUS, Apache Tomcat, and Oracle 11g for Multilingual Support Using UTF-8
Configuring WebFOCUS Reporting Server to Use UTF-8
Configuring WebFOCUS Client to Use UTF-8
Configuring Apache Tomcat to Use UTF-8
Configuring Oracle 11g to Use UTF-8
Using Test Cases to Ensure the Proper Installation of WebFOCUS
Testing Java Services
Testing APP HOLD
Resolving Java Virtual Memory Issues With WebFOCUS and iWay DQS
Java Virtual Memory Issues
Setting the Maximum Heap Size in WebFOCUS
Setting the Maximum Heap Size in iWay DQS
Installing and Configuring iWay Data Profiler on a Linux Platform With an Oracle RAC Database
Prerequisites
Installing iWay Data Profiler Version 9.0.1 on Linux
Post-Installation Configuration Tasks
Launch PDF
iWay Data Profiler User's Guide
Managing Data Quality Profiles
Overview
Displaying Data Quality Profiles
Creating Data Quality Profiles
Editing Data Quality Profiles
Viewing Data Quality Profiles
Exporting Data Quality Profiles
Deleting Data Quality Profiles
Viewing Process Results
Comparing Data Quality Profiles
Using Compare Data Quality Profiles
Managing Data Quality Metrics
Overview
Creating Data Quality Metrics
Editing Data Quality Metrics
Viewing Data Quality Metrics
Exporting Data Quality Metrics
Deleting Data Quality Metrics
Viewing Process Results
Comparing Data Quality Metrics
Using Compare
Managing Data Quality Plans for Data Quality Profiles
Plans for Data Quality Profiles
Viewing Data Quality Profile Process Results
Managing Plans for Data Quality Metrics
Plans for Data Quality Metrics
Viewing Data Quality Metrics Process Results
Managing WebFOCUS Custom Reports
Overview
Displaying Custom Reports
Creating Custom Reports
Editing Custom Reports
Viewing Custom Reports
Deleting Custom Reports
Viewing Process Results
Managing the Security Center
Overview
Managing Users
Managing Groups
Managing Roles
Managing Folders
Using the WebFOCUS appBranding Kit
Overview
Creating and Exporting Data Quality Profiles Using iWay Data Quality Server
Overview
Creating a DQS Plan Using the Profiling Step
Exporting the Data Quality Profile XML File
Creating and Exporting Data Quality Metrics Using iWay Data Quality Server
Overview
Creating a DQS Plan Using the Data Quality Metric Step
Importing the Data Quality Metric Text File to iWay Data Profiler
Generating Data Profiles Automatically Using the Data Profiler Service
Overview
Configuring iWay Service Manager to Support iWay Data Profiler Automation
Creating a Process Flow for iDP Automation
Configuring a Channel to View a Data Quality Profile
Drill-through Behavior Reference
Roll-up Behavior Reference
Generating Data Quality Profiles Automatically Using the Insert Into iDP Utility Service
Overview
Configuring the Insert Into iDP Utility to Support iWay Data Profiler Automation
Launch PDF
iWay Master Data Suite
Master Data Server
Getting Started
iWay Master Data Server (MDS) Getting Started Guide
Introducing iWay Master Data Server
What is iWay Master Data Server?
Why iWay Master Data Server?
What are the Various Components of iWay Master Data Server?
What is the Architecture of a Typical iWay MDS Solution?
What is the Model Explorer?
Installing iWay Master Data Server
What are the Available Data Quality (DQ) Application Packages?
Understanding the User Interface for iWay Master Data Server
iWay Master Data Server User Interface at a Glance
Understanding the Available User Interface Components
Configuring iWay Master Data Server
Managing Model Projects
Advanced Configuration
Working With Databases
Understanding Data and Process Modeling
Using the Plan Editor
Connecting to a Database
Debugging and Testing
Using the Web Console
Profiling Data
Creating a Profile
Column Analysis
Inputs and Roll Ups
Primary Keys
Foreign Keys
Business Rules
Bulk Profiling
Dependency Analysis
Configuring Source Management and Version Control
Sharing a Project Using SVN
Importing a Project Using SVN
Synchronizing Resources
Updating and Committing
Workbench Component Descriptions
Workbench Component Descriptions
Launch PDF
Documentation
iWay Master Data Server (MDS) Installation Guide
Introducing iWay Master Data Server
Overview
Prerequisites
Supported Software Platforms
Supported Storage Databases
Data Source Databases
Installing iWay Master Data Server
Distribution
Installation
License Key
Additional Configuration and Resources
Launch PDF
iWay Master Data Server (MDS) Tutorial
Introduction
Prerequisites
Overview
iWay Master Data Server (MDS) Sample Configuration
Opening a New Sample Project
General MDM Project Overview
Starting the Sample Solution
Cleansing, Matching, and Merging
Checking Batch Processing Results
DQ Firewall and Online Services
Stopping the Sample Solution
References
Launch PDF
iWay Master Data Server (MDS) Developer's Guide
Developer Tools
iWay Master Data Server (MDS) Model Project
iWay MDS Plan Editor
Project Description
Viewing the Preferences Node and Tabs
Connecting Systems
Using the Logical Model
Using Services
Outputting Interfaces
Viewing Transformations
Viewing Previews
Generating Documentation
Viewing Advanced Features
Viewing Files
Typical Developer Tasks
Creating a Logical Model
Importing a Logical Model
Creating an Instance Layer Model
Creating a Master Data Layer Model
Connecting a System
Adding a Batch Load Operation
Adding Reference Data
Adding an Export Operation
Adding a Data Event Handler and Publisher
Adding a Native Service Endpoint
Enabling a Particular Native Service
Adding an HTTP Listener
Using GenericTraversalMasterService
Impact of Changes to the Project
Connecting a System
New Instance Entity
Enabling Matching on an Instance Entity
New Master Entity
New Relationship on the Instance Layer
New Relationship on the Master Layer
New Reference Data
Using Reference Data
Launch PDF
iWay Master Data Server (MDS) Reference Guide
Introduction
iWay Master Data Server Components
NME Configuration
Server Components
Persistence Layer
Configuration Files Naming Convention
NME Model
NME Event Handler
NME Batch Interface
NME Native Services
NME Task Executor
NME Runtime Parameters
NME Persistent Storage
NME Engine Tables
NME Internal Columns
NME Unification Repository Tables
NME Data Browser Component
Server Component
Browser Configuration File
NME Web Console Extras
NME Engine
NME Data Browser
NME Integration
NME Integration With Other Components
NME Workflow Tasks
Launch PDF
iWay Master Data Server (MDS) Upgrade Guide 7
Introduction
Overview
Metadata Model Project Upgrade
Project Structure and File Naming Convention
Editing Configuration Files
iWay MDS Storage
Redundant and Obsolete Objects
Upgrade Notes and Known Issues
Launch PDF
iWay Master Data Server (MDS) Upgrade Guide 8
Introduction
Overview
Metadata Model Project Upgrade
Project Structure and File Naming Convention
Editing Configuration Files
iWay MDS Storage
Obsolete Files and Objects
Upgrade Notes and Known Issues
Launch PDF
Master Data Server
Getting Started
iWay Master Data Server (MDS) Getting Started Guide
Introducing iWay Master Data Server
What is iWay Master Data Server?
Why iWay Master Data Server?
What are the Various Components of iWay Master Data Server?
What is the Architecture of a Typical iWay MDS Solution?
What is the Model Explorer?
Installing iWay Master Data Server
What are the Available Data Quality (DQ) Application Packages?
Understanding the User Interface for iWay Master Data Server
iWay Master Data Server User Interface at a Glance
Understanding the Available User Interface Components
Configuring iWay Master Data Server
Managing Model Projects
Advanced Configuration
Working With Databases
Understanding Data and Process Modeling
Using the Plan Editor
Connecting to a Database
Debugging and Testing
Using the Web Console
Profiling Data
Creating a Profile
Column Analysis
Inputs and Roll Ups
Primary Keys
Foreign Keys
Business Rules
Bulk Profiling
Dependency Analysis
Configuring Source Management and Version Control
Sharing a Project Using SVN
Importing a Project Using SVN
Synchronizing Resources
Updating and Committing
Workbench Component Descriptions
Workbench Component Descriptions
Launch PDF
Documentation
iWay Master Data Server (MDS) Installation Guide
Introducing iWay Master Data Server
Overview
Prerequisites
Supported Software Platforms
Supported Storage Databases
Data Source Databases
Installing iWay Master Data Server
Distribution
Installation
License Key
Additional Configuration and Resources
Launch PDF
iWay Master Data Server (MDS) Tutorial
Introduction
Prerequisites
Overview
iWay Master Data Server (MDS) Sample Configuration
Opening a New Sample Project
General MDM Project Overview
Starting the Sample Solution
Cleansing, Matching, and Merging
Checking Batch Processing Results
DQ Firewall and Online Services
Stopping the Sample Solution
References
Launch PDF
iWay Master Data Server (MDS) Developer's Guide
Developer Tools
iWay Master Data Server (MDS) Model Project
iWay MDS Plan Editor
Project Description
Viewing the Preferences Node and Tabs
Connecting Systems
Using the Logical Model
Using Services
Outputting Interfaces
Viewing Transformations
Viewing Previews
Generating Documentation
Viewing Advanced Features
Viewing Files
Typical Developer Tasks
Creating a Logical Model
Importing a Logical Model
Creating an Instance Layer Model
Creating a Master Data Layer Model
Connecting a System
Adding a Batch Load Operation
Adding Reference Data
Adding an Export Operation
Adding a Data Event Handler and Publisher
Adding a Native Service Endpoint
Enabling a Particular Native Service
Adding an HTTP Listener
Using GenericTraversalMasterService
Impact of Changes to the Project
Connecting a System
New Instance Entity
Enabling Matching on an Instance Entity
New Master Entity
New Relationship on the Instance Layer
New Relationship on the Master Layer
New Reference Data
Using Reference Data
Launch PDF
iWay Master Data Server (MDS) Reference Guide
Introduction
iWay Master Data Server Components
NME Configuration
Server Components
Persistence Layer
Configuration Files Naming Convention
NME Model
NME Event Handler
NME Batch Interface
NME Native Services
NME Task Executor
NME Runtime Parameters
NME Persistent Storage
NME Engine Tables
NME Internal Columns
NME Unification Repository Tables
NME Data Browser Component
Server Component
Browser Configuration File
NME Web Console Extras
NME Engine
NME Data Browser
NME Integration
NME Integration With Other Components
NME Workflow Tasks
Launch PDF
iWay Master Data Server (MDS) Upgrade Guide 7
Introduction
Overview
Metadata Model Project Upgrade
Project Structure and File Naming Convention
Editing Configuration Files
iWay MDS Storage
Redundant and Obsolete Objects
Upgrade Notes and Known Issues
Launch PDF
iWay Master Data Server (MDS) Upgrade Guide 8
Introduction
Overview
Metadata Model Project Upgrade
Project Structure and File Naming Convention
Editing Configuration Files
iWay MDS Storage
Obsolete Files and Objects
Upgrade Notes and Known Issues
Launch PDF