Data Integration Platform

We Connect to Darn Near Everything

When you've been in the integration business for 29 years, you've not only seen it all, but you've connected to it! Underlying the Pervasive Integration Platform is an extensive library of connectivity that accesses data wherever it’s hiding in your enterprise, from Access to Zuora; from XML to Oracle; from cutting edge SaaS applications like Salesforce CRM to legacy COBOL applications still chugging away on your AS400 systems; from emails and spreadsheets to enterprise RDBM Systems.  Hundreds of connectors for integration of almost any data are included with the platform, no need to purchase individual connectors.

The full connectivity capacity is included. In addition to the constantly expanding library of connectors included with the platform, our Universal CONNECT! architecture is designed to make connectivity rapidly extensible. New connectivity can be created rapidly, from a few hours to a few weeks, and plugged into the rest of the platform instantly.

All common RDBMS and bulk loaders such as Oracle, SQL Server, Pervasive PSQL, DB2, Informix, PostgreSQL, Sybase, Teradata, …

• File data including Unicode, such as ASCII fixed and delimited, Access, Excel, Lotus, …
• Support for EDI and many industry standards. For example healthcare connectors include HIPAA, HL7, NCPDP, MLLP, HCFA, UB04, UB92, CMS, …
• Full support for web services API’s, message queues, XML, and SaaS applications such as Salesforce CRM, Oracle CRM On Demand, Microsoft Dynamics, NetSuite, RightNOW, Daptiv, …
  • A vast variety of on-premises applications, both modern and legacy
  • CRM such as SalesLogix, GoldMine, ACT!, MarketForce, SalesAlly, …
  • ERP such as JD Edwards, SAP, PeopleSoft, Oracle, …
  • Accounting such as MAS 90/200/500, QuickBooks, Softrax, MS Dynamics GP and SL, …
  • Other applications such as Exact, Planview, Prophet 21, Sharepoint, SPSS, Xactly, …
• Full EDI, EDIFACT, Dodge, FIX, SWIFT, and TRADACOM support; read, validate, transform
• SAP BAPI, RFC, IDoc support
• Standards such as ODBC, JDBC, and IDAPI
• And extensible connectivity to everything else …

For more information, see Universal CONNECT!

Pervasive DataRush™

Data volumes can be huge and are constantly expanding. The Pervasive data profiling and matchmerge de- duplication engines are both built on the Pervasive DataRush extreme high performance automatic multi- threading, multi-core parallel processing platform. Analyzing and processing high volumes of data won’t bog down your systems.

• Parallel execution with automatic scaling across multiple CPUs
• Near linear speed increases with additional cores, twice as many cores means nearly twice the speed, tested and proven at up to 384 cores
• Now supports multiple JVM-based languages, Java, Python, Scala, Ruby
• When your data loads get to big for any one machine to handle, DataRush allows you to scale out to an unlimited number of machines in a cluster.
• Accellerates Hadoop deployments by at least 3X.

For more information, see Pervasive DataRush™

Pervasive Data Profiler™

Business rule violations need to be located and quantified, null sets or values identified, and data compliance ensured with testing of 100% of the data, not just a sample. With the Pervasive DataRush™ as its foundation, Data Profiler crunches through analysis of even huge datasets with hundreds of business rules on multiple columns. See the time and labor-saving advantages for yourself of using the fastest profiling engine on the planet.

• Based on Pervasive DataRush which provides lightning fast highly parallel processing speeds
• Profile and cleanse every bit of problem data as fast as most applications profile tiny samples
• Check data against hundreds or even thousands of business rules without performance limitations
• Actionable, at-a-glance charts backed by drill-down analysis with percentages of success rate and specific counts
• Detailed views of Pass and Fail for files and equal range binning
• Statistical metrics such as mode, median, standard deviation and variance presented in a report that can be easily manipulated by and linked to other applications via XML

For more information, see Pervasive Data Profiler™

Pervasive Data MatchMerge™

Handling duplicate data is a key step in any integration of multiple sources. Advanced and tunable algorithms in Pervasive Data MatchMerge allow you to identify potentially duplicate data and cluster it. You can set your own matching thresholds for automatic de-duping. For the records that require a human eye to discern, an intuitive interface allows you to easily choose which pieces of which records to use to assemble a single master record. If you have your own preferred de-duping interface, Pervasive can do the high speed matching and clustering, and pass you just the records that need merging by a person. See the time and labor-saving advantages for yourself of using the fastest matching engine on the planet.

• Extremely fast, highly parallel engine that scales even for very large data sets
• Rich, context-filled user interface for merging duplicates
• Can match on any combination of fields in data sets: name, address, company, product name, etc.
• Data fields compared using industry standard and customizable algorithms
• Multiple supported encoding methods
• Easy property configuration management to fine-tune the matching parameters
• Analysis output contains tagged results that facilitates downstream processing or additional remediation
• Matching engine can be automated, or invoked from a process workflow

For more information, see Pervasive DataMatchMerge™

Plug in Content Libraries to Complete the Data Picture

Data quality isn’t just about solving for inaccurate, inconsistent and duplicate data. When you need to append, update, or cleanse data, use Pervasive partners' content libraries. The additional data can augment the power of Pervasive Data MatchMerge to find and confirm duplicate records.

Address verification, powered by recognized address content library experts like Melissa Data and Experian QAS, helps you verify that your customer, vendor, and supplier addresses, phone numbers, and email addresses are valid and correct by checking each one against huge databases of information.

Licensed tables from institutions like USPS, Canada Post, Dun & Bradstreet, Advo, Experion, Verizon, etc. give the latest up-to-date information allowing address validation clear to the delivery point. Connecting to this validation service is as simple as running an install.

Integrating any partner or proprietary content library means no more "garbage in." As your data is extracted and profiled, Pervasive's integration process can access any external content to fill in the gaps and enrich your data. Fill out incomplete addresses, add GEO codes to auto-assign accounts to reps, fix bad SKUs, add NAICS or DUNS codes, basically anything you need to complete your data BEFORE inserting it into your final destination.

For more information, see Content Libraries

Pervasive Data Integrator™ - Map Designer

The basics of any integration project are connecting to the source, connecting to the target, and mapping - matching up data from the source with the fields it needs to go to in the target. Since no two file types, applications, or databases store their data in the same way, you’ll also need to transform the data to match the new requirements. Pervasive Universal CONNECT! means that connecting to a wide variety of sources and targets is as simple as a few mouse clicks, and even hard-to-reach applications are accessible. Pervasive Map Designer shortens the learning curve and reduces overall project costs by making mapping just as straightforward:

• Drag-and-drop graphical user interface for mapping and transformations
• Rich set of pre-built functions with wizards for transforming data
• Name and address parsing and scrubbing
• Immediate, in place testing and debugging of transformations
• Complete rules definition for complex data aggregation and transformation, including updates to multiple targets in one pass
• Event-driven transformation model that gives flexibility for handling any transformation requirement
• Rich facilities for error-logging, record reject, and execution flow control
• Mapping and transformation of multi-record type data, and multiple tables simultaneously
• Access to data—including XML and text—over HTTP/HTTPS, TCP, and FTP/FTPS
• Reusable, component-based integration design
• Integration to ETL data into data warehouse applications and business intelligence tools. For analytical data warehouse solutions to meet your business intelligence objectives, visit here.

For more information, see Pervasive Data Integrator™

Pervasive Data Integrator™ - Process Designer

Complex integration projects require many steps to complete. Automating that flow can streamline and organize integration, including steps that involve other applications, providing vastly increased speed and reducing manual maintenance requirements. The Pervasive Process Designer allows you to easily design and control bi-directional, looping, and conditionally branching workflows, from a single interface. This unifies the integration process across the enterprise providing a single point of control. Pervasive Process Designer includes:

• Graphical process flow design environment
• Drag-and-drop creation of complex, multi-step workflows
• Initiation and interaction with external applications and business processes
• Streamlined component configuration with properties grid
• Fully extensible via Message Component Framework plug-ins

For more information, see Pervasive Data Integrator™

Pervasive Data Integrator™ - Designing DataSet Schemas

Data, without the structure that describes it, can become unreadable and unusable. If the data has structural information already stored, the Pervasive schema designers can frequently capture that immediately. When data lacks structure, schema designers allow you in a point and click visual format to define structural schemas from a wide variety of sources:

• standard database schemas
• binary formats, COBOL structures, and other legacy file formats
• unstructured data sets such as online or print file reports, email, …
• electronic messages (standards-based messages such as EDI or SWIFT)

For more information, see Pervasive Data Integrator™

Traditional Production Data Center Deployment

Pervasive integration software is architected so you can design once and deploy anywhere. It gives the option of deploying the integration on a wide variety of platforms.

• Real-time, event-driven, and continuous processing
• Logging/rollback feature that allows rollback in the event a process ends unexpectedly
• “Upsert” capabilities that speed efficiencies when inserting/updating data during high speed operations
• Multi-threaded Integration Engines for scaling large data loads across multiple CPUs within narrow time frames
• Distributed integration option that allows integration processes to reside at the points of integration, thereby creating a scalable and flexible integration infrastructure

Deploy On-Premise

Pervasive Integration Engine is a small-footprint, high powered component that executes on a wide variety of 32 and 64-bit platforms, Windows XP, Vista, and Server, Solaris, AIX, HP, RedHat, and Suse. Pervasive Integration Engine features include:

• SMP support for scaling large data load processing across multiple CPUs
• Data as a Service capability for SOA
• Direct integration of applications using the provided JCA Resource Adapter, Message-Driven Beans, Java, or C APIs, or via command line
• Small footprint–readily embeddable in third-party applications
• Invocation and deployment of integration processes using Web services standards, SOAP/WSDL, REST, …
• Repository Manager creates deployment packages, generating documentation, performing basic impact analysis, and search-and-replace functionality

For more information, see Pervasive Data Integrator™

Your Cloud or Mine? 

Pervasive integration software is architected so you can design once and deploy anywhere. It gives the option of deploying the integration on a wide variety of platforms.

• Real-time, event-driven, and continuous processing
• Logging/rollback feature that allows rollback in the event a process ends unexpectedly
• “Upsert” capabilities that speed efficiencies when inserting/updating data during high speed operations
• Multi-threaded Integration Engines for scaling large data loads across multiple CPUs within narrow time frames
• Distributed integration option that allows integration processes to reside at the points of integration, thereby creating a scalable and flexible integration infrastructure

The Pervasive integration engine is optimally designed to execute in a cloud-based data center. You can opt to use our Pervasive DataCloud® or our partner Eucalyptus offers a packaged version of DataCloud for deployment in large enterprises, or any enterprise with security concerns, as a private cloud.

Deploy on the Cloud

Pervasive DataCloud® 2 is a secure and reliable on-demand services platform fully powered by Amazon Web Services EC2. It's for AWS and other cloud developers who need to rapidly create either low-level or high-level on-demand data services, including, but not limited to, integration.

Easy to use, you can leverage Pervasive data services, including its vast catalog of data adapters, to accelerate your Cloud development. Don’t tie yourself up with data infrastructure concerns. Instead, free yourself up to focus on business-level logic and other priorities.

Cloud-based integration makes perfect sense if you are integrating multiple SaaS applications, but Pervasive also gives you the option of integrating cloud with on-premises. The small-footprint integration agent is the key to bridging firewalls to reach on-premises applications.

DataCloud offers:

• Remote invocation of integration processes using Web services, JCA, Message-Driven Bean, and Java API standards
• Integration Agents:
  • Lightweight, dynamic and self contained run-time Agent
  • Contains everything necessary to execute an integration process–connector(s), maps, business
  • rules, error handling, transformations, etc.
  • Easily deployed at trading partner or other connection end-point site
  • Connects over the Internet to Integration Hub for management

For more information, see Pervasive DataCloud® 2

Rapidly Onboard Customers/Partners, Reduce Onramp Time 80%

Integrate across the firewall. Quickly configure and manage processing for diverse, disparate data feeds and multiple methods of communication. Incorporating data quality analysis, Pervasive integration Hub lets you manage onramps with constantly changing business rules while avoiding costly restarts.

Pervasive's lightweight Integration Agents enable rapid integration with applications and data sources—even behind firewalls.

For more information, see Pervasive Integration Hub™

Describing Data Easily & Efficiently

Pervasive Data Integrator™(v9) automatically captures extensive design-time and production metadata in a single repository for lineage within the metadata framework and impact analysis on integration processes, designs and interrelationships.

Pervasive Data Integrator allows data analysts, developers and other key business and technical resources to quickly view and report on dependencies and the context of data elements. It also provides auditing for compliance needs, and to ensure the data continues to meet business objectives.