Integration Connectivity

Data Conversion

If everyone spoke every language, we wouldn't have a need for translators, and there would be less confusion in communication between people and countries. The same holds true for companies and applications. If every application spoke the same language, then sharing information between them would be much easier and less prone for mistakes. The truth, however, is that applications focus on what they've been built for, not for the benefit of other applications, especially those that are in competition. Pervasive specializes in data/application communication through translating application speak with our connectors. These connectors are built to connect to an application or data source, map to the appropriate fields and translate the contents of those fields into information that can be shared with other applications and data sources.This connectivity platform is called Universal CONNECT!™

Pervasive Universal CONNECT!

Universal CONNECT!™ is Pervasive's comprehensive initiative for universal connectivity to all data sources and applications - from legacy to on-premises to SaaS applications, files to databases, Web to mainframe. You'll get complete connectivity to virtually any on-premises or on-demand application or data source.

Whatever it is, Pervasive's mission is to connect to it and integrate it. And with a 29-year history of integration, we almost do.

Pervasive Connectivity Platform

Connect to Thousands of Endpoints

Components include:

  • Data connectors (structured and unstructured files, databases, etc.)
  • Application connectors (popular applications such as SAP, Oracle, Great Plains, MS Dynamics, Salesforce CRM, etc.)
  • Web Services
  • EDI
  • Standards (HL7, HIPAA, SWIFT, NCPDP, EDIFACT, HCFA, etc.)
  • XML
  • Enterprise Message Service Bus
  • FTP/HTTP/E-mail

Pervasive Data Integrator™ can connect to literally hundreds of applications out of the box. If you need more information regarding a specific connector, contact us for more information on how Universal CONNECT! connects to virtually anything.

SOA Integration

Pervasive supports Web services APIs, allows you to abstract and scale the granularity of processes, and provides wide connectivity for ESB and Message Queue on-ramps and off-ramps, making it an excellent fit for SOA (Service Oriented Architecture) integration infrastructure.

Pervasive integration software simplifies many of the challenges of SOA design and deployment. Pervasive's out-of-the-box connectivity to thousands of different applications and data sources allows developers to include older, legacy, mainframe, unstructured and nonstandard data into their projects without brittle, difficult to maintain, custom-written code.

The Pervasive SOA strategy of exposing integration processes capable of aggregating, cleansing and validating data from multiple disparate sources as reusable Web services-called data services allows incremental development. Tackle one part of the project at a time. Build a few data services for the first project, then expand as the developer's experience with SOA challenges grows.

It also lets the SOA integration designer choose the level of granularity, and build higher level composite data services by using multiple services together. Most important in today's economy, Pervasive offers all of that power along with a rapid development time at a price point that makes SOA projects affordable .

Data Governance for SOA Success

Data Integration Will Break Out of the Silo: BI and DW Trends, 8 for '08

Solving the SaaS, SOA and Legacy Applications Sudoku


Pervasive ESB & Message Queue On and Off-Ramps

  • Deliver the "last mile" of connectivity to thousands of different applications and information sources including mainframe file systems, COBOL, unstructured, B2B, databases and more.
  • Remove the adapter price barrier to maximizing SOA initiatives.
  • Provide rich composite data functionality to existing ESB, EAI, BPM, Portal and Application Server initiatives.
  • Eliminate the need for custom-coded adapters, thereby dramatically reducing acquisition costs, support costs and risk.
  • Deploy one solution across most operating environments, including Linux, HP-UX, Windows and Solaris.

Pervasive integration software is compatible with most types of message queues, including IBM WebSphere MQ (MQ Series), MSMQ, Oracle AQ, any JMS-compliant queue, and also allows file folders to be processed as if the files were in a queue. Pervasive is a Progress partner and an Oracle partner compatible with a variety of ESB, EAI, BPM and BPEL technologies, including Oracle BPEL and Progress Sonic ESB.

Message Component Framework

Message queues provide the passageways for messages between users and systems. Messages can be placed in queues and stored until the recipient has reviewed them in a systematic, first come, first served sequence.

Pervasive software is compatible with most types of message queues, including IBM WebSphere MQ (MQ Series), MSMQ, Oracle AQ, and any JMS-compliant message queue, and also allows file folders and FTP folders to be processed as if the files were in a queue.

Linking and Synching Applications

The Pervasive integration software features real-time, event-driven and message-based infrastructure for the cost-effective integration of multiple applications, both within and outside the organization, as well as simple point-to-point integration. You can design and implement a messaging solution to meet your needs, build message queue on-ramps and off-ramps for any ESB, or enable point-to-point exchange of XML, SOAP, text or other message formats as well as native API communication between applications. Pervasive integration solutions are transport-independent and interface with WebSphere MQ (MQSeries), MSMQ, Oracle AQ or any JMS-compliant queue. Our solutions support "listening" to file folders and FTP folders for the arrival of data, and can run as a service for event-driven integration.

For more information, see Application Integration

For information on application integration in large enterprises, see Pervasive Integration Platform

Integrating Databases

Pervasive offers a wide variety of connectors that deliver high performance and flexibility. Access your data with high-speed native API database connectors for many RDBMS systems like Pervasive PSQL, Oracle and SQL Server; or use ODBC, JDBC or IDAPI.

Mass insert, direct path or intermediate SQL loader formats can rapidly load high data volumes. With Pervasive data connectors you can control commit frequencies within your database to increase data input rates and control rollbacks. The Pervasive multimode capability even allows you to write data into multiple tables at the same time.

Integrating Structured Data Files

Pervasive connectors enable rapid access to heterogeneous data. Whether your data sits in ASCII or Unicode flat files, Access or dBASE database files, or in Excel spreadsheets, Pervasive makes data file integration easy.

Just select the file type from the list in Pervasive Map Designer, select your file and visually browse data, including metadata such as column, table and field information.  For fixed-length files, the visual parser makes defining fields point-and-click simple.  Delimited files can be read instantly, displayed in clear rows and columns and written out with any delimiters or other formatting you choose.

Electronic Data Interchange

Pervasive supports EDI files of all types, including industry standards like HIPAA, HL7, SWIFT, FIX, etc. Pre-made schemas for these files allow fast reads of well-formed standard files, as well as the flexibility to adjust the schema for unique or unusual variations.

For more information, see B2B Data Exchange

Make Legacy Critical Data Accessible

Legacy and homegrown systems often house critical data. With mergers, acquisitions and new business development, this data often has to be integrated with new or expanded environments, a challenging and expensive necessity. Many organizations resort to custom scripting, which might gain access to the data, but tends to break easily over time, and come with a high-maintenance price tag.

Pervasive Data Integrator™ provides organizations with direct access to legacy data, built-in productivity tools and an easy-to-use development environment. Pervasive solutions allow noninvasive access to data, across many hardware platforms, applications and operating systems.

Benefits of Legacy Data Integration

  • Integration of legacy investments with hundreds of data formats and applications
  • Scalable design and deployment options
  • Ability to leverage valuable data in legacy and homegrown systems
  • Integration of legacy systems with strategic, new technologies
  • Flexible design environment that allows easy maintenance of integration processes for ever-changing business needs
  • Design interfaces that are easy to use and administer for greater productivity and rapid payback
  • Ability to integrate unstructured data such as email and mainframe reports for business use

More Complete Information Means Better Decisions

Valuable information is often underutilized or overlooked for integration because it exists in a format that makes it seem unobtainable unless laboriously re-keyed or pasted into a usable format. Unstructured or loosely structured data formats, such as email, Web pages or electronic reports, hold huge amounts of potential information that can enrich any research project or business decision-making process.

  • Incorporate unstructured data sources into decision-making processes.
  • Expand accessibility and use of all data within your organization.
  • Avoid old, unnecessary and labor-intensive methods for obtaining unstructured data.
  • Locate and expand business opportunities by harvesting information from the world's largest data store - the Internet.

For integrating EDI and various industry standard files, see B2B Data Exchange.

Framework for Connectivity

Pervasive provides an extensible connectivity framework - making it easy for customers and partners who need to quickly solve the "last 1%" of the connectivity problem. Pervasive's Universal CONNECT!, allows customers and partners to connect to even the most difficult or obscure end-points - typically in a few hours.

Universal CONNECT! gives customers and partners access to the full power of Pervasive's open connectivity framework. It makes establishing connectivity simple and fast - but not at the expense of functionality.

All Pervasive connectivity components (whether built by Pervasive, by a Pervasive partner, or by an end-user) are "hot-pluggable". Once connectivity is established, the full power of Pervasive's connectivity infrastructure is instantly leveraged.

Pervasive Galaxy™

One of the reasons Pervasive can connect to so many applications is the introduction of Galaxy. Galaxy is Pervasive's connectivity marketplace where you can get the latest connectivity solutions (full solutions, maps, processes, plug-ins, connectors). New connectors are being uploaded to Galaxy daily, contributed from Pervasive, our partners, and our customers.

Need a Jumpstart on an Integration?

Build your Integrations faster and more efficiently. With Galaxy you can find new and interesting ways to begin your integration projects and get to completion faster. With the use of the Pervasive platform, Galaxy allows Pervasive partners and users to group together to make integration a community.

With Galaxy you can:

  • Purchase pre-built connectors, maps & templates
  • Sell connectors, maps and templates that you've built
  • Request (groupon-style) for someone to build you a connector
  • Build revenue by offering to build connectors
  • Vote & rate projects in Galaxy - see others comments before buying

Visit the Galaxy website now!


The ease of use, scalability and vast number of supported data formats of Pervasive's integration technology allows us to meet our clients' needs and make sure that their valuable IP is secure."

Nick Church
Business Applications Architect
CPA Global Limited

Mike Hoskins on Universal CONNECT!

How can Pervasive claim universal connectivity to nearly every endpoint, even some that don't exist yet?