pervasive data integrator v9 major new...

512.231.6000 - 512.231.6010 fax - www.pervasive.com

October 22-23, 2007

Pervasive Data Integrator

v9 Major New Features

Paul Dingman, Corporate Architect

Pervasive Software

[email protected]

mailto:[email protected]

Goal of this presentation

To take a look at some of the key new

features in Pervasive Data Integrator v9.

AGILE INTEGRATION – FOR EVERYONE!2

Agenda

• Data Mediation Services Framework

• Engine Service for Progress Sonic ESB

• New Transformer components

• New Invoker components

• New and improved Queue components

• Updated connectors

• Windows Vista support


Data Mediation Services Framework

The Data Mediation Services (DMS)

framework is a new connectivity framework

embedded in Pervasive Data Integrator v9


What is a DMS?

A Data Mediation Service provides access to a

data source in a uniform way

• Focused on data integration rather than application

development (batch-oriented CRUD operations)

• Light weight and low cost

• Open standards based (WS-*, SDO)

• Loosely coupled connectivity (remote, SOA)

• Pluggable (SPI) and embeddable

• Components are self-describing

• Language/Platform agnostic connectivity


Key benefits of the DMS framework

New connectors are implemented by pairing

data mediation services with the new DMS

connector

• DMS components are Java plug-ins developed

using the DMS SDK

• DMS-based connectors look like built-in

connectors

• Simple drop-in style of installation for new DMS

components


Key benefits of the DMS framework

(continued)

DMS components can be embedded in other

applications or services

• DMS components can be used by applications to

extract or load data

• Data Profiler uses DMS for data access

• DMS will be the foundation for future data service

offerings


DMS Connector


DMS Connector DMS Data Source

Data Graph

Scripted

Update

Map

Designer

Using a DMS from Map Designer




Connection Parts

Connection OptionsDMS Category

Engine Service for Progress Sonic ESB

A component for turning Pervasive Data

Integrator maps and processes into

services on the Sonic ESB



• The component is managed by the ESB

• startup/shutdown

• configuration/deployment

• Engine services benefit from the enterprise features

of the ESB

• high availability

• scalability

• distributed

• Engine services can be used in bus processes,

orchestrations (BPEL) or composite services




Sonic ESB

ESB Container

PDI Engine Service

Engine Pool

PBI EnginePBI EnginePDI Engine

Process Design



Sonic ESB

Segment A

ESB Container A

Service 1 Service 2

Sonic ESB

Segment B

Service 1

Process Design

ESB Container B

Service 2

Service 2

Process Design

New Transformer Components

• HL7 v2.x/HL7 XML

– New components for map-less transformation

of HL7 v2.x messages to and from HL7 Version

2 XML Encoding Syntax format (ANSI/HL7 V2

XML-2003)

• NCPDP Script v8.1/NCPDP Script XML

– Components to transform between EDIFACT

and XML formats of NCPDP used for

ePerscriptions.


New Invoker components

• Salesforce Invokers

– Salesforce Login

Component to support use of a single session across

multi-step processes

More efficient integrations by reducing the number

login requests

– Salesforce Changed Data Query

Returns a list of object ids for either changed or

deleted objects

Useful for building data synchronization solutions


New and improved Queue components

• FTP Queue now supports both SSH file

transfer protocol (SFTP) and FTP/SSL

(FTPS) for better security over the

traditional FTP support

• WebSphere MQ v6 now supported with the

MQ Series component

• Support for attachments with the POP3 and

IMAP email components


Updated connectors

• P.SQL and Btrieve connectors updated to

support P.SQL v10

• Salesforce connector updated to support

the Salesforce Summer’07 (v10) release

• SalesLogix connector updated to support

Sage SalesLogix v7


Windows Vista support

• Only application runtime and static

resources are installed in the installation

directory

• Workspaces, configuration files, plug-ins,

log files, samples, etc. are installed to

shared or private user areas

• Support for Windows Vista Business and

Windows Vista Enterprise


AGILITY THROUGH EMBEDDABLE INTEGRATION23

Thank you!

pervasive data integrator v9 major new...

Documents