Data Exchange

Product Overview

Organizations are overwhelmed by data access demands. Customers, suppliers, and employees are demanding 7x24x365 access from mobile devices. Business units need support for digital channel initiatives. Data from multiple systems must be consolidated to satisfy regulatory requirements. Unisys Data Exchange is data integration software that is designed to help organizations address these issues.

Data Exchange propagates selected data from one data store to another data store. While propagating the data, Data Exchange applies transformations to the data as needed by the business processes and the applications that support them.

The data propagation and transformation capabilities of Data Exchange are designed to facilitate timely access to data for decision support and additional business processing while minimizing the impact to the online transaction processing environment.

Data Exchange can help you reduce software development costs by avoiding the development and support of your own data integration and transformation tools. Data Exchange is designed to work with existing applications and databases and to help you avoid the need for costly changes to them.

Data Exchange is also designed to work with a variety of databases and operating systems.

General Features

Data Exchange has a transformation definition facility that allows you to select data items in the resource data store and to determine how and where each of them gets placed in one or more target data stores. You can customize transformations to satisfy your business requirements by defining your own functions for manipulating the data. The source or target data store can be used in multiple transformations as needed to satisfy your business requirements.

A changed data transformation is a near real-time process to propagate and transform selected changed data from a source data store to one or more target data stores.

Once you start a changed data transformation, Data Exchange provides a continuous fees of changed data from the source data store to the target data store. Data in the target data store can be used by other applications. You can manage operations, such as starting and stopping a changed data transformation, by using the Data Exchange Runtime Administration facility.

You can use the bulk data transformation facility of Data Exchange to propagate and transform historical data from a source data store to one or more target data stores.

Data Exchange is designed to be efficient. It enables you to select which data items to propagate and it can propagate only changed data. In addition, you can define filters so that only the data that satisfies certain criteria are propagated. These features help you avoid the additional overhead associated with propagating data that is not needed in the target data store. Data Exchange also offloads transformation processing to a server that is separate from the servers hosting the source and target data stores. This is designed to minimize the impact of Data Exchange on database performance.

Data Exchange provides tools with graphical interfaces for transformation definition and administration. Programming skills are not required to use these tools.

Data Store Pairings

Data Exchange 4.0 supports the following source and target data store pairings.

Source Data Store

Target Data Store

Enterprise Database Server for ClearPath MCP

Microsoft SQL Server

Enterprise Database Server for ClearPath MCP

Oracle Database

Microsoft SQL Server

Enterprise Database Server for ClearPath MCP

Relational Database Server for ClearPath OS 2200

Microsoft SQL Server

Relational Database Server for ClearPath OS 2200

Oracle Database

Software Components

The following comprise the software components of the Data Exchange product.

  • Development Workbench

    The Data Exchange Development Workbench is a Microsoft Windows-based application designed for defining transformations between a source data store and target data store(s). You can also use the Development Workbench to deploy transformation to the Data Exchange Runtime Administration facility.

  • Runtime Service

    The Runtime Service is the heart of Data Exchange. It applies transformations to the data that is retrieved from a source data store and sends it to one or moer target data stores.

  • Runtime Administration

    The Data Exchange Runtime Administration facility enables you to use a standard web browser to control and monitor all runtime activities involving the Runtime Service and host components.

  • MCP Service

    The Data Exchange MCP Service runs on a ClearPath MCP Server. It consists of the Data Exchange MCP Agent and the Data Exchange DMSII Adapter.

    The Data Exchange MCP agent is used to support changed data transformations when an Enterprise Database Server database is a source data store. It monitors the audit train associated with an Enterprise Database Server database and is responsible for passing changed data to the Runtime Service.

    The Data Exchange DMSII Adapter is used to support changed and bulk data transformation when an Enterprise Server Database is a target data store. The adapter provides support to the Runtime Service to update Enterprise Database Server databases.

  • OS 2200 Agent

    The Data Exchange OS 2200 Agent is a batch processing component running on a ClearPath OS 2200 server. When esecuting a changed data transformation, the agent monitors the audit trail associated with a Relational Database Server database and passes changed data to the Runtime Service. The agent is also responsible for providing the data, in bulk, for bulk data transformations.

  • Agent for SQL Server

    The Data Exchange Agent for SQL Server is used to support changed and bulk data transformations when a Microsoft SQL Server database is a source data store. The agent monitors the change data capture (CDC) tables of the SQL Server database and passes the changed data information to the Runtime Service.

Configuration Requirements

Refer to the Unisys Data Exchange Installation and Configuration Guide on support.unisys.com for detailed hardware and software requirements such as specific software editions and release levels.

Enterprise Database Server for ClearPath MCP Data Store

  • ClearPath Forward Libra 4300, 6400, or 8300 or later server, ClearPath Financial Services FS600 or later server or ClearPath Software Series product

  • ClearPath MCP operating environment

  • Enterprise Database Server for ClearPath MCP (included in MCP operating environment)

If you are using Enterprise Database Server for ClearPath MCP as a source data store, you also require ClearPath MCP Interface to Microsoft Message Queuing.

If you are using Enterprise Database Server for ClearPath MCP as a source data store and are performing bulk data transformations, you also require Enterprise Database OLE DB Data Provider for ClearPath MCP (included in the MCP operating environment)

If you are using Enterprise Database Server for ClearPath MCP as a target data store, you also require ClearPath Application integration Services, Enterprise Edition.

Relational Database Server for ClearPath OS 2200 Data Store

  • ClearPath Forward Dorado 4300, 6300, or 8300 server

  • ClearPath OS 2200 operating environment

  • Relational Database Server for ClearPath OS 2200

  • ClearPath OS 2200 Interface for Microsoft Message Queuing

  • ClearPath Application Integration Services, Basis Edition

  • Connectivity Services

Microsoft SQL Server Data Store

  • ClearPath Forward Enterprise Partitioned Platform (EPP) partition or a computer with a network connection that is capable of running compatible versions of Microsoft Windows Server and Microsoft SQL Server

  • Microsoft Windows Server

  • Microsoft SQL Server

Oracle Database Data Store

  • ClearPath Forward Enterprise Partitioned Platform (EPP) partition or a computer with a network connection that is capable of running compatible versions of Microsoft Windows Server or Linux and Oracle Database

  • Microsoft Windows Server or Linus

  • Oracle Database

Development Workbench, Runtime Service, Runtime Administration, and Agent for SQL Server

  • ClearPath Forward Enterprise Partitioned Platform (EPP) partition or a computer with a network connection that is capable of running compatible versions of Microsoft Windows Server and Microsoft SQL Server

  • Microsoft Windows Server

  • Microsoft SQL Server

Product Information

Refer to the following documents for more information:

  • Unisys Data Exchange Installation and Configuration Guide (8205 2804)

  • Unisys Data Exchange Development Workbench Help (8230 0773)

  • Unisys Data Exchange Administration Site Help (8239 9781)

  • Unisys Data Exchange Sample Transformation Guide

  • Unisys Data Exchange Online Information Center (8229 8688)