Enterprise Connect Data Access Capabilities

ECDA provides transparent access to a variety of datasources for Adaptive Server.

The DirectConnect server and other components of ECDA are also included with Replication Server Options, in each case providing Replication Server the capability to replicate to heterogeneous databases including DB2 UDB and Microsoft SQL Server.

Transparent Access

With ECDA, you can:

Create interfaces that let developers, applications, and users work with familiar tools—no matter how your business enterprise changes or what new technologies are added.
Access information on remote, heterogeneous data servers as if it were from a single source.
Connect to DB2 UDB, Microsoft SQL Server, and Oracle using the appropriate ECDA Option, either directly or with Adaptive Server/Component Integration Services (CIS) or Replication Server.
Connect to other ODBC-compliant databases using ECDA Option for ODBC and an appropriate ODBC driver, either directly or with Adaptive Server/CIS or Replication Server.

Interoperability

ECDA interoperates with other Sybase products and product suites, such as Adaptive Server, Replication Server, and Sybase^® IQ. With ECDA, these products can access non-Sybase data.

ECDA also supports a variety of client interfaces, including:

Client applications written either in Java using jConnect^™ for JDBC^™, or in C/C++ using Open Client^™ libraries
Open Server^™ applications
JDBC applications

Data Management

Because ECDA helps you manage your enterprise data, you can:

Share data efficiently throughout your organization by moving it in bulk form between datasources using the ECDA Option for ODBC transfer feature or the Adaptive Server select into statement.
Manage ECDA services and Sybase components using Sybase Central.