Show TOC

Publishing Data with Output AdaptersLocate this document in the navigation structure

Use an output stream or window to publish data from Event Stream Processor to an external datasource.

Procedure

  1. Assess the output data, determining which sets or subsets of data you want to send to an external datasource.
  2. Choose an output adapter suited for this task.
    If the output destination uses datatypes that are not supported by the ESP Server, the Server maps the data to an accepted datatype. Review the associated mapping description for your adapter in the SAP Event Stream Processor: Adapters Guide to ensure that the resulting datatype is permitted by the external data destination.
  3. Create an output stream or window.
  4. Use the CREATE SCHEMA statement to define the structure for outgoing data within this stream or window.
  5. (Skip this step if using an unmanaged adapter) Use the ATTACH ADAPTER statement to attach your adapter to the output stream or window, and set values for the adapter properties.
    To declare default parameters for your adapter properties, use the DECLARE block and parameter qualifier to define default parameter values before you attach your adapter. Once you create the ATTACH ADAPTER statement, you can set the adapter properties to the parameter values you declared.
    Note You can bind declared parameters to a new value only when a module or project is loaded.
  6. Start the ESP project. If you are using an unmanaged adapter, start the adapter manually.

Next Steps

For detailed information on configuring individual Event Stream Processor-supplied adapters, datatype mappings, and schema discovery, see the SAP Event Stream Processor: Adapters Guide.

Backslashes in CCL files generate errors, because in that context, they are control characters. For detailed information on CCL queries and statements, such as the ATTACH ADAPTER, CREATE SCHEMA, and DECLARE statements, see the SAP Event Stream Processor: CCL Reference.