11.5.0 Release Notes
What’s New in DataConnect 11.5
Installation
Known Issues
Eclipse Known Issues
Change Log
Change Log for 11.5.0.43
Change Log for 11.5.0.34
Change Log for 11.5.0.25
Change Log for 11.5.0.21
Change Log for 11.5.0.7
Introduction
DataConnect Architecture
Key Features
Integration Design Maintenance Flow
About This Manual
Intended Audience
Videos
Actian Support
Online Product Documentation
Technical Support
Installing DataConnect
Installation Packages
Installing DataConnect Studio IDE on Windows
Minimum System Requirements for Windows
Operating System and Software Requirements
Hardware Requirements
Runtime Engine Requirements
DataConnect Development Studio Requirement
Installing DataConnect Studio IDE on Windows
Uninstalling DataConnect Studio IDE on Windows
Installing DataConnect Studio IDE Site Plug-in for Eclipse on Windows
Installing DataConnect Studio IDE Site Plug-in on Windows
Post DataConnect Studio IDE Site Plug-in Installation Tasks on Windows
Upgrading DataConnect Studio IDE Site Plug-in on Windows
Installing DataConnect Studio IDE on Linux
Minimum System Requirements for Linux
Operating System and Software Requirements
Hardware Requirements
Runtime Engine Requirements
DataConnect Development Studio Requirement
Installing DataConnect Studio IDE on Linux
Uninstalling DataConnect Studio IDE on Linux
Installing DataConnect Site Plug-in for Eclipse on Linux
Installing DataConnect Site Plug-in on Linux
Post DataConnect Studio IDE Site Plug-in Installation Tasks on Linux
Upgrading DataConnect Studio IDE Site Plug-in on Linux
Installing DataConnect Runtime Engine
Installing DataConnect Runtime Engine on Windows
Uninstalling DataConnect Runtime Engine on Windows
Installing DataConnect Runtime Engine on Linux
Uninstalling DataConnect Runtime Engine on Linux
Installing DataConnect Runtime Engine on AIX
Minimum System Requirements for AIX
Installing DataConnect Runtime Engine on AIX
Configuring DataConnect Runtime Engine on AIX
Uninstalling DataConnect Runtime Engine on AIX
Installing DataConnect Integration Manager
Getting Started
Integration Toolset
Project
Maps
Processes
Portability
Launching DataConnect Studio IDE
Launching DataConnect Studio IDE On Windows
Launching DataConnect Studio IDE on Linux
Uploading License File
DataConnect License File Information
Welcome Page Links
Importing Templates or Prior Version Artifacts
DataConnect Compatibility Mode
Understanding DataConnect Studio IDE User Interface
Perspectives
List of Perspectives
Choosing a Perspective
UI Components in DataConnect Studio IDE Window
Editors
Menus
Navigators
Views
Toolbars
Cosmos.ini Settings
Mandatory Settings
Optional Settings
Best Practices
Architect the Solution
Business Requirements
Technical Requirements
Design for Reuse
Set Up Collaborative Workspaces
Create DataConnect Templates
Use Orchestration
Use Naming Conventions
Workspaces
Projects
Artifacts
Variables and Object Names
Macros and Constants
Translate Business Processes to DataConnect
Data Governance
Processes
Transformation Maps
Schema
Determine Infrastructure Requirements
Identify Connectivity Requirements
Message Component Framework SDK
Develop Your Templates
Leverage In-line Documentation
Process Designs
Artifact Properties
Script Comments
Search and Replace
Secure Your Integrations
Common Integration Techniques
Macros
Reusable Scripts
Constants
djMessage Objects
Parallelism and Concurrency
Data Validation
Event Condition Action rules
Data Enrichment
Temporary Targets
Lookups
Aggregating Data
Transformation and Process Objects
Web Service APIs
Custom Java objects
Time Zone Considerations
Important Date Functions
Localization Issues
Scripting Tips, Tricks, and Techniques
Performance
Accuracy
ECA Loops
Complex Text Parsing
Plan for Customization
Bulk or Batch Pattern Integrations
Files vs. Message Objects
Large File Splitting
Wide Files
Concurrency
RDBMS Transformation Maps
Source Data
Target Data
RDBMS Process Designs
SQL step
Application Step
Sessions
Message Pattern Integrations
DataConnect Studio API Invoker
Payload Size
Compression
Orchestration
RDBMS Considerations
API Limitations
Batch Size
Call Allocation
Concurrency
Optimize and Harden the Solution
Optimize
Use Sample Data
Manage Log Files
Analyze with Engine Execution Profiler
Test
Package and Deploy
Execute
Debug
Iterate
Importing Prior Version Projects and Artifacts
Importing Version 9 Workspace
Importing Version 10 Artifacts
Importing Artifacts from Folder
Setting Preferences
Enabling Data Integrator v9 Compatibility Mode
Setting General Preferences
Setting Workspace Preferences
Setting Execution Preferences
Setting Logging Preferences
Setting Error Handling Preferences
Setting Classpath Preferences
Setting Process Preferences
Setting Map Preferences
Setting Schema Preferences
Setting EZscript Preferences
Setting color preference for EZscript editor
Setting general preferences for EZscript Editor
Setting Macro Preferences
Setting Package and Deploy Preferences
Managing Workspaces, Projects, and Integration Artifacts
Managing Workspaces
Choosing a Perspective
Creating Projects
DataConnect Integration Artifacts and Editors
Adding Integration Artifacts
Creating a Map
Creating a Process File
Creating EZscript Library
Creating General EZscript Libraries
Creating EZscript Library Using the Lookup Wizard
Creating a Structured Schema
Creating a Folder
Viewing and Editing Properties for a Project or Artifact
Viewing and Editing Project Properties
Viewing and Editing Artifact Properties
Opening an Artifact
Importing Projects and Artifacts
Importing an Archive File
Importing Existing Projects into Workspace
Importing from File System
Importing Preferences
Importing Projects from a Folder or Archive
Importing Projects or Artifacts from Prior Versions
Importing Templates
Exporting Projects or Artifacts
Exporting Projects or Artifacts Using File System
Exporting Preferences
Exporting Projects and Artifacts as an Archive File
Copying and Moving Artifacts Between Projects
Copying Artifacts Within Projects
Deleting Projects and Artifacts
Searching and Replacing Text in Artifacts
Searching Artifacts Using Open Resource Window
Searching Artifacts Using Search Window
Search Results View
Replacing Text Matches
Managing Macro Sets and Macros
About Macro Definition Files
Specifying Macro Definition File
Managing Macro Sets
Creating Macro Sets
Duplicating Macro Set
Deleting Macro Sets
Viewing All Macro Sets
Reordering Macro Sets for Project, Map, or Process
Managing Workspace-level Macros
Creating Workspace-level Macros
Duplicating Workspace-level Macros
Copying Workspace-level Macros
Moving Workspace-level Macros
Deleting Workspace-level Macros
Adding Project-level Macro Sets
Managing Local Macros for a Map or Process
Execution Service Macros
Testing Execution Service Macros During Design
Using Macros
Pasting Macro in Map or Process
Logging Macro Values
Designing and Executing Processes
Exploring Process Editor
Step Builder Canvas Tab
Process Toolbar
Tool Box and Palette
Step Navigator
Thumbnail
Viewing Process File Properties
Building Processes
Creating a Process
Setting Execution and Logging Options
Adding Macro sets and Macros
Specifying EZscript Library, Global Variables, or Engine Profile
Adding Steps
Copying and Pasting Steps
Deleting Steps
Enabling and Disabling Steps
Adding Message Component Instances or SQL Sessions
Adding Message Component Instances
Manually Deploying Message Components
Adding SQL Sessions
Associating Instances or Sessions with Steps
Adding DJ Message Variable
Adding DJ Message Variable on Step Properties tab
Adding DJ Message Variable on the Configuration tab
Linking Steps
Testing Steps
Saving a Process
Configuring Processes
Configuring Macros
Managing EZscript Library Files
Adding EZscript Library Files
Deleting EZscript Library Files
Managing Global Variables
Managing Message Components
Adding Message Components
Editing Message Components
Deleting Message Component Instance
Configuring SQL Sessions
Adding SQL Sessions
Editing SQL Sessions
Duplicating SQL Sessions
Importing SQL Sessions
Deleting SQL Sessions
Configuring Execution Options
Configuring Logging Options
Configuring Engine Profiler
Process Steps and Associated Components
List of Process Step Components
Aggregators
Invokers
Iterators
Queues
Transformers
Validators
Adding Annotations
Aggregator Step
Aggregator Step Properties
Aggregator Step Components
EDI X12 Functional Group Aggregator
File Transfer Aggregator
JDBC WebRowSet Aggregator
Application Step
Application Step Properties
Decision Step
Evaluating Decision Step Expressions
Decision Step Properties
Example
Invoker Step
Invoker Step Properties
Invoker Step Components
DataFlow Invoker
Orchestration Invoker 1.0.0
Dynamic Map Invoker
SMTP Email Invoker
Query to WebRowSet Invoker
REST API Invoker
Salesforce Login Invoker
Salesforce Changed Data Query Invoker
Salesforce Bulk Loader
Siebel Login Invoker
JDBC Stored Procedure Invoker
WebRowSet Update Invoker
XQuery Invoker
Zip Invoker
Iterator Step
Iterator Step Properties
Iterator Step Components
EDI X12 Batch Transaction Iterator
EDI X12 Functional Group Iterator
EDI X12 Transaction Set Iterator
File Transfer Iterator
JDBC WebRowSet Iterator
XPath Iterator
Process Step
Process Step Properties
Queue Step
Queue Step Properties
Queue Step Components
POP3 Email Queue
IMAP Email Queue
File Folder Queue
FTP Queue
JMS Queue
Kafka Writer Queue
Websphere MQ Queue
MSMQ Queue
Script Step
Script Step Properties
SQL Step
SQL Step Properties
Start Step
Start Step Properties
Stop Step
Stop Step Properties
Transformation Step
Transformation Step Properties
Transformer Step
Transformer Step Properties
Transformer Step Components
File to Message Transformer
Message to File Transformer
Automatic Mapping Transformer
Doc Validator Step
Doc Validator Step Properties
Doc Validator Type Properties
Generating an Error File
Validator Step
Validator Step Properties
Validator Step Components
XML (DTD) Validator
XML Schema Validator
XSLT Step
XSLT Step Properties
Health Care Connectivity
About Health Care Integration
Before You Begin
Health Care Step Types
Health Care Components
HL7 Integration Schemas
Using Scripts in Processes
Using EZscript Libraries in Processes
Building Decision Step Expressions
Managing Queue Message Objects
Creating and Using Message Variables
Creating New DJMessage Variable
Assigning Result of DJComponent GetMessage Function to Message Variable
Using FindMessage Function
Validating and Running Processes
Validating Process Step
Validating Complete Process
Running the Process
Debugging Process
Designing and Executing Map
Exploring Map Editor
Viewing Map File Properties
Saving a Map as RTC File
Setting Up Source Data
Specifying Connector, Parts, and Properties
Confirming Source Schema
Defining and Applying Filters to Source Data
Defining Sort Options
Defining Sample
Browsing Source Data
Refreshing Source Schema
Clearing Source Connection
Saving Source Configuration
Setting Up Target Data
Specifying Connector, Parts, and Properties
Target Output Modes
Confirming Target Schema
Defining and Applying Filters to Target Data
Defining Update and Delete Key Options
Defining Sample
Browsing Target Data
Refreshing Target Schema
Clearing Target Connection
Saving Target Configuration
Managing Multiple Targets
Adding Multiple Targets
Editing Target
Deleting Target
Refreshing Map Connection Schema
Setting Up Multimode Target Connectors
Setting Up Multimode Target Connectors with Compatibility Mode Off
Setting Up Multimode Target Connector Using Multimode Wizard
Setting Up Multimode Target Connector Without Using Multimode Wizard
Setting Up Multimode Target Connector with Compatibility Mode On
Managing Constants
Adding Constants
Searching Constant
Deleting Constant
Example
Managing Intermediate Targets
Managing Lookups
Lookup Types
Adding Lookups
Deleting Lookups
Managing Temporary Targets
Adding Temporary Targets
Specifying New Schema for Temporary Target
Deleting Temporary Targets
Setting Up Reject Data
Confirming Reject Schema
Using Reject Data Browser
Clearing Reject Connection
Saving Reject Configuration
Using Map Navigator
Configuring Map
Configuring Macros
Using Script Library Files
Adding EZscript Library File
Removing EZscript Library File
Defining Global Variables
Configuring Map Events
Adding Map Event
Modifying Map Event
Deleting Map Event
Configuring Logging Options
Configuring Engine Profiler
Configuring Execution Options
Mapping Target from Source Data
Mapping Methods
Common Options
Mapping Fields Using Simple View
Mapping Fields Using Advanced View
JSON Map Advanced View - Nodes and Actions
XML Map Advanced View - Nodes and Actions
Common Tasks in Simple View and Advanced View
Dragging and Dropping Fields From Source to Target
Mapping Fields Automatically
Target File Mapping Scenarios
Custom Search Navigator
Managing Record Types in Advanced View
Adding Record Type
Deleting Record Type
Duplicating Record Type
Managing All Record Instances in Advanced View
Specifying Record Instance Properties
Deleting Root Record Reference
Managing Groups in Advanced View
Adding a Group
Deleting a Group
Managing Field Records in Advanced View
Adding Field Record
Managing Events and Actions
Events and Actions
Events and Actions for XML Maps (When v9 Compatibility Mode is Enabled)
Managing Events and Actions in Advanced View
Managing Record Rules in Advanced View
Managing Recognition Rulesets and Rules
Adding Target Record Write Condition Rules in Advanced View
Validating and Running Map
Map Connectors
Types of Connections
Native API Connections
Physical Data Connections
Raw Sequential Connection Process
Physical File Format Connection Process
Intermediate Import and Export Format Connections
Importing Through Intermediate Data
Exporting Through Intermediate Data
ODBC and Other Middleware Connections
Driver Installation
Text Box to Enter Driver Options
URI Connections
URI Support In DataConnect
Internet URL Format
URI Parameters
Escape Characters
Non-routable Addresses
Limitations
SQL Connections
Relational Database Management Systems (RDBMS)
Creating SQL Table Indexes and Primary Keys
Calling PL/SQL Stored Procedures
Passing Variables
Generating a Random Unique Identifier
Authentication
XML Support
Unknown Application or File Format Connections
Unknown File Format
Binary Data Types
Intermediate Methods to Connect to Data Formats
Using an Intermediate File Format
Alternative Connection Methods
Connecting Through Content Extractor Editor/CXL Scripts
Custom Report Reading Scripts
Additional Connectivity Details
Batch Response File
Data File Formats
Structured Formats
Semi-structured Formats
Unstructured Formats
Delimited ASCII
Determining Field Width in Characters or Bytes
Field Width in Characters
Field Width in Bytes
Cursors
Installing an ODBC Driver
Configuring ODBC Data Source
ODBC Connectivity Tips
Connecting to a Table
ODBC Driver Setup Error
Returning Data Types
Oracle Connectivity Guidelines
Oracle Client
Path
TNS name
Version
Upgrades
Table Names
Issues and Their Solutions
Oracle Database Global Transaction Support
XML Schema
XML Schema (MS XDR Biztalk)
Element and Attribute
XML Schema (W3C XSDL)
Hex Values
Encoding Reference
Constant Values for Encoding Parameters in EZscript
Customizing Character Mappings
International Components for Unicode
Determining Which Connector to Use
Flat File Connectors
Database Connectors
Components
Encoding and Oracle Databases
Example Use Case
Encoding EZscript Functions and Objects
Encoding Functions
File Functions
EZscript DJMessage Objects
Understanding Unicode and Other Encoding Types
UTF Format Encoding in Applications
Non-Unicode Connectivity
Unicode and Encoding Checklist
Installing Language Sets
Installing Character Sets
Encoding Tips
Troubleshooting Encoding Issues
Unicode 4.0 Limitations
Unicode 4.0 Character Encodings
Customizable ICU Encodings
Customizing Non-ICU Japanese Mappings
Byte Order Marks
HDFS Connectivity
Source and Target Map Connectors
General Connector Topics Explained
Connector-Specific Notes
Property Options/Connector Properties
AccountMate
Connector-Specific Notes
Property Options
Actian Avalanche
Prerequisites
Connector Properties
Supported Output Modes
Data Types
Actian Avalanche Multimode
Prerequisites
Connector Properties
Supported Output Modes
Data Types
Actian Extract
Connectivity Pointers
Connector Properties
Actian Ingres (ODBC 3.x)
Prerequisites
Connector Properties
Supported Output Modes
Data Types
Actian Vector
Prerequisites
Connector Properties
Supported Output Modes
Data Types
Actian Vector (Delimited)
Pre-requisites
Connector-Specific Notes
Connector Properties
Supported Output Mode
Data Type
Actian Vector Multimode
Prerequisites
Connector Properties
Supported Output Modes
Data Types
ActianX
Prerequisites
Connector Properties
Supported Output Modes
Data Types
ActianX Multimode
Prerequisites
Connector Properties
Supported Output Modes
Data Types
Actian Zen/PSQL v13
Prerequisites
Connector-Specific Notes
Connector Properties
Supported Output Modes
Data Types
Actian Zen/PSQL v13 Multimode
Prerequisites
Connector-Specific Notes
Connector Properties
Supported Output Modes
Data Types
Acucobol (ODBC 3.x)
ACUCOBOL-GT Version 7
Connector-Specific Notes
Property Options
Data Types
Adabas (NatQuery)
Multiple Record Structured Schemas Possible
Connector-Specific Notes
Property Options
Alpha Four
Connector-Specific Notes
Property Options
Apache Common Logfile Format
Apache Common Logfile Format Parameters
Property Options
Archive Queue
Step Actions
Properties
ASCII (Delimited)
Multiple Structured Schemas Possible
Delimited ASCII as Alternate Source or Target Connector
Using an External Schema to Override Source Structure
Using an External Schema to Override Target Structure
Delimiter Characters Occurring as Data within a Field
Connector-Specific Notes
Property Options
Field1IsRecTypeId
Length
Data Types
ASCII (Fixed)
Multiple Structured Schemas Possible
Connector-Specific Notes
Property Options
Data Types
Length
Alignment
Pad Character
Avro
Versions Supported
Operations
Data Types
Connect Information
Property Options
Limitations
Multimode Support
BAF
Connector-Specific Notes
Property Options
Data Types
Binary
Multiple Record Types Possible
Connector-Specific Notes
Property Options
Data Types
Binary (International)
Multiple Record Types Possible
Connector-Specific Notes
Binary (International) Unicode Support
Property Options
Data Types
Binary Line Sequential
Connector-Specific Notes
Property Options
Data Types
Btrieve 10
Btrieve Data Dictionary Files
Connector-Specific Notes
Property Options
Data Types
Clarion
Connector-Specific Notes
Limitations
Property Options
Data Type
Output Modes
Updating Clarion Data
Clipper
Connector-Specific Notes
Property Options
Data Types
Connectivity Pointers
Cloudscape (ODBC)
COBOL Flat File
Property Options
Data Types
Common Logfile Format Webserver
Connector-Specific Notes
Property Options
Data Junction Log File
Connector-Specific Notes
Property Options
DataEase
Connector-Specific Notes
Property Options
Data Types
DataFlex (ODBC 3.x)
DataFlex Connection Requirements
Required Configuration Files
Connector-Specific Notes
dBASE II, III+
Connector-Specific Notes
Property Options
Data Types
dBASE IV
Other dBASE IV Applications
Connector-Specific Notes
Property Options
Data Types
Derby
Derby Versions Supported
Properties
Operations and Entity Support
Data Types
Additional Information
Derby (Client)
Connector-Specific Notes
Property Options
Additional Properties
Data Types
Derby (Embedded)
Connector-Specific Notes
Property Options
Additional Properties
Data Types
DIF
Connector-Specific Notes
Property Options
Data Types
EDI (X12)
EDI Structure
Version Mismatch Errors
Recommended Practices
Limitations
Property Options
Data Type
EDIFACT
Connector-Specific Notes
Limitations
Property Options
Data Type
EDI X12 (eDoc)
EDI Structure
Version Mismatch Errors
Recommended Practices
Limitations
Connector Properties
Supported Output Mode
Data Type
EDIFACT (eDoc)
Connector-Specific Notes
Limitations
Connector Properties
Supported Output Mode
Data Type
Enable
Connector-Specific Notes
Property Options
Excel
Connector-Specific Notes
Excel v2, 3, 4 Property Options
Excel v5, v7 (95) Property Options
Excel v97 Property Options
Encoding
Encoding Notes
Special Notes about Excel Dates
Data Types
Length
Excel 2000
Special Considerations
Excel 2007, Excel 2010, and Excel (xlsx)
Properties
Operations
Data Types
Debugging Tips
Additional Information
Excel XP
Special Considerations
Connector-Specific Notes
Property Options
FIX
Limitations
Property Options
Data Type
Folio Flat File
Connector-Specific Notes
Property Options
Data Types
Foxbase+
Connector-Specific Notes
Property Options
Data Types
FoxPro
Connector-Specific Notes
Property Options
Data Types
GoldMine
Connector-Specific Notes
Property Options
GoldMine Import File (DBF)
Connector-Specific Notes
Property Options
Data Types
Additional Data Types
GoodData
Connector-Specific Notes
Property Options
Data Types
Additional Information
Operation
HIPAA
HIPAA Structure
Version Mismatch Errors
Schema File Required
Connector-Specific Notes
Property Options
Element Separators
Checking the Validity of HIPAA EDI Structures
HIPAA Transaction Set Synopsis
Other Considerations
HIPAA (eDoc)
Version Mismatch Errors
Schema File Required
Connector-Specific Notes
Property Options
Element Separators
Checking Validity of HIPAA EDI Structures
Other Considerations
Hitachi Hi-RDB (ODBC)
HL7
Schema File Required
Connector-Specific Notes
Property Options
Segment Terminators
Data Types
HL7 (eDoc)
Schema File Required
Connector-Specific Notes
Property Options
Segment Terminators
HTML
To read HTML data sources
Connector-Specific Notes
Property Options
Data Types
IBM DB2 9.7
Connectivity Pointers
Connector-Specific Notes
Property Options
Data Types
IBM DB2 9.7 Multimode
Connector-Specific Notes
Property Options
Data Types
IBM DB2 10
Connectivity Pointers
Connector-Specific Notes
Property Options
Data Types
IBM DB2 10 Multimode
Connector-Specific Notes
Property Options
Data Types
IBM DB2 Loader
Connector-Specific Notes
Property Options
Data Types
Length
Target Schema
IBM DB2 Universal Database 9.5
Connectivity Pointers
Connector-Specific Notes
Property Options
Data Types
Length
IBM DB2 Universal Database 9.5 Multimode
Connector-Specific Notes
Property Options
Data Types
Length
IBM Informix Dynamic Server 10
Connectivity Pointers
Connector-Specific Notes
Properties
IBM Informix Dynamic Server 11
Connector-Specific Notes
Property Options
Informix (ODBC 3.x)
Connector-Specific Notes
Informix-Online DS
Informix Client Installation
Limitations
Property Options
Informix-Online DS Multimode
Informix Client Installation
Limitations
Property Options
Data Type
Integration Log File
Connector-Specific Notes
Property Options
JSON
Connectivity Requirements
Property Options
Data Types
Additional Information
LDIF
Property Options
Lotus 123
Connector-Specific Notes
Property Options
Data Types
Length
Lotus Notes Structured Text
Connector-Specific Notes
Property Options
Data Types
MAILERS+4 (dBASE)
Property Options
Microsoft Dynamics AX 4
Limitations
Property Options
Debugging Tips
Source Schema
Target Schema
Type
Microsoft Dynamics CRM 4.0
Microsoft Dynamics CRM Versions Supported
Connector-Specific Notes
Connection Information
Properties
Operations
Entity Support
Data Types
Batch Response
FilterXML
Additional Information
Microsoft Dynamics GP 9 and 10
Before You Begin
Connectivity Pointers
Connector-Specific Notes
Property Options
Data Types
Additional Considerations
Microsoft IIS Extended Logfile Format
Connector-Specific Notes
Property Options
Microsoft SQL Azure
Connector-Specific Notes
Property Options
Data Types
Microsoft SQL Azure Multimode
Connector-Specific Notes
Property Options
Data Types
MUMPS (ODBC)
MySQL (ODBC 3.5)
Connector-Specific Notes
Navision Financials (ODBC 3.x)
Netezza
Connectivity Pointers
Connector-Specific Notes
Properties Options
Data Types
Length
NetSuite
Prerequisites
NetSuite Connector Properties
Data Types
Limitations
Additional Information
Filtering Records from NetSuite
NonStop SQL MX (ODBC)
Connector-Specific Notes
Property Options
Null
Connector-Specific Notes
Property Options
OData
Querying OData
Connector-Specific Notes
Property Options
Data Types
ODBC 3.5
Connectivity Pointers
Connector-Specific Notes
Property Options
Data Types
ODBC 3.5 Mass Insert
Connectivity Pointers
Connector-Specific Notes
Property Options
Data Types
Length
ODBC 3.5 Multimode
Connectivity Pointers
Connector-Specific Notes
Property Options
Data Types
Length
ODBC 3.x
Connectivity Pointers
Connector-Specific Notes
Property Options
Data Types
Length
ODBC 3.x Mass Insert
Connector-Specific Notes
Property Options
Data Types
Length
ODBC 3.x Multimode
Connector-Specific Notes
Property Options
Data Types
Length
Oracle 10g, 11g, and 12c
Other Oracle Connectors
Global Transactions Supported
Unicode Support
Connectivity Pointers
Connector-Specific Notes
Property Options
CodePage
Length
Data Types
Oracle 10g, 11g, and 12c Multimode
Other Oracle Connectors
Connectivity Pointers
Connector-Specific Notes
Property Options
CodePage
Length
Data Types
Oracle CRM On Demand
Supported Versions
Installation Requirements
Connectivity Requirements
Property Options
Supported Entities
Connector Specific Notes
Data Type Support
Debugging Tips
Oracle Direct Path 10g, 11g, and 12c
Other Oracle Connectors
Connector-Specific Notes
Property Options
CodePage
Data Types
Oracle Service Cloud
Supported API Version
Installation Requirements
Property Options
Supported Entities
Supported Operations
Data Type Support
Connector Specific Notes
Oracle Siebel CRM On Demand 12 and 14
Oracle Siebel CRM On Demand 14
Other Oracle Connectors
Schema Definitions
Supported Entities for Version 12
Supported Entities in Version 14
Logging SOAP Messages
Connectivity Pointers
Connector-Specific Notes
Property Options
Manipulating Parent and Child Relationships
Data Types
Oracle SQL Loader
Connector-Specific Notes
Property Options
Data Types
PayChex (DJF) Import
Connector-Specific Notes
Property Options
PayChex Structure
Data Types
Personal Librarian
Connectivity Pointers
Connector-Specific Notes
Property Options
Pivotal Business Server 5.9
Connectivity Pointers
Connector-Specific Notes
Property Options
Target Schema
Length
Data Types
Additional Information
PostgreSQL
Other PostgreSQL Connectors
Unicode Support
Connectivity Pointers
Connector-Specific Notes
Limitations
Property Options
Data types
Length
PostgreSQL Multimode
Unicode Support
Connectivity Pointers
Connector-Specific Notes
Limitations
Property Options
Datatypes
Length
PostgreSQL (ODBC 3.x)
PostgreSQL ODBC Driver Download
Installing Drivers and Troubleshooting Connections
Process and Transformation LogFile Parser
Connectivity Pointers
Connector-Specific Notes
Property Options
Record Types
Record Types for Process Steps
Record Types for Process Sessions
Record Types for Process and Transformation Messages
Record Types for Transformation-Only Runs
Transformation_Last_Error_Final record type
Progress (ODBC 3.x)
Installing Drivers and Troubleshooting Connections
RBase (ODBC 3.x)
Connector-Specific Notes
Property Options
Data Types
Red Brick
Connectivity Pointers
Connector-Specific Notes
Property Options
Data Types
Rich Text Format
Connector-Specific Notes
Property Options
Data Types
RightNow CX
Supported Versions
Installation Requirements
Property Options
Supported Entities
Supported Operations
Data Type Support
Connector Specific Notes
Salesforce
Connectivity Pointers
Upserts, Inserts, and Updates with Relationships
Connector-Specific Notes
Property Options
Data Types
Additional Information
SAP IDoc (eDoc)
Schema File Required
Property Options
Element Separator
SAP IDoc
SAP (DMI) with ODBC
Using the SAP (IDoc) connector
SAP Interface Repository and IDocs
Transferring an IDoc to Your Local Default Folder
IDoc Schemas
Mapping IDocs
Schema File Required
Property Options
Element Separator
Data Type
SAS Transport Format
ODBC and SAS
SAS Versions 7.x and 8.x
Large File Support
Connectivity Pointers
Connector-Specific Notes
Property Options
Data Types
SBT Acct (FoxPro)
Connector-Specific Notes
Property Options
Data Types
Sequential Binary
Connectivity Pointers
Property Options
Data Types
ServiceNow
Prerequisites
Data Types
Performance Notes
Limitations
Operators
SGML
Property Options
Data Types
SPLUS
Property Options
Data Types
SPSS
Property Options
Data Types
SQL Script
Connector-Specific Notes
Property Options
Length
Data Types
SQL Server 7 (OLEDB)
Connectivity Pointers
Connector-Specific Notes
Property Options
CursorType
Encoding Notes
Data Types
SQL Server 7 Mass Insert (OLEDB)
Connector-Specific Notes
Property Options
Encoding Notes
Length
Data Types
SQL Server 7 Multimode (OLEDB)
Connector-Specific Notes
Property Options
Encoding Notes
Data Types
SQL Server 2000
Connectivity Pointers
Connector-Specific Notes
Property Options
CursorType
Encoding Notes
Data Types
SQL Server 2000 Mass Insert
Connector-Specific Notes
Property Options
Encoding Notes
Data Types
SQL Server 2000 Multimode
Connector-Specific Notes
Property Options
Encoding Notes
Data Types
SQL Server 2005
Connectivity Pointers
Connector-Specific Notes
Property Options
CursorType
Encoding Notes
Data Types
SQL Server 2005 Mass Insert
Connector-Specific Notes
Property Options
Encoding Notes
Data Types
SQL Server 2005 Multimode
Connector-Specific Notes
Property Options
Encoding Notes
Data Types
SQL Server 2008
SQL Server 2008 Mass Insert
SQL Server 2008 Multimode
SQL Server 2012
Connectivity Pointers
Property Options
CursorType
Encoding Notes
Data Types
SQL Server 2012 Mass Insert
Connector-Specific Notes
Property Options
Data Types
SQL Server 2012 Multimode
Connector-Specific Notes
Property Options
Data Types
SQL Server 2016
Connectivity Pointers
Property Options
CursorType
Encoding Notes
Data Types
SQL Server 2016 Mass Insert
Connector-Specific Notes
Property Options
Data Types
SQL Server 2016 Multimode
Connector-Specific Notes
Property Options
Data Types
SQL Server BCP
Connector-Specific Notes
Property Options
Data Types
SWIFT
Schema File Required
Property Options
SWIFT (eDoc)
Schema File Required
Property Options
Sybase Adaptive Server 12.x and 15.x
Connector-Specific Notes
Property Options
Sybase Adaptive Server 12.x and 15.x Multimode
SYSTAT
Connector-Specific Notes
Property Options
Tape Drive Sequential
Connectivity Pointers
Property Options
Data Types
Teradata (Fastload)
Teradata FastLoad Utility
Connector-Specific Notes
Property Options
Data Types
Length
Text (Delimited - EDI)
Connector-Specific Notes
Property Options
Data Types
Alignment
Pad Character
Text (Delimited - EDIFACT)
Connector-Specific Notes
Property Options
Data Types
Length
Alignment
Pad Character
Unicode (Delimited)
Connector-Specific Notes
Property Options
Field1IsRecordType
Data Types
Length
Unicode (Fixed)
Supported Encoding
Property Options
Alternate Tip on FieldSeparator Property
Additional Information About Encoding
Data Types
USMARC
Property Options
Variable Sequential (MVS)
Connector-Specific Notes
Property Options
Data Types
Variable Sequential (Record-V UniKix)
Connector-Specific Notes
Property Options
Data Types
Variable Sequential (SyncSort)
Connector-Specific Notes
Property Options
Data Types
Variable Sequential (User Defined)
Connector-Specific Notes
Property Options
Data Types
Velocis (ODBC 3.x)
Installing Drivers and Troubleshooting Connections
Connector-Specific Notes
Visual dBASE 5.5
Connector-Specific Notes
Property Options
Data Types
Visual FoxPro
Connector-Specific Notes
Visual FoxPro (ODBC)
XDB (ODBC 3.x)
XML
Property Options
Limitations
XML Support
XML DOM Support
XML-DMS
Namespace support
Property Options
Data Types
Error Conditions, Handling, and Recovery
Using a DJMessage Object as a Source or Target
Multiple Element Instances
Deprecated Connectors
Managing Schemas
Creating Schemas
Creating Schema Manually
Creating Schema Using Metadata Connector
Types of Metadata Connectors
Creating Schema Using External Connection
Creating Schema From Another Schema
Creating Schema Using Data Parser
Using Data Parser
Data Parser Display Mode Options
Hex Values Reference Chart
Creating Subset Schema From Master Schema
Exploring Schema Editor
Nodes in Schema Design Editor
Nodes in v9 Compatible XML Schema
Viewing Schema File Properties
Managing Records
Adding Records in JSON Schema
Duplicating Records in JSON Schema
Deleting Records in JSON Schema
Adding Records in XML Schema
Duplicating Records in XML Schema
Reordering Records in XML Schema
Deleting Records in XML Schema
Managing Fields in Records
Adding Fields to a Record in JSON Schema
Deleting Fields in a Record in JSON Schema
Reordering Fields in a Record in JSON Schema
Adding Fields to a Record in XML Schema
Deleting Fields in a Record in XML Schema
Reordering Fields in a Record in XML Schema
Managing Rules for a Record
Adding Recognition Rule in JSON Schema
Deleting Recognition Rule in JSON Schema
Reordering Recognition Rule in JSON Schema
Adding Recognition Rule in XML Schema
Deleting Recognition Rule in XML Schema
Reordering Recognition Rule in XML Schema
Adding Validation Rule in XML Schema
Updating Schemas
Managing Document Schemas
About E-Documents
E-Document Types
EDI X12
HIPAA
EDIFACT
SWIFT
Document Schema Designer Workflow
Creating Document Schema File
Viewing or Editing Document Schema File Properties
Viewing or Editing Document Schema File Properties Using Properties tab
Viewing Document Schema File Properties Using Right-click Menu
Viewing Document Schema File in Schema Viewer tab
Editing Document Schema File
Editing Values for Node Properties
Inserting Node
Deleting Node
Undo/Redo Insert or Delete Node
Copying/Pasting Node
Linking Library Files
Linking Library Files With Document Schema File
Importing Segments from Segment Library File
Editing Library Files
Editing Segment Library Files
Editing Field Library Files
Editing Codeset Library Files
Creating Sample Data File
Creating Schema From Data Instance
Creating Abstract Message Definition
Scripting
EZscript Scripting Language
EZScript Editor
Accessing EZscript Editor
Exploring EZscript File in Tab View
Exploring EZscript Expressions Window
Using Content Assist
Adding or Removing Bookmarks
EZscript Libraries
Using DJImport/DJExport Object Connection Wizard
Creating New DJImport or DJExport Object
Using Existing DJImport or DJExport Object
Writing Expressions
Basic Elements of an Expression
Operands
Operators
Parentheses
Functions
Statements
Scripting Keywords
Precedence in Evaluating Expressions
Commenting Out Code
Quotation Marks in Expressions
Specifying Field Names in Expressions
Continuing Lines in Expressions
Regular Expressions
Special Characters
Literal Values of Special Characters
Functions and Operators
Escaping Hex Values
Literal Values in Expressions
Using Scripts to Perform Specific Tasks
Parsing a Name Field Into Separate Fields
Example of Rearranging Order of a Name
Parsing a Source Field by Character
Specifying Ranges in Expressions
Converting Dates
Using Masks to Convert Two-Digit Dates
Mask Type for Two-Digit Dates, "YYdddd"
Filtering by Date
Setting Up Picture Masks
Formatting Boolean Data
Formatting Date/Time Data
Validating Data Types in Expressions
Calling External DLLs
Calling DLLs using a Declare statement
Examples of Calling External DLLs
Capturing Transformation Metadata
Handling Invalid Data
Retrieving Source and Target Metadata
Using DJRecord and DJField Objects to Access Metadata
Retrieving and Setting LogFile and LogMask Properties
Example
Setting the Scope of Functions
Script Functions
Script Functions A-F
Abort Function
Abs Function
Add1Fmt Function
Add1Part Function
Add2Part Function
Asc Function
B64Decode Function
B64Encode Function
Bin Function
CBool Function
CByte Function
CDate Function
CDbl Function
CDec Function
ChangeDirectory Function
ChangeFromUnicode Function
ChangeToUnicode Function
CharCount Function
Choose Function
Chr, Chr$ Functions
CInt Function
Clean Function
ClearMacro Function
CLng Function
Compare Function
CreateObject Function
CSng Function
CStr Function
CurDir Function
Date, Date$ Functions
DateAdd Function
DateConvert Function
DateDiff Function
DatePart Function
DateSerial Function
DateValMask Function
DateValue Function
Day Function
DefineMacro Function
DeleteMessage Function
Discard Function
Environ Function
Eval Function
Exp Function
Extract Function
FieldAt Function
FileAppend Function
FileCopy Function
FileDateTime Function
FileDelete Function
FileExists Function
FileLen Function
FileList Function
FileRead Function
FileReadLine Function
FileRename Function
FileWrite Function
Filter Function
FindMessage Function
Fix Function
FlushLog Function
Format, Format$ Function
Script Functions G-M
GetDirectory Function
GetObject Function
GetThreadID Function
GSub Function
Hex Function
Hour Function
IIf Function
ILAddrow Function
ILBuild Function
ILClear Function
ILFirstKey Function
ILNextKey Function
ILookup Function
ILRemoveRow Function
InitCaps Function
InputBox, InputBox$ Functions
InStr Function
InStrRev Function
Int Function
IsArray Function
IsDate Function
IsDirectory Function
IsFile Function
IsMacroDefined Function
IsNull Function
IsNumeric Function
IsObject Function
Join Function
LBound Function
LCase, LCase$ Functions
Left, Left$ Functions
LeftB Function
Len Function
Log10 Function
Log Function
LogMessage Function
LTrim, LTrim$ Functions
MacroExpand Function
MacroValue Function
MakeDirectory Function
Mid, Mid$ Functions
Minute Function
Month Function
MsgBox Function
Script Functions N-Z
NamePart Function
Now Function
Null Function
Oct Function
Parse Function
ParseXMLFile Function
ParseXML Function
Print Function
RecordAt Function
Reject Function
RemoveDirectory Function
Right, Right$ Functions
RightB Function
Rnd Function
Round Function
RTrim, RTrim$ Functions
Second Function
Serial Function
Sgn Function
Shell Function
SignFlip Function
Sleep Function
SortArray Function
Space, Space$ Functions
Split Function
Str, Str$ Functions
StrComp Function
String, String$ Functions
StrReplace Function
StrReverse Function
Sub Function
Switch Function
Terminate Function
TestMask Function
Time, Time$ Functions
TimeSerial Function
TimeValue Function
TLookup Function
Transliterate Function
Trim, Trim$ Functions
UBound Function
UCase, UCase$ Functions
UTF8Decode Function
UTF8Encode Function
Val Function
ValMask Function
Weekday Function
Xlate Function
Year Function
Script Operators
Arithmetic Operators
Multiply (*) Operator
Add (+) Operator
Difference (-) Operator
Integer Division (\) Operator
Numeric Division (/) Operator
Exponent (^) Operator
Mod Operator
Assignment (=) Operator
Assign (=) Operator
Comparison Operators
Less Than (<) Operator
Greater Than (>) Operator
Less Than or Equal To (<=) Operator
Greater Than or Equal To (>=) Operator
Does Not Contain (!~) Operator
Equals (==) Operator
Does Not Equal (<>) Operator
Concatenation (&) Operator
Concatenate (&) Operator
Logical Operators
And Operator
Contains (~) Operator
Or Operator
Not Operator
Like Operator
Important Pattern Matching Rules
Recognition Rule Operators
Any Value Operator
Between Operator
Like Operator
Regular Expression Operator
Script Statements
Using DJX to Create SQL Statements
Dynamic SQL Statements
DJXBegin and DJXEnd
Source Query Statement
Flow Control Statements
ElseIf Statement
For...Next Statement
For Each...Next Statement
If...Then...Else Statement
Option Explicit Statement
Option FieldExplicit Statement
Option FieldImplicit Statement
Option Implicit Statement
Select Case...End Case Statement
While...Wend Statement
Option Math Statements
Option Math Fast Statement
Option Math Precise Statement
Option Math Strict Statement
Run-Time Error Trapping Statements
GoTo Statement
On Error GoTo Statement
On Error Resume Next Statement
Resume Label Statement
Resume Next Statement
Resume Statement
Declare Statement
Dim Statement
Function Statement
Global Statement
Include Statement
Option Base Statement
ReDim Statement
Return Statement
Variables
Scoping Variables
Scope Levels
Local Scope Notes
Public Scope Notes
Guidelines for Naming Variables
Variant Data Type
Array Variables
Referencing Elements in Arrays
Declaring Arrays
Storing Data in Arrays
Retrieving Data from Arrays
Clearing Variables and Array Elements
Managing Variables
Adding Global Variables
Editing Global Variables
Importing Global Variables
Deleting Global Variables
Script Objects
Object Properties
Read Write Abilities of Object Properties
Object Operators
Object Variables
Declaring Object Variables
Internal Object Variables for Mapping
Err Object Variable
DJRecord Object Type
Properties
Methods
Operators
DJField Object Type
Properties
DJImport and DJExport Object Types
Properties
Methods
Operators
Examples of DJImport Object Usage
DJExport Object Type Notes
Example of DJExport Object Type Usage
DJRowSet Object Type
Properties
Methods
Operators
DOMDocument Object Type
Properties
Methods
Operators
DOMNode Object Type
Properties
Methods
Operators
DJComponent Object Type
Messaging Support
Properties
Methods
Operators
DJMessage Object Type
Methods
Properties
Operators
Using a DJMessage Object with a Map
Creating Map Project Files
Creating a Process with a DJMessage Object
Intializing a DJMessage Object
Adding a Transformation Step to a Process
Linking Steps in a Process
Creating a Configuration and Running a Process
Using DJMessage and DJComponent Objects in Expressions
Examples
RFH Header Support: Websphere MQ
RFH Header Guidelines and Properties
RFH2 Header Guidelines and Properties
Specifying RFH and RFH2 Headers
Websphere MQ Header Support
Supported Header Types
Examples
Java Objects in Scripts
Class Objects
Transformation Object
Project Object
Properties
Errors
Examples
Script Troubleshooting
Novice Troubleshooting Suggestions
Use the most efficient function for your task
Understand the difference between syntax errors and errors in logic
Use comments to document your expressions
Intermediate to Advanced Suggestions
Assign a variable in the code to speed up your transformations
Use the Option Explicit statement
Use functions that signal errors in processing
Use Resume and Resume Next appropriately
Use the correct operator for the job
Learn about flow control for faster processing
Stack Overflow
Example 1 (Incorrect)
Example 2 (Correct)
64-Parameter Limitation in Function Arguments
Expression Tester Utility
Using the Expression Tester
Using Flags
Debugger Commands
Validating Data
Validating Data In Map Editor
Validating Data In Process Editor
Validating Data Using DjValidator Standalone Utility
Return Codes
Error Message Format
Using Extract Editor
Data Extraction Process
Creating Extract Editor File
Extract Editor
Extract Editor Toolbar Options
Viewing Extract File Properties
Configuring Extract Editor Options
Defining Line Styles
Adding Line Styles
Line Style Icons
Editing Line Style
Deleting Line Style
Reordering Line Styles
Defining Fields
Adding Field Definition
Editing Field Definition
Deleting Field Definition
Assigning Fields to Accept Records
Managing Accept Record’s Field Layout
Browsing Data
Parsing Data Automatically
Generating Extract Script
Using Extract Script in Map Editor
Other Features
Undo/Redo Operation
Finding Content
Viewing Line Style Matches
Status Bar Information
Meta Characters supported in Regular Expression
Using Content Extraction Language
Types of Text Files Supported by CXL
Types of Operations that CXL Can Perform
Use of Content Extraction in the Integration Platform
Script Examples
CXL Quick Reference
CXL Scripts
Basic Syntax
Script Structure
Script Execution
Script Licensing
A Simple Script Example
Language Elements
CXL Character Set
Keywords
Numeric and String Constants
Variables and Fields
User-Defined Variables
Built-in Variables
Field Variables
Variable Typing and Conversion
Operators
Arrays
One-Dimensional Arrays
Associative Arrays
Multidimensional Arrays
Array Iteration
Functions
Built-in Functionality
User-Defined Functions
Rules and Limitations for Variables in a User Defined Function
Variables Definitions
Return
Pattern Matching and Action Statements
CXL Patterns
BEGIN { statements }
END { statements }
CATCHUP { statements }
Expressions in Patterns
Regular Expression
/regular expression/ { statements }
Metacharacters
Comparison Expressions
CXL Comparison Operators used in Comparison Expression Patterns
Actions and Statements
Expressions in Statements
Comment Statements
Reinitialize Statement
Assignment Statements
Catchup Statements
Control Statements
Output Statements
Integrating with Map Designer
Map Designer Setup
Source Type
Source Data File
CXL Script
Map Designer Results
Connect
Process Script
Refresh Script
Source Data Browser and Source Schema
DJXLPACK - Script Compressing and Encoding
Script Errors and Debugging Tips
Syntax Errors
Logic Errors
Debugging Techniques
Trace
Comments
Logmessage
Source Data Browser
Language Syntax and Examples
!=
!~
# comment
$
$n
&&
*
+
+=
-
.
/
/ regular expression /
<
<=
=
= =
>
>=
?
{ and }
[ and ]
\
^
||
~
in
|
r1r2
abort;
accept explist;
asc (string);
BEGIN { statements }
break;
catchup on;
catchup off;
CATCHUP { statements }
Chr (n)
cleararray ( array );
clearvars;
EBCDIC
ENCODING
END { statements }
Fix (number)
for ( index in array ) { statements }
gsub ( reg, sub, var );
if ( condition ) { statements } else { statements }
IFS
ILS
InitCaps (string)
Int (number)
IsNumeric (value)
LCase (strexpr)
Left (strexpr, n)
length ( var );
logmessage ( warningtype, format, parm1, parm2 );
ltrim ( var );
NamePart ("[h] [f] [m] [mi] [l] [t]", "string")
Part Description
NF
NR
readahead ( num );
REGPOS
REGLEN
reject;
Right (strexpr,n)
rtrim ( var );
Sgn (number)
shift;
skip ( num );
Space (number)
split ( var, array, fs );
String (number, string)
sub ( reg, sub, var );
substr ( var, pos, len );
TABS
TRACE ON
TRACE OFF
Transliterate (source_char_set, target_char_set, string)
trim ( var );
UCase (strexpr)
Val (string)
var [ num ]
var ( j k )
while ( condition ) { statements }
Script Examples
Example Script 1: Fixed-Format Report
Example Script 2: Multicolumn Record Reports
Example Script 3: Tagged Reports
Example Script 4: One-To-Many Item Reports
Example Script 5: Multirecord Type Hierarchical Reports
Example Script 6: User Defined Functions, Arrays, and Loops
Using Engine Profiler
Creating Profile Output File
Viewing Profile Output File
Statistics Tab
Iteration and Time Histogram Tabs
Call Graph Tab
File Format of the Profile Output File
Question
Node Info Blocks
Packaging and Deploying Integration Artifacts
Specifying Package File Location
Creating a Package (.djar File) When Compatibility Mode is Disabled
Creating a Package (.djar File) When Compatibility Mode is Enabled
Deploying Design Artifacts
Specifying Integration Manager Connection Preferences
Deploying Design Artifacts to Integration Manager
Using Runtime Engine
Invoking Runtime Engine Using CLI
Running Multiple DataConnect Versions
Runtime Engine Command Line Interface
Command Line Syntax and Usage
Running a Map
Running a Process
Running Multiple Maps or Processes
Running a Map or Process in djar
Running a Map or Process (XML)
Running Multiple Maps and Processes (XML)
Specification Files
Additional Information
Quotes and Escape Characters
Command Line Options
Global Options
Map Options
Process Options
Command Line Options (XML Files)
Error Codes and Messages
Using Design Templates
Template Location
dc-templates Content
Prerequisites
Importing Templates Automatically
Importing Templates to an Existing Workspace
Importing or Copying Templates After Downloading from GitHub
Modifying Macro Definition File
Start Here
Available Templates
Non-template Resources
Error Codes and Message
Types of Errors and Log Messages
Error Log Messages
Error Model for the Integration Components
Scenario 1
Scenario 2
Scenario 3
Viewing the Error and Event Log File
Transformation Log Codes
Transformation Engine Error Codes
Error Messages Related to Transformations
Transformation Engine Error Return Codes
Base Transformation Processing Return Codes
Transformation Engine Error Return Codes (Deprecated)
Process Engine Error Codes
Error Handling in the Process Engine
Process Engine Error Message Return Codes
Scripting Language Error Codes
Run-Time Error Values
Integration Language Run-Time Errors
Engine Command Line Interface Error Codes
Types of Errors Returned by the Command Line Interface
Runtime Engine Command Line Interface Error Messages
Message Component Framework Engine Error Codes
Troubleshooting
Troubleshooting Tips
Problems and Solutions
Unable to launch DataConnect or displays an error while creating or opening artifacts.
Not able to view the default views and editors
DataConnect project and artifact menus are not displayed in the new toolbar drop-down
Artifacts do not open in the correct editor
A big red X is displayed in an editor. Also, when you go to create an artifact, either nothing happens or artifact is invalid
Performance has deteriorated for both maps and processes
Unable to view Macro resolution
Unable to connect to a source or target
Huge log file size
Error during command line execution
Temporary projects appear in the Project Explorer
Unable to run a process that runs a transformation
Frequently Asked Questions (FAQs)
Can I use previous versions including Data Junction or Data Integrator?
What APIs are available?
Where can I find the Java SDK?
Has the scripting language changed?
Does the engine still support version 9 djengine commands?
Are 32-bit operating systems still supported?
What version of Java is supported?
Is multi-threading supported?
Does the Expression Results control panel still work?
Is the engine execution profiler still available?
What are the deployment options for runtime?
Does Change Source and Change Target still work?
Can the metadata be accessed and edited directly?
Are there any new features from Data Integrator version 9?
Are the e-Document connectors like EDI, HIPAA, HL7, and SWIFT still supported?
Is there a Developer Community?
Are third party source control systems supported?
What different types of life cycle management or versioning features are available?
Is Integration Hub (iHub) still supported?
When will DataConnect version 10 integrations be supported?
Are Joins and the Join Designer still supported?
Does Content Extractor Editor (earlier called as Extract Schema Designer work in version 11?
Appendix A- CXL Quick Reference
Basics
Variables and Fields
Built-in Variables
Field Variables
Built-in Functions
Operations
CXL Patterns
Regular Expression Summary
Statements in Actions
11.5.0 Release Notes
Statements in Actions
This site works best with JavaScript enabled