Adapters Supplied by Sybase CEP

This section describes the built-in input adapters and output adapters provided by Sybase CEP.

Below is a table that lists the adapters and the adapter "types". You'll need to know the adapter type if you use an ATTACH ADAPTER statement, for example,

ATTACH INPUT ADAPTER Adapter1
 TYPE ReadFromCsvFileAdapterType
 ...

In the preceding statement, the type "ReadFromCsvFileAdapterType" is the adapter type for the Read From CSV File adapter.

This table also contains links to the first page describing each adapter.

Note that only in-process adapters can be attached with the ATTACH ADAPTER statement, so only in-process adapters have an adapter type. In the tables below, out-of-process adapters have "N / A" as their adapter type.

• Atom Feed Reader Input Adapter
  The ATOM feed reader enables you to get information from ATOM data sources. ATOM data sources enable connections through URL and send their information in a special XML format.
• Binary: Read From Binary File Adapter
  A Read From Binary File adapter reads rows from a Sybase CEP binary file. This adapter is used for internal testing only.
• Binary: Write To Binary File Adapter.
  A Write To Binary File adapter writes rows to a Sybase CEP binary output file. This adapter is used for internal testing only.
• Comma-Separated Values (CSV): Read From CSV File Adapter.
  A Read From CSV File adapter reads Rows from a CSV file.
• Comma-Separated Values: Write To CSV File Adapter.
  A Write To CSV File adapter writes received rows to a CSV output file.
• Comma-Separated Values (CSV): Read From CSV Socket Adapter.
  A Read from CSV Socket adapter opens a TCP connection to a given address, specified through Host and Port properties. Once the connection is established, the adapter reads rows from this connection as comma-separated values.
• Comma-Separated Values (CSV): Write To CSV Socket Adapter.
  A Write to CSV Socket adapter opens a TCP connection to a given address, specified through Host and Port properties. Once the connection is established, the adapter writes Rows into this connection as comma-separated values.
• Database: Poll From DB Input Adapter
  The Poll From Database adapter reads information from a table on an external database server.
• Database: Read From DB Input Adapter
  The Read From Database adapter reads information from a table on an external database server and sends that data to a stream.
• Database: Write to DB Output Adapter
  The Write to Database adapter writes information to an external database server.
• Email: Send Email Out Adapter (SMTP)
  The Send Email Out adapter sends email messages with fixed "From", "To", "Cc", "Bcc", "Subject", and "Body" fields in every email message as configured in the Adapter.
• Java Email Output Adapter
  The Java Email Output adapter sends email to the specified recipient(s). When a row is received by this Adapter, the Row information is put into the body of an email message and then sent out.
• Ganglia Input Adapter
  The Ganglia adapter takes data from a Ganglia Monitoring System source and sends the rows to the Sybase CEP stream.
• JDBC Input Adapter
  The JDBC Input adapter attempts to establish a JDBC session with the specified database. It then executes the given query periodically based on the specified frequency.
• JDBC Output Adapter
  Provides information about configuring and connecting with the JDBC Output Adapter.
• JMS Adapter
  The JMS Adapter is an out-of-process adapter. You can configure the JMS Adapter as either an input adapter or an output adapter. Both adapters work with JMS messages that have message body type "MapMessage" or "TextMessage".
• Random Tuples Generator Adapter
  The Random Tuples Generator adapter –sometimes called the Random Messages Generator – is an input-only adapter that generates random tuples according to the given schema and sends the rows to the stream.
• RAP - The Trading Edition Adapters
  RAP - The Trading Edition™ writes in-bound market data to an in-memory cache database and a historical data store. Sybase CEP provides in-process and out-of-process RAP adapters to facilitate communication between the two products. This document assumes that you have installed RAP - The Traditing Edition ™ and are familiar with its components.
• Regular Expressions: Read From File Using a Regular Expression Adapter.
  The Read From File Using a Regular Expression adapter reads an input file line by line, matches each line against a given regular expression, and produces rows.
• Regular Expressions: Read From Socket Using a Regular Expression Adapter
  A Read from Socket Using a Regular Expression adapter opens a TCP connection to a given address specified through Host and Port properties. Once a connection is established, the adapter reads tuples from this connection line by line, matching each line against a given regular expression and producing tuples from subexpressions.
• RSS Feed Reader Adapter.
  An RSS Feed Reader adapter opens a connection to a given URL and, once a connection is established, reads rows from this connection.
• SNMP Get OIDs Adapter
  The Simple Network Management Protocol (SNMP) is an Internet-standard protocol for managing devices on IP networks. The SNMP Get OIDs Adapter enables you to receive SNMP information about system devices, network devices, and other devices.
• SNMP Set Adapter
  The SNMP Set Adapter enables you to send SNMP information. The SNMP is an Internet-standard protocol for managing devices on IP networks.
• SNMP Send V1 Traps Adapter
  The Sybase CEP Engine supports sending V1 traps.
• SNMP Send V2c Notifications
  The Sybase CEP Engine supports sending V2c notifications.
• XML: Read From XML File
  The Read From XML File adapter reads Rows from an XML file.
• XML: Read from XML Socket
  A Read from XML Socket adapter attempts to open a TCP connection to a given host and port address and, once connected, reads rows from the connection as XML.
• XML: Write To XML File Adapter.
  A Write To XML File adapter writes received rows to an XML file. If the file already exists, the adapter overwrites it.
• XML: Write to XML Socket
  A Write to XML Socket adapter attempts to open a TCP connection to a given host and port address and, once connected, writes rows to the connection as XML.
• XML: Write XML Over HTTP Adapter.
  For each message this adapter receives, it posts the message in XML format to an HTTP server
• Windows Event Log Adapter
  The Windows Event Log adapter reads from a Microsoft Windows event log and publishes the event information to a Sybase CEP stream.