Overview of federated data sources

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.


Feedback