Managing federated databases—connecting to Oracle and MSSQL

A federated database allows client applications to see their data as a single database, even though the data itself can be located across different databases, or even databases created with another RDBMS such as Oracle or MSSQL.

Getting ready

IBM InfoSphere Federation Server must be installed. You can either choose to install a new copy of DB2 Enterprise Server Edition Version 9.7 or install Federation Server on top of an existing copy.

Since DB2 acts as a client for the remote databases, the client software for the databases you want to access must be installed on the same system as the federated server. For Oracle databases, you will need Oracle Net Client. Make sure you can do a tnsping and access your remote database with sqlplus.

[ora10g@nodedb21 ~]$ tnsping ERP10R2
TNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on 19-JUN-2011 15:34:00
Copyright (c) 1997, 2005, Oracle.  All rights reserved.
Used parameter files:
Used...