Pervasive Data Integrator

Pervasive Data Integrator is a data integration, Enterprise Application Integration, and ETL tool made by Pervasive Software that was previously known as Data Junction and Pervasive Business Integrator. The Pervasive Data Integrator consists of a suite of tools, including a visual mapping tool, a workflow process designer, an execution engine, and various schema designers to help with complex data structure reading and writing. Pervasive also makes the Pervasive Data Profiler tool that works with Pervasive Data Integrator for Data Quality and remediation tasks. Pervasive Data Integrator uses Rapid Integration Flow Language (RIFL) a simple scripting language with syntax similar to Visual Basic to define complex data transformations, data cleansing, or build custom functions.

Pervasive Data Integrator stores maps, data structures, processes and all other metadata in an open XML format compatible with version control systems.

Data Integrator transforms and remediates corporate information for use in data marts, ODS systems and data warehouses, etc. Pervasive Data Integrator also is used for Enterprise Application Integration including synchronization between multiple applications including integrating SaaS applications with other SaaS applications or with on-premise applications, and Business to Business Integration(B2B). Pervasive Data Integrator can automate the integration of data movement tasks on an event-driven, real-time, or regularly scheduled basis.

Pervasive Data Integrator extracts, aggregates, replicates, transforms and loads data from disparate sources, multiple platforms, and operating environments, including between very old legacy and mainframe data and applications and new systems including software as a service (SaaS) systems such as NetSuite, salesforce.com, and Quickbooks Online. It has more than 150 connectivity adaptors, and executes on a variety of operating systems.

Supported Platforms

Design and execute:

Windows XP, Windows Server 2003, and Windows Vista Enterprise, Business, and Ultimate

Execute Only:

Windows XP, Windows Server 2003, Windows Vista Enterprise, Business, Ultimate, Linux, RHEL 4 and 5, AIX 5.3, HPUX 11i v2 11i, Solaris 10 & 9, and Suse 10, 9.3, 9.0

External links

* [http://ww2.pervasive.com/Integration/DemoCenter/Pages/DataIntegratorResources.aspx Pervasive Data Integrator Demos, Presentations, and Case Studies]
* [http://ww2.pervasive.com/Integration/Solutions/Pages/PervasiveConnectors.aspx Full List of Pervasive Data Integrator Connections]
* [http://www.pervasive.com/dataintegrator/ Corporate website]
* [http://ww2.pervasive.com/Integration/Products/Pages/PervasiveDataProfiler.aspx Pervasive Data Profiler]