Remote Procedure Calls, Database Queries, and Public Windows

An overview of how to integrate your Sybase CEP Server with remote servers.

Sybase CEP Server can retrieve data from input adapters. Sybase CEP Server can also retrievedata from, or invoke processing on, Remote Procedure Call (RPC) servers and database servers (for example, Oracle, MySQL, SQLServer, and so on).

You can write a program that reads data from a public window (a window that exists inside Sybase CEP Server but can be accessed from outside Sybase CEP Server as though the window were a database table.)

Please note that this chapter does not completely document this topic. For more information, see:

• Sybase CEP Installation Guide : This explains how to configure your c8-services.xml file to tell your Sybase CEP Server how to connect to remote servers.

• Sybase CEP CCL Reference Guide : This documents the CCL language statements and clauses that are capable of accessing remote servers. The Sybase CEP CCL Reference Guide also documents the CREATE PUBLIC WINDOW statement (which is used to create a public window that can be accessed externally) and Sybase CEP's SQL (which can be used to query a public window.)

• Remote Procedures
  This section describes how to call a remote procedure from a CCL statement.
• Remote Database Queries
  This section describes remote database queries.
• Remote Requests, Synchronization, and Performance
  The semantics of the CCL language require that rows be kept in chronological order and processed in chronological order.
• Public Windows
  Various components can query public windows, including Sybase CEP Projects, SDKs, and the Sybase CEP public windows ODBC driver.