The Component Integration Services (CIS) feature allows you to connect to remote Sybase and non-Sybase databases. It presents a uniform view of enterprise data to client applications and provides location transparency to the data sources that you access.
When you access both Sybase and non-Sybase databases on different servers, you can use the host data files, tables, triggers, views, remote procedure calls, and most commands in database systems such as Adaptive Server, Informix, DB2, and Oracle.
Component Integration Services can be used by anyone who needs to access multiple data sources or legacy data. It can also be used by anyone who needs to migrate data from one server to another.
A single server is often used to access data on multiple external servers. Component Integration Services manages the data regardless of the location of the external servers. Data management is transparent to the client application.
Figure 5-1: CIS connects to multiple vendor databases
Using Component Integration Services, you can:
Access tables in remote servers as if the tables were local.
Perform joins between tables in multiple, remote, and heterogeneous servers. For example, you can join tables between Adaptive Server and an Oracle DBMS, between Adaptive Server and Record Management System (RMS) files in OpenVMS, and between tables in multiple Adaptive Servers.
Use the select into command to transfer the contents of one table into a new table on any supported remote server.
Provide applications such as PowerBuilder®, Microsoft Access, and DataEase with transparent access to heterogeneous data.
Maintain referential integrity across heterogeneous data sources.
Access native remote server capabilities using the Component Integration Services passthrough mode.
For more information on using Component Integration Services, see the Component Integration Services User’s Guide.
