Publishing Data with Output Adapters

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

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 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.

For detailed information on configuring individual Event Stream Processor-supplied adapters, datatype mappings, and schema discovery, see the Adapters Guide. For detailed information on CCL queries and statements, such as the ATTACH ADAPTER, CREATE SCHEMA, and DECLARE statements, see the Programmers Reference Guide.