Use adapters and CCL queries to set up communication between Sybase CEP Engine and conventional databases.
Adapters (except in the case of kdb+ databases, for which Sybase does not support adapter use). For extensive information about adapters, see the Sybase CEP Integration Guide .
CCL queries, using the CCL database subqueries and Database Statements.
Database subqueries are subqueries within CCL Query Statements that retrieve data from external relational databases or CCL public windows by means of an SQL SELECT statement. Database subqueries do not modify the external databases.
Database Statements are CCL statements that send SQL UPDATE, INSERT and/or DELETE statements to an external relational database. Database Statements modify the data in external databases, but do not receive any data from the databases.
For information about database subqueries and Database Statements, see the Sybase CEP CCL Reference Guide .
In order for Sybase CEP Engine to communicate with databases using either of these features, you:
Should have a working ODBC or native Oracle OCI connection.
Modify the c8-services.xml file with the appropriate configuration information, as described in the database-related sections of this guide. This file contains groups of preferences, some of which relate to both adapter and CCL statement connections to databases, and other of which are applicable only if you are connecting to the database directly from CCL statements.
If you are using Oracle OCI with Sybase CEP Engine, you should also install and configure Oracle Client.