Use an output stream or window to publish data from
Event Stream Processor to an external datasource.
Backslashes in CCL files generate errors, because in that context, they
are control characters.
- Assess the output data, determining which sets or subsets of data
you want to send to an external datasource.
- 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.
- Create an output stream or window.
- Use the CREATE SCHEMA statement to define the structure for
outgoing data within this stream or window.
- (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.
- Start the ESP project. If you are using an
unmanaged adapter, start the adapter manually.
Next
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.