Attach an output adapter to the ESP
Server using an ATTACH ADAPTER statement and publish data to an external
datasource. If you wish to configure, start, and stop an adapter independently of the
ESP Server (known as an unmanaged adapter), do not
reference the adapter in the ATTACH ADAPTER statement.
When specifying paths, use forward slashes for both Windows and UNIX. If you use back
slashes in a CCL file, an error displays because a back slash indicates a control
character.
- Assess the output data. Determine 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
parameters 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.