wwparcel.html

Release Notes for DataConnect 12.1
- What's New for DataConnect 12.1
- Known Issues
Change Log
- Change Log for 12.1 (Build Number 12.1.0-46)
- Change Log for 12.1 (Build Number 12.1.0-38)
- Change Log for 12.1 (Build Number 12.1.0-24)
- Change Log for 12.1 (Build Number 12.1.0-20)
- Change Log for 12.1 (Build Number 12.1.0-9)
Introduction
- Actian DataConnect Architecture
- Key Features
- Integration Design Maintenance Flow
- About This User Guide
- Intended Audience
- Videos
- Actian Support
Getting Started
- Integration Toolset
- Launching the DataConnect Studio IDE
- Creating Your First DataConnect Integration
- Importing Templates or Prior Version Artifacts
- Actian DataConnect Studio User Interface
  - Actian DataConnect Perspectives
    - Choosing a Perspective
    - Resetting a Perspective
  - Actian DataConnect Studio UI Components
- Cosmos.ini Settings
Best Practices
- Architect the Solution
  - Business Requirements
  - Technical Requirements
- Design for Reuse
- Develop Your Templates
- Common Integration Techniques
- Bulk or Batch Pattern Integrations
- Message Pattern Integrations
- Optimize and Harden the Solution
- Customizing DataConnect
  - Limiting Workspace Refresh
Importing Prior Version Projects and Artifacts
- Importing Version 9 Workspace
- Importing Version 10 Artifacts from an Exported v10 Zip
- Importing Projects Directly from Actian DataConnect 10
- Importing Integrations and Packages from v10 Integration Manager
- Importing Artifacts from Folder
Setting Preferences
- Overview
- Setting Appearance Preferences
- Setting Data Profile Preferences
  - Setting Data Profile Metric Defaults
- Setting EZscript Preferences
  - Setting General Preferences for EZscript Editor
- Setting Execution Preferences
- Setting General Preferences
- Setting Macro Preferences
- Setting Map Designer Preferences
  - Setting Field Columns Preferences
- Setting Package and Deploy Preferences
  - Setting Integration Manager Preferences
- Setting Process Preferences
- Setting Schema Preferences
Managing Workspaces, Projects, and Integration Artifacts
- Managing Workspaces
- Creating Projects
- Integration Artifacts and Editors
- Adding Integration Artifacts
- 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
- Exporting Projects or Artifacts
- Copying and Moving Artifacts Between Projects
- Copying Artifacts Within Projects
- Deleting Projects and Artifacts
- Searching and Replacing Text in Artifacts
Managing Macro Sets and Macros
- Macro Definition Files
  - Creating Macro Definition Files
  - Switching Macro Definition Files
- Macro Sets
- Macros
- Execution Service Macros
  - Testing Execution Service Macros During Design
- Using Macros
Designing and Executing Processes
- Exploring Process Editor
- Building Processes
- Configuring Processes
- Health Care Components and Schemas
- HL7 Integration Schemas
- Using Scripts in Processes
- Validating Processes
  - Validating a Process Step
  - Validating a Complete Process
- Running Processes
  - Debugging a Process
- Troubleshooting Process Execution
Process Steps and Components
- List of Process Steps
- List of Process Step Components
- Deprecated Components
- Aggregator Step
- Application Step
- Decision Step
- Invoker Step
- Iterator Step
- Process Step
- Queue Step
- Script Step
- SQL Step
- Start Step
- Stop Step
- Alt-Transformation Step
- Transformation Step
- Transformer Step
- Validator Step
- XSLT Step
Integrating Health Care Data
- Supported Health Care Standards
- Health Care Components and Schemas
- HL7 Integration Schemas
Using Data Profiler Engine
- Command Line Syntax and Usage
Designing and Executing Data Profile
- Exploring Data Profile Editor
- Creating a Profile Using Data Profile Wizard
- Creating a Profile Without Using Wizard
- Specifying Source Connection for Data Profile
- Specifying Profile
- Specifying Target Connection for Data Profile
- Configuring Data Profile
- Validating and Running Profile
  - Validating the Profile Results
  - Running Profile
    - Viewing Pass, Fail, and Drill Down Output
    - Rule and Their Resulting Outputs
- Troubleshooting Profile Execution
- Setting Rule Parameter Defaults
- Rule and Parameter Reference
Designing and Executing Map
- Exploring Map Editor
- Creating a Map Using New Map Wizard
  - Creating a Map Without Joins Using Map Wizard
  - Creating a Map With Joins Using Map Wizard
- Creating a Map Within Process Designer
- Creating a Map Without Using Map Wizard
- 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
  - Clearing Source Connection
  - Saving and Reusing Source Configuration
- Setting Up Join Sources
  - Specifying New Schema for Join
  - Deleting Join
- Setting Up Target Data
  - Specifying Connector, Parts, and Properties
    - Target Output Modes
  - Confirming Target Schema
  - Defining and Applying Filters to Target Data
  - Defining Sample
  - Browsing Target Data
    - Find Dialog
  - Clearing Target Connection
  - Saving and Reusing Target Configuration
  - Managing Multiple Targets
- Viewing Map File Properties
- Saving a Map as RTC File
- Saving and Reusing a Connection
- Refreshing Map Connection Schema
- Reconnecting Target Connector
- Setting Up Multimode Target Connectors
  - Setting Up Multimode Target Connectors
    - Setting Up Multimode Target Connector Using Multimode Wizard
    - Setting Up Multimode Target Connector Without Using Multimode Wizard
- Managing Constants
  - Adding Constants
  - Searching Constant
  - Deleting Constant
  - Example
- Managing Intermediate Targets
  - Managing Lookups
  - Managing 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
  - Configuring Logging Options for a Map
  - Configuring Engine Profiler
  - Configuring Execution Options for a Map
- 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
  - Common Tasks in Simple View and Advanced View
  - Dragging and Dropping Fields From Source to Target
  - Using Map Recommend
  - Target File Mapping Scenarios
  - Custom Search Navigator
  - Managing Record Types in Advanced View
  - 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
  - Managing Record Rules in Advanced View
    - Managing Recognition Rule sets and Rules
  - Adding Target Record Write Condition Rules in Advanced View
- Validating Maps
  - Validating a Map
- Running Maps
- Troubleshooting Map Execution
- Migrating Connectors in an Existing Map
Map Connectors
- Types of Connections
- Source and Target Map Connectors
- Deprecated Connectors
Encoding Reference
- Constant Values for Encoding Parameters in EZscript
- Determining Which Connector to Use
- Encoding EZscript Functions and 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
- Determining Field Width in Characters or Bytes
  - Field Width in Characters
  - Field Width in Bytes
- Hex Values
Managing Schemas
- Creating Schemas
- Exploring Schema Editor
- Updating Schemas
Scripting
- EZscript Script 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
- Using Scripts to Perform Specific Tasks
- Setting the Scope of Functions
- Script Functions
- Script Operators
- Script Statements
- Variables
- Script Objects
- Script Troubleshooting
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
- Defining Fields
- 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
Using Content Extraction Language
- Supported Text Files
- Supported Operations
- Use of Content Extraction in the Integration Platform
  - Script Examples
- CXL Scripts
- Language Elements
- Variables and Fields
- Arrays
- Functions
- Pattern Matching and Action Statements
- Integrating with Map Designer
  - Map Designer Setup
  - Map Designer Results
- DJXLPACK - Script Compressing and Encoding
- Script Errors and Debugging Tips
- Language Syntax and Examples
- Script Examples
- CXL Quick Reference
Using Engine Profiler
- Enabling Engine Profiling
- Viewing Profile Output File
- File Format of the Profile Output File
Packaging and Deploying Integration Artifacts
- Specifying Package File Location
- Creating a Package
  - Package Inventory File
  - Package (.djar) File
    - Package Inventory Changes Pop-up Message
- Deploying Design Artifacts
  - Specifying Integration Manager Connection Preferences
  - Deploying Design Artifacts to Integration Manager
Using Runtime Engine
- Invoking Runtime Engine Using CLI
- Running Multiple Actian DataConnect Versions
- Runtime Engine Command Line Interface
- Runtime Engine Command Line Syntax and Usage
- Command Line Options
- Djar Utility
- Error Codes and Messages
Using Design Templates
- Template Location
- Getting Started with Templates
- Importing Templates Automatically
- Importing Templates Manually
- Modifying Macro Definition File
- Non-template Resources
Error Codes and Messages
- Engine Error Codes
- Scripting Language Error Codes
- Message Component Framework Engine Error Codes
SDK Developer Guides
- DataConnect SDK
- Client SDK
- Message Component Framework SDK
Troubleshooting
- Unable to load the Welcome page after installing new version
- Unable to launch DataConnect or displays an error while creating or opening artifacts
- Unable to view the default views and editors
- Project and artifact menus not displayed in the new toolbar drop-down
- Artifacts do not open in the correct editor
- A big red X is displayed in the editor. Also, when creating an artifact, either nothing happens or artifact is invalid
- Performance has deteriorated for both maps and processes
- Unable to view log entries for macros values used in a map or process
- Unable to connect to 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
- Source schema mismatch or missing field
- Execution of SQL statement failed
- Attempt to insert null in field
- Record type has no multimode entity set
- Problem inserting to table
- Problem inserting to table
- Table does not exist or is not owned by you
- Table object name not specified
- Table or view does not exist
- Table or view does not exist
- Invalid character in field name
- Field name character constraints
- Error connecting to salesforce
- TargetTableOperations implementation
- Table not a base table
- Table or view does not exist
- No action keys specified table operation
- Error writing field with width more than 255
- Failed to connect or unknown server
- Connection failed because of missing data in connection parts
- Data source name not found and no default driver specified
- Execution of SQL statement create table failed
- Exception in SQL statement create table
- Error setting queue contents to the provided DJMessage
- Data source name not found and no default driver specified
- Table not found or object type not supported
- Cannot locate named database or unable to associate with server
- Drop create truncate table not supported
- Maximum number of rows exceeded in sheet
- Error writing file or closing command object
Frequently Asked Questions (FAQs)
- What SDKs are available?
- 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 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?
- Does Content Extractor Editor (earlier called as Extract Schema Designer work in version 12?