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 called 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 is used with ASE/CIS to support full, two-phase commit transaction management.

When used with Replication Server, the ECDA Option for Oracle allows you to replicate data into Oracle tables.