ECDA Option for Oracle provides Open Client access to Oracle databases. It works either with the Component Integration Services feature of Adaptive Server called Adaptive Server/CIS or as a standalone gateway.
When used with Adaptive Server, ECDA Option for Oracle transforms the Transact-SQL generated by Adaptive Server 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 Adaptive Server. This combination enables location transparency, distributed query optimization, copy transparency, transaction transparency, and distributed joins.
When used with Adaptive Server, you can join Oracle tables with Adaptive Server, DB2, or other tables. Access to these objects through Adaptive Server is transparent to the application. ECDA Option for Oracle is used with Adaptive Server/Component Integration Services (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.