Multiple Integration Engine interfaces for flexible, scalable automation
The Pervasive Integration Engine™ is a data transformation engine used to reliably and quickly power data and application integration. This embeddable, small-footprint software allows users to automatically share data between multiple databases and data files of nearly any format, including SaaS applications.
Control
- The command line interface enables you to schedule operations and to customize transformations and processes at runtime.
- COM and Java APIs let you call transformations and processes from within your own applications, delivering embedded integration.
- Pervasive's Integration Services delivers integration as a robust service for SOA and Web service environments.
- The XML metadata process and map specifications are open, allowing direct, programmatic manipulation of the instructions that control the Integration Engine.
Extend
Pervasive Universal CONNECT! allows you to quickly and easily extend:
- the Integration Engine's functionality by adding custom object processing to integration workflows
- connectivity to include virtually any on-premises or on-demand application
The flexible Pervasive Integration Engine supports the following operating systems: Windows XP, Windows Server 2003, Windows Vista Enterprise, Business, and Ultimate, as well as Linux, SUSE, RHEL, AIX, HP-UX and Solaris.
Scheduled and Event-Driven Operations
The Integration Engine command line interface loads a specified transformation or process, makes the overrides requested by any command line options and executes. The command line has the ability to issue overrides for many parts of the transformation or process specifications, including options like SQL pass-through and record selection criteria. The command line also supports the notion of a default transformation for very simple mapping situations. All the minimum information necessary for specifying a transformation can be entered directly on the command line, and a map created on the fly dynamically.
- Source and target connection overrides – This can range from simply pointing to different source or target files, to enumerating all the options necessary to connect to multiple SQL tables. Both file and table wildcards are supported.
- Sophisticated error trapping, logging levels, and progress checking
- Dynamic query statements to use on source data
- Runtime overrides of record extraction filters operating on the source data, including input variables to Boolean expressions and record ranges
- Control of reject files
- Support for return codes and operational information
- Scalable granularity for interrogating or managing engine behavior
The Engine command line provides an interface for launching transformation maps and processes directly from the operating system command line, batch files or system schedulers.
Embedding the Integration Engine in Applications
The Pervasive Integration Engine API allows seamless integration with other programs and extensive control of the engine process. Interaction with applications that embed the Integration Engine is generally accomplished via the COM or Java APIs. In addition to executing predefined transformations and processes, the API can be used to automatically create, map and run simple default transformations. The functionality provided by the API provides for tight control of connection parameters, error handling, and on-the-fly filtering and parameter changes. The Pervasive Integration Engine SDK fully documents the capabilities of the APIs.
In addition to the standard command line options, the embedding application has control over the following integration engine functions:
- Configure the Integration Engine environment
- Manage source and target data connections
- Execute, terminate, load, unload and query transformation information
- Control error trapping and logging levels
- Query field attributes, primary key information, field counts and values
- Manage target output through record sampling and filtering
- Manage progress and status handling
- Set the reject file and query its entries
- Execute transformations in a transaction
- Set target update or delete operations and query the results
Cloud Integration and SOA
Pervasive integration products can be be deployed as a distributed, fully managed set of Service Oriented Architecture (SOA) adapters. Full integration processes can also be published as data services or web services. Pervasive also offers integration in the cloud, hosted either in the customer’s data center for SaaS vendors and BPOs or in our data center on Amazon for end users who don’t want to install a new software tool.
The Pervasive architecture supports SOA frameworks with rich connectivity to many messaging environments such as JMS, SonicMQ, MSMQ, Oracle AQ, and WebSphere MQ as well as to alternative queue-like technologies such as email or FTP servers, in which an email or a file represents the message. In addition, the Integration Services API makes integration processes and maps exposable as robust standards-based Web Services. Each instance of Integration Engine runs in its own address space. This isolation increases performance and reliability.
Other supported or included technologies:
- J2EE application servers
- A purpose-built Message Driven Bean (MDB)
- All SOAP standards for WSDL-described and other Web services supported, including SOAP encoded arrays
Metadata-driven Integration via Direct Specification Control
A non-proprietary XML repository houses all specifications and rules that define Pervasive integration execution and workflow. This essentially provides another programmatic interface to alter the instructions that control the behavior of the Integration Engine.
Benefits
- Full compatibility with a variety of source control systems for shared project development
- Integration process designs that can be easily and directly manipulated by other applications
- Reduced development time and costs since individual components are sharable between users and integration tasks
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
