Accessing External Databases

Sybase CEP Engine can communicate with external data sources via input and output adapters.

These external data sources are diverse and may include relational databases. However, in the special case of relational databases, Sybase CEP provides additional means of communication with the database directly from within CCL queries, without using input or output adapters. This chapter teaches you how to write CCL statements that exchange data with external relational databases.

Sybase CEP supports CCL connections to external databases that use a standard OBDC driver, or, for use with the Oracle relational database, the Oracle native driver. To use the features described in this chapter, you must first obtain and install the appropriate driver on your machine and then configure the Sybase CEP connection with the external database. For more information on installing and configuring your database connection, please refer to the Sybase CEP Installation Guide.


Created March 8, 2010. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com