Oracle Integration with Pervasive

Pervasive for Oracle Application Server enables rapid access to heterogeneous data and offers the unique capability to process non-relational and semi-structured content that is buried throughout most companies. Our adapters eliminate the complexity of low-level interface coding, while reducing cost, time and risk.

Pervasive accesses, transforms and creates composite services from disparate sources and provides universal accessibility for the Oracle BPEL Process Manager and the entire Oracle business integration suite. These composite data services perform meaningful work and are coarse-grained Web services that can be combined into macro-level applications and business processes by the Oracle BPEL Process Manager.

The flexibility of Pervasive provides a broad range of connectivity options to various Oracle applications, such as Oracle financials, Siebel CRM, etc.

Oracle Application Integration Options

Pervasive Data Adapters for Oracle AS

Pervasive data adapters for Oracle Application Server enable rapid access to heterogenous data. Pervasive is a validated adapter partner for Oracle Business Integration Products.

The comprehensive set of data adapters allows a broad range of seamless connectivity to file systems, databases, message buses, EDI networks, Web-enabled applications, business applications and industry-standard protocols on numerous platforms.  In addition, the Pervasive Universal CONNECT! capability provides virtually unlimited connectivity to data and applications throughout the enterprise.

Oracle Application Demos

Composite Data Services

Pervasive composite data services offer developers using Oracle Data Integration Suite the coarse granularity to build reusable components based on Web services standards. Composite data services effectively bridge the gap between disparate, raw data sources and the requirements of SOA principles, as developers move away from brittle integration middleware.

Pervasive adapters provide a flexible design-time experience for rapid development of composite data services. The development GUI has built-in support for introspection of data and application metadata, and automatically generates the metadata. Developers have access to a powerful set of configuration tools that include a graphical designer, a mapping designer with built-in transformation and exception management, and a schema designer - all the tools necessary to build rich composite data services.

Partnership With Oracle

What is the relationship between Oracle and Pervasive Software?

Oracle refers customers to Pervasive as a key solution for accessing legacy back-end systems and unstructured data sources. This delivers access and leverages existing IT information assets from the Oracle Technology Platform - and helps Oracle keep database customers.

What does the Pervasive product do for Oracle customers?

Pervasive data adapters for Oracle AS enable the last mile of tedious integration with legacy systems and otherwise hard-to-reach data. As more businesses move towards business process optimization, efficient integration with existing Enterprise Information Systems (EIS) becomes the key to success. These EIS applications are heterogeneous, come from different vendors, are based on different technologies, and run on different platforms. EIS systems can be packaged applications, legacy and mainframe applications, databases, messaging middleware, Web applications or file systems distributed throughout the enterprise, and these systems need to be integrated seamlessly to achieve cost savings. The Pervasive data adapters for Oracle AS provide truly flexible, highly scalable, real-time, bidirectional standards-based connectivity enabling customers to deploy composite data services.

What does Pervasive mean by composite data services?

Data is the fuel that modern business runs on. Driven by the need to accelerate the time to market, to reduce costs and to minimize risk, C-level executives are turning to service-oriented technology to gain a competitive advantage. Typically, most organizations have data residing in a large number of disparate applications and data sources that need to be unified into a composite instance for a variety of pressing business needs. In order to supply the required set of data that fuels these service-oriented applications, managers are frequently faced with very detailed and labor intensive coding, testing and processing. Pervasive provides the tools to easily build complex data services that parse, validate, transform and route application information, wrapping them into a composite data specification that is exposed as a Web service. Pervasive refers to this unified data integration process specification as a composite data service.

How do the Pervasive Adapters differ from other competitive products?

• Pervasive data adapters are unmatched in price/value performance. As the value leader, Pervasive offers the richest adapter technology for the lowest total cost of ownership in this tool category.
• Pervasive's powerful set of visual tools for accessing and transforming data empower less technically skilled workers to achieve the required results quickly. This approach enables customers to reduce the time to value as well as overall cost.

Sorted list of data adapters

Use With Oracle BPEL

How is the Pervasive adapter integrated with Oracle AS products (BPEL Process Manager)?

Deployed as a compact step (i.e. Web services) within an Oracle BPEL Flow, Pervasive data adapters for Oracle AS extend the reach of Oracle BPEL Process Manager and the Oracle AS platform to enable integration of legacy systems and hard-to-reach data.

What are the standards supported in the product?

Pervasive adapters are JCA compliant, SOAP- and WSIF-based, and interoperable with BizTalk Server and .NET technologies. Adapters support JDBC, ODBC, OLE DB, and ADO APIs, as well as message queuing technologies such as MSMQ, Websphere MQ (MQSeries), Oracle AQ and any JMS compliant queue.

Is the Oracle Database required to run the product?

No. Pervasive data adapters run independently of any database application. Pervasive adapters are able to access Oracle and many other database formats as a data resource in building composite data services.

How do Pervasive Data Adapters work?

Designed to optimize legacy applications, unstructured data and compound data integrations for use in applications and business processes, the adapters can be called by Web services, run by simple scripts, or executed at the command line.

What is the design-time experience of the Pervasive Data Adapters? Can I browse and/or generate XML schemas?

The design-time experience for configuring adapters is a drag-and-drop graphical interface that is visually intuitive and easy to use. All composite data services are saved as XML files.

Pervasive data adapters also ship with Repository Explorer, the heart of the adapter design tools. In this central location, you can launch all of the Designers, including the Map Designer, Join Designer, Extract Schema Designer, Structured Schema Designer, Source View Designer and Document Schema Designer.

You can also open any Repository that you have created, and then open and run Composite Data Services, Transformations, or Schema files in the Repository list. In the Repository Explorer, you can access the version control functionality of CVS or Microsoft Visual SourceSafe. Additionally, you can check your files in and out of repositories using commands in Repository Explorer.

Do the adapters support connection pooling?

Yes. Pervasive data adapters JCA Resource Adapter interfaces with the Oracle Application Server. Pervasive data adapters for Oracle AS Web Services and JCA via integration server have a pool of instances of the engine.

Do the adapters support load balancing?

Yes. The adapters are called via Engines (through instances of in-memory code called at runtime) that can be deployed across several CPUs. This allows vertical scaling - the ability to spawn multiple adapter instances on a multi-CPU SMP server.

Pervasive will support WSDL bindings to JMS in the next release. This will allow multiple, physically separate servers to listen to a single JMS queue, thus providing the ability to do horizontal load balancing.

What are the security features of the adapters?

The Pervasive data adapters security features utilize JAAS (Java Authentication and Authorization Services) and SSL encryption using JSSE (Sun Java Secure Socket Extension).

Do the adapters support Unicode?

Yes. Both Unicode delimited and Unicode fixed formats are supported.

Do the adapters provide delivery confirmations and error messages?

Yes. The adapters can be configured to send confirmations, error messages and even log files via email or to other SMTP capable devices.

What are the available client interfaces to Integration Server?

There are five client interfaces to the Integration Engine: Web Services, JCA Resource, Java API, COM API and Message-Driven Beans.

Start Integrating Now!

Thousands of organizations use Pervasive Integration. In just a few minutes, you can be one of them.

Click this button to get your free trial!

You will be asked to sign into the Pervasive site (if you do not have a user ID, it takes less than 30 seconds to create one).

If you have any questions, or experience any problems, please contact Pervasive