Chapter 1: Introducing Enterprise Connect Data Access  Enterprise Connect Data Access capabilities

Chapter 1: Introducing Enterprise Connect Data Access

What is Enterprise Connect Data Access?

Enterprise Connect Data Access is an integrated set of software applications and connectivity tools that you use to access data within a heterogeneous database environment. ECDA gives you the ability to access a variety of LAN-based, non-Sybase data sources, as well as mainframe data sources. It consists of components that provide transparent data access within an enterprise, including access to servers housed on z/OS, AS400, UNIX, Linux, and Microsoft Windows platforms.

NoteMainframe Connect Integrated Product Suite (IPS), a suite of products you can purchase separately, allows you to access and integrate mainframe data and applications. See “Mainframe Connect IPS” for more information.

Using ECDA, you can maintain a corporate view of distributed operations, even when distributed business units run on a variety of hardware and database management system (DBMS) platforms. Because ECDA is database-independent middleware, it allows LAN-based clients to see a consistent picture of enterprise data, no matter what the data source.

ECDA components allow applications to interact with non-Sybase DBMSs, such as DB2 UDB, Informix, Microsoft SQL Server, and Oracle, as well as Sybase DBMSs, including Adaptive Server Enterprise (ASE), Adaptive Server Anywhere, and Sybase IQ.

Sybase Central plug-ins

Sybase Central™ is a graphical tool that provides a common interface for managing Sybase products. Each server product is managed by a service provider “plug-in” that operates in parallel with other service providers in the Sybase Central framework.

Sybase Central displays a visual representation of servers and provides a point-and-click interface for choosing options.

ECDA provides the following Sybase Central plug-ins:





Copyright © 2005. Sybase Inc. All rights reserved. Enterprise Connect Data Access capabilities

View this book as PDF