ECDA Option for Oracle provides Open Client™ access to Oracle databases. It works with the Component Integration Services feature of Adaptive Server® Enterprise (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 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 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 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.