Integration Architect 8.12.0 - Readme - Release

Welcome to Integration Architect release 8.12.0. This document contains the most up-to-date information on the software and may supersede certain information in the product documentation. It contains the following sections:

Introduction

The 8.12.0 release delivers a number of improvements to the previous release. Product packages (such as Data Integrator and Business Integrator) are feature sets of the Integration Architect platform.

The license you purchase determines the features you can use. However, you may find documentation for features that are unavailable because you have not purchased them.

For information on the following topics, see the file contact.htm in the directory InstallDir\Common800\Help.

Technical support

Contacting your sales representative

Default installation directory

Web site links

Installation Notes

This release has been tested in a variety of hardware and software configurations. For detailed installation instructions, see Getting Started Guide in InstallDir\Common800\Help.

Microsoft Windows

This section covers topics of interest when installing Integration Architect on a Microsoft Windows operating system.

Administrator Rights

License file

The license file to use during installation of Integration Architect is provided by your Pervasive sales representative. This license .slc file determines which integration products can be installed. If you need to update features for your existing installation, your sales representative will send you an .slu file.

System Requirements

IBM PC or compatible PC with 800 MHz or faster processor

Windows 2000, Windows XP, or Windows Server 2003 operating system

300 MB free hard drive space in the installation location, depending on the installation options selected

1 GB RAM

CD-ROM drive unless installing from downloaded files

Java Runtime Environment. For details, see "Java Runtime Environment".

For maximum performance, ensure that your computer has physical memory to meet the requirements of the operating system and all applications.

Windows 95/98/ME/NT are not supported in this release. Technical Support is not provided for these platforms.

Java Runtime Environment

You must install a fully compliant JRE before you install Integration Architect. Java 1.4.2_06 and 1.5 have been successfully tested for this release.

Note The Integration Architect setup checks for Java on your computer. If Java is not present, setup asks you to exit and install it before continuing integration platform installation.

Internet Explorer

You need Internet Explorer 4.01 SP2 or later to install the product. You also need Internet Explorer to view the online help.

Select Help 4 About Internet Explorer from a browser window

Verify that the version displayed is 4.72.3612.1713 or higher

Dual Video Card and Title Bar Settings

If you have a dual video card, disable all title bar settings on the card before running Integration Architect.

Microsoft CRM 3.0 Connector .dll File Registration

The Integration Architect installer automatically registers Microsoft CRM .dlls for the following .NET Framework release versions:

v1.0.3705

v1.1.4322

v2.0.50727

To determine the release version of your installation, look for the Microsoft CRM entry in Add/Remove Programs.

Note If you have a different version of .NET framework than one of the versions listed above, the Microsoft CRM .dlls are not configured by the installer. See how to manually register the files below.

To manually register the .dll files

Locate the latest version of .NET framework.

Locate the regasm.exe file. This file should be in the path or called with absolute paths.

Locate the DJMsCrmComObj.dll and DJMsCrmComObj.dll in the InstallDir\Common800 directory. These files should be in the current directory or called with absolute paths. To register the files, open a command line utility and type the following:

regasm.exe DjMsCrmComObj.dll /tlb /codebase

regasm.exe DjMsCrmComObj3.dll /tlb /codebase

New Features and Enhancements

This release of Integration Architect provides improvements made in the following areas:

Installation

Java Runtime Environment 1.5

Connectors

ACUCOBOL-GT Version 7

Microsoft CRM 3.0

Oracle 10g and Oracle 10g Multimode (updated data types)

Process and Transformation LogFile Parser

Salesforce.com 7.0

SQL Server 2005

Oracle Siebel CRM On Demand 10

Data Profiler

More features available through GUI, including color coding of metric field rows

New IsValueInFile metric for ASCII-delimited files

Source schema field names for ASCII-delimited sources

Sorting by value or frequency

Ability to disable metrics in a specification

Cut, copy, and paste commands for profiling metric specifications

Ability to change source connection from command line

Choice of full installation or engine-only with no GUI

Revised user’s guide with new examples, samples, tutorials, and troubleshooting procedures

Designers

Easy Loader

New one-to-one record flat file mapper that creates intermediate data load files. Target connectors, schemas, and validation logic are predefined to speed up the integration process. Mapping wizards, fuzzy matching, and automatic event handling logic further simplify the integration mapping. Ships with sample targets for Amazon, eBay, NetSuite, and School Courier.

Designer Improvements

Enhancements to Map Designer to support Easy Loader, including:

A simple view on the Map tab. The same view used in Easy Loader, it displays only the grid from the lower right corner of the power view. Source and target trees and source grid are not displayed. Actions needed to run a transformation are automatically added by Map Designer.

Clickable toggle between simple and power view

Global preference to always show power view if desired

New Transformer icon in Process Designer

Components

MIB Integration Invoker

Connects to the MIB Web-Direct interface, submits transaction data, and returns data in a schema. Designed to work with ACORD schemas available for this release.

XPath Iterator and XQuery Invoker usability enhancements

Session properties have been removed from the GUI.

New process steps enable the user to pass an XML source file, an XQuery file, or an XPath expression in a number of combinations of the following methods:

At design time through either the XPath expression or the location of the XQuery file

At run time through the source message object, using RIFL

Repository Manager Package Creation Updates

Enables the user to create a completely self-contained package from Repository Manager. When the user right-clicks a process document and selects Create package in Repository Manager, all referenced documents to execute the process are included in the package.

Documentation

New PDF Documentation shortcut from the Windows Start Menu

New Easy Loader User’s Guide

Explains how to use the new one-to-one record flat file mapper that creates intermediate data load files.

New Easy Loader Developer’s Guide

Explains how the developer or integration platform administrator defines customized targets for use with Easy Loader.

Revised Getting Started Guide

Provides new information for integration solution developers, faster learning for new users, and a better quick reference for existing users.

New Embedding Guide

Covers integration platform embedding for Windows and Unix systems, including new rebranding features, silent installation, and customized setup packages.

Message Component Framework

This release of Message Component Framework contains many new features and advances in functionality.

Hidden Property

MCF component properties support a hidden attribute that allows manipulation of a property. The container and component use this property to pass implementation-specific information in the background. This property is not visible in the design environment.

Read-Only Property

Some components display a read-only property that is determined by the component itself at design time. This property, if applicable to your component, is displayed in the component visual design environment dialog box for information only.

Improved URI Support

Improved URI Support in the file dialog presented by the Process Designer for "File" type properties. The dialog supports typing a URI as well as the selection of directory names.

RIFL MCF Component Object Names

A new RIFL object is provided to expose all actions available on components.

Changes to better support situations where multiple versions of a component exist in multiple packages.

Process Designer updates to support the new MCF features.

Hidden properties are not displayed.

Read-only properties cannot be modified.

Changed DJQueue to DJComponent in types list for global variables.

Support for new component option types: URI and REPFILE.

An edit window is provided for editing a component option of type URI.

A repository dialog box is provided for editing a component option of type REPFILE.

Environments Supported

This section lists the platforms and environments on which Integration Architect 8.12.0 has been tested:

Windows 2000 SP4

Windows XP SP 1 and SP 2

Windows Server 2003 R2 SP1

Documentation Notes

This section provides information regarding the documentation included with the Integration Architect products.

Compiled HTML Help (CHM)

Portable Document Format (PDF)

JavaHelp

Useful Links

For a comprehensive list and details of Pervasive products, see:

http://www.pervasive.com/products

Review information about application development at:

http://www.pervasive.com/developerzone

For Technical Papers, see:

http://www.pervasive.com/support/techpapers.asp

For Product Manual downloads, see:

http://www.pervasive.com/support/updates/index.asp

For information on our Support programs, see:

http://www.pervasive.com/integration/support/support_plans.asp

For information on updates and Service Packs, see:

http://www.pervasive.com/support/updates

Disclaimer

PERVASIVE SOFTWARE INC. LICENSES THE SOFTWARE AND DOCUMENTATION PRODUCT TO YOU OR YOUR COMPANY SOLELY ON AN “AS IS” BASIS AND SOLELY IN ACCORDANCE WITH THE TERMS AND CONDITIONS OF THE ACCOMPANYING LICENSE AGREEMENT.

PERVASIVE SOFTWARE INC. MAKES NO OTHER WARRANTIES WHATSOEVER, EITHER EXPRESS OR IMPLIED, REGARDING THE SOFTWARE OR THE CONTENT OF THE DOCUMENTATION; PERVASIVE SOFTWARE INC. HEREBY EXPRESSLY STATES AND YOU OR YOUR COMPANY ACKNOWLEDGES THAT PERVASIVE SOFTWARE INC. DOES NOT MAKE ANY WARRANTIES, INCLUDING, FOR EXAMPLE, WITH RESPECT TO MERCHANTABILITY, TITLE, OR FITNESS FOR ANY PARTICULAR PURPOSE OR ARISING FROM COURSE OF DEALING OR USAGE OF TRADE, AMONG OTHERS.

Integration Architect 8.12.0 - Readme
Release - September 2006

Contents

Introduction

Installation Notes

Microsoft Windows

Administrator Rights

License file

System Requirements

Java Runtime Environment

Internet Explorer

Dual Video Card and Title Bar Settings

Microsoft CRM 3.0 Connector .dll File Registration

To manually register the .dll files

New Features and Enhancements

Installation

Java Runtime Environment 1.5

Connectors

Data Profiler

Designers

Designer Improvements

Components

Repository Manager Package Creation Updates

Documentation

Message Component Framework

Environments Supported

Documentation Notes

Useful Links

Disclaimer

Integration Architect 8.12.0 - Readme Release - September 2006

Contents

Introduction

Installation Notes

Microsoft Windows

Administrator Rights

License file

System Requirements

Java Runtime Environment

Internet Explorer

Dual Video Card and Title Bar Settings

Microsoft CRM 3.0 Connector .dll File Registration

To manually register the .dll files

New Features and Enhancements

Installation

Java Runtime Environment 1.5

Connectors

Data Profiler

Designers

Designer Improvements

Components

Repository Manager Package Creation Updates

Documentation

Message Component Framework

Environments Supported

Documentation Notes

Useful Links

Disclaimer

Integration Architect 8.12.0 - Readme
Release - September 2006