A DB2® federated
system is a special type of distributed database management system (DBMS).
A federated system consists of a DB2 instance that operates as a federated
server, a database that acts as the federated database, one or more data sources,
and clients (users and applications) that access the database and data sources.
With a federated system, you can send distributed requests to multiple data
sources within a single SQL statement.
Data sources
The workbench supports connecting to
a WebSphere® Information
Integrator federated database and accessing the remote data sources that are
defined to the federated database. This version of the workbench supports
access to the following data sources:
- DB2 family
data sources
- Informix® data
sources
- Microsoft SQL
Server data sources
- ODBC data sources, including Excel and WebSphere II Classic Event Publisher
by using an ODBC connection
- Oracle data sources
- Sybase data sources
- Teradata data sources
For more information on federated data sources, see the Information Integrator Federated Systems Guide.