Open Input and Output Adapter

The SAP 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. You can use each adapter 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 a forward slash as a separator in paths, class paths, and URLs.

The Open adapter requires a separately purchased license that you can obtain from the SAP Product Download Site. It 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 SAP or an authorized SAP reseller, go to the secure SAP 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 SAP or from an SAP 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 SAP products that use SySAM 2-based licenses.

Tips for Migrating Your Open Adapter Scripts
Tips for migrating your Open adapter scripts from Aleri Streaming Platform (ASP) to Event Stream Processor.
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
Different Open adapter components.

Parent topic: Adapters Currently Available from SAP