Remote Database Query Components

An overview of the software components required for Sybase CEP remote database queries and how they interact with one another.

The diagram below shows the components involved in remote database queries and how they are related.

Sybase CEP remote database query functionality requires the following software components:

• A .

• A remote database server.

• A Sybase CEP project (query module) that includes a CCL Statement that queries the remote database server. The CCL statement may be either a Database Statement or a database subquery. For more information about these CCL statements and clauses, refer to the Sybase CEP CCL Reference Guide .

• A section of the c8-services.xml file that describes the remote database server as a "service" and allows the Sybase CEP Server to call it. Describe each remote database server in a separate section of the c8-services.xml file.

• A database driver (such as an ODBC driver, a Native Oracle driver, or some other appropriate driver) that interfaces between Sybase CEP Server and the remote database server.

These components work together as follows:

1. The CCL Statement invokes the driver by specifying the service name (as identified in the c8-services.xml file) and passing the SQL statement.

2. The Sybase CEP Server uses the service name and the information defined for the service in the c8-services.xml file to determine which driver to use.

3. The driver communicates with the remote database server and passes the SQL statement. When appropriate, the driver receives values back from the remote database server and makes them available to Sybase CEP Server, which then makes the values available to the CCL query.

More details about the individual components can be found below.