Open Adapter

The Sybase Event Stream Processor Open adapter is a version of the open-source openadapter™ (openadapter.org).

A range of adapters is available for common applications and middleware environments, such as Web services and various file types. Each adapter can be used with a variety of readers and writers to parse and format different types of messages (for example, delimited field records or XML documents). The records coming in through the adapter can include an ESP_OPS column that indicates the database operation to perform with the record.

i, I, insert, or INSERT indicates an insert.
p, P, upsert, or UPSERT indicates an upsert.
u, U, update, or UPDATE indicates an update.
s, S, safedelete, or SAFEDELETE indicates a safedelete.
d, D, delete, or DELETE indicates a delete.

If you use the ESP_OPS column, ensure every record in this column has a value.

An Open adapter is defined by an adapter properties file, and includes a number of components that move data from one or more source components to one or more sink components. You may also configure intermediate components (pipes) to perform additional processing on the data. In a system where a number of possible adapters can run, each adapter runs as a separate instance that you start and control individually.

Note: On Microsoft Windows, use double backslash \\ as separator in paths, class paths, and URLs.

The Open adapter requires a separately purchased license. This license supports the standard SySAM grace period, meaning it can run unlicensed for 30 days. After this period, the adapter cannot run without a valid license.

If you purchased your product from Sybase or an authorized Sybase reseller, go to the secure Sybase Product Download Center (SPDC) at https://sybase.subscribenet.com and log in to generate license keys. The license generation process may vary slightly, depending on whether you ordered directly from Sybase or from a Sybase reseller.

If you ordered your product under an SAP contract and were directed to download from SAP Service Marketplace (SMP), you can use SMP at http://service.sap.com/licensekeys to generate license keys for Sybase products that use SySAM 2-based licenses.

Datatype Mapping for the Open Adapter
Event Stream Processor datatypes map to Open adapter datatypes.
Setting the JAVA_HOME Environment Variable
Set the JAVA_HOME environment variable to point to the Java directory.
Configuration
The adapter properties (.props) files are text files that contain configuration information for the components to be invoked for an adapter.
Starting the Open Adapter
Start an Open adapter instance via a bootstrap class.
Monitoring the Open Adapter
Monitor a running adapter using RemoteControl and RemoteLogger interfaces.
Examples
See examples of how to operate different Open adapter components.

Parent topic: External Adapters