ECDA Option for Oracle Architecture

ECDA Option for Oracle works with Adaptive Server, Replication Server® and other APIs.

Before you configure ECDA Option for Oracle, you must have a basic understanding of how it works:

  • ECDA Option for Oracle is a symmetric multiprocessing (SMP) Sybase Open Server application that uses an Open Server thread for each incoming client connection.

  • It uses the DirectConnect™ server to route the incoming client connection to the correct service based on the service name and has one Oracle process for each DirectConnect server.

  • It does not have a service library, but can have multiple services, and each service is configured to connect to a different Oracle database. In addition, the DirectConnect server performs SQL transformation and some data translation based on the configuration of the service.

  • It accesses Oracle databases using the Oracle Call Interface (OCI) application programming interface (API). The OCI allows the ECDA Option for Oracle to manipulate data in an Oracle database.

  • It communicates with Adaptive Server using the server class direct_connect.



As shown in the diagram, the request from a client uses a TCP/IP LAN connection to the DirectConnect server. Based on the incoming server name, the DirectConnect server routes the connection using OCI to the proper Oracle database depending on the configuration properties.

Parent topic: ECDA Option for Oracle