Adaptive Server is provided with ECDA for the Component Integration Services (CIS) functionality. With Adaptive Server/Component Integration Services (CIS), your client applications can view and change data on multiple, heterogeneous data servers as if it were single-source data.
Adaptive Server/CIS performs datatype transformations and enables heterogeneous joins.
Adaptive Server/CIS allows users to access both Sybase and non-Sybase databases on different servers. These external datasources include host data files and tables, views, and remote procedure calls (RPCs) in database systems such as Adaptive Server, Oracle, Microsoft SQL Server, and DB2 UDB.
Using Adaptive Server/CIS, you can:
Access tables and views that reside on remote servers as if they were local objects.
Perform joins between tables in multiple remote, heterogeneous servers. For example, you can join tables between an Oracle DBMS and DB2 UDB, and between tables in multiple DB2 UDB database servers.
Create stored procedures that work with distributed heterogeneous data.
Transfer the contents of one table into a new table on any supported remote server using a select into statement.
Provide applications, such as PowerBuilder®, Microsoft Access, and DataEase, with transparent access to heterogeneous data.
Maintain referential integrity across heterogeneous datasources.
Access native remote server capabilities using the Component Integration Services passthrough mode.
Map RPCs into proxy table structures and perform operations on them as though they were local tables.