Pervasive Data Integrator v9 Major New Features

Document Sample
Pervasive Data Integrator v9 Major New Features Powered By Docstoc
					     October 22-23, 2007


     Pervasive Data Integrator
     v9 Major New Features
     Paul Dingman, Corporate Architect
     Pervasive Software
     paul.dingman@pervasive.com




512.231.6000 - 512.231.6010 fax - www.pervasive.com
Goal of this presentation

To take a look at some of the key new
 features in Pervasive Data Integrator v9.




2   AGILE INTEGRATION – FOR EVERYONE!
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


3   AGILE INTEGRATION – FOR EVERYONE!
Data Mediation Services Framework

The Data Mediation Services (DMS)
 framework is a new connectivity framework
 embedded in Pervasive Data Integrator v9




4   AGILE INTEGRATION – FOR EVERYONE!
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

5   AGILE INTEGRATION – FOR EVERYONE!
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



6   AGILE INTEGRATION – FOR EVERYONE!
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




7   AGILE INTEGRATION – FOR EVERYONE!
DMS Connector




    Map
    Designer


                                   Data Graph


    DMS Connector                               DMS   Data Source




                                     Scripted
                                     Update




8       AGILE INTEGRATION – FOR EVERYONE!
Using a DMS from Map Designer




9   AGILE INTEGRATION – FOR EVERYONE!
Using a DMS from Map Designer




10   AGILE INTEGRATION – FOR EVERYONE!
 Using a DMS from Map Designer
                                DMS Category   Connection Options




Connection Parts


 11   AGILE INTEGRATION – FOR EVERYONE!
Using a DMS from Map Designer




12   AGILE INTEGRATION – FOR EVERYONE!
Using a DMS from Map Designer




13   AGILE INTEGRATION – FOR EVERYONE!
Engine Service for Progress Sonic ESB

A component for turning Pervasive Data
  Integrator maps and processes into
  services on the Sonic ESB




14   AGILE INTEGRATION – FOR EVERYONE!
Engine Service for Progress 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

15   AGILE INTEGRATION – FOR EVERYONE!
Engine Service for Progress Sonic ESB

                                         Sonic ESB


                                             ESB Container


                                             PDI Engine Service




                                                      PBI Engine
                                                      PBI Engine
                                                     PDI Engine

       Process Design                                Engine Pool




16   AGILE INTEGRATION – FOR EVERYONE!
Engine Service for Progress Sonic ESB

                       Sonic ESB                        Sonic ESB
                       Segment A                        Segment B

        ESB Container A                            ESB Container B


             Service 1            Service 2               Service 2




               Service 1             Service 2
            Process Design        Process Design




17   AGILE INTEGRATION – FOR EVERYONE!
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.


18   AGILE INTEGRATION – FOR EVERYONE!
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


19   AGILE INTEGRATION – FOR EVERYONE!
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


20   AGILE INTEGRATION – FOR EVERYONE!
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




21   AGILE INTEGRATION – FOR EVERYONE!
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


22   AGILE INTEGRATION – FOR EVERYONE!
                     Thank you!




23   AGILITY THROUGH EMBEDDABLE INTEGRATION