ECDA Option for Oracle provides Open Client™ access to Oracle databases. It operates in conjunction with the Component Integration Services feature of Adaptive Server Enterprise (ASE/CIS) or as a standalone gateway.
When used with ASE, ECDA Option for Oracle transforms the Transact-SQL generated by ASE to Oracle's native SQL. ECDA Option for Oracle also handles datatype mapping between Sybase datatypes and Oracle datatypes. ECDA Option for Oracle provides many of the features of a distributed database system when used in combination with ASE. This combination enables location transparency, distributed query optimization, copy transparency, transaction transparency, and distributed joins.
When used with ASE, you can join Oracle tables with ASE, DB2, or other tables. Access to these objects through ASE is transparent to the application. ECDA Option for Oracle supports full, two-phase commit transaction management.
In standalone mode, ECDA Option for Oracle provides client applications with an Open Client interface to Oracle databases. To the client it appears as an Open Server™ application that understands Oracle SQL.
