Configuring multiple federated servers to access data sources

A federated system can consist of multiple federated servers. Instead of configuring each federated server separately, you can save time by using IBM® Data Studio to configure the federated servers.

Before you begin

  • Federation must be installed on a server that will act as the federated server
  • A federated database must exist on the federated server.

About this task

For supported Db2® data sources and for the Oracle data source, you can use the Data Studio Administration Explorer to configure the federated objects for the data source that you want to access. After you configure the first server, you can reuse or modify these statements to quickly configure additional federated servers.

You can also use the Data Studio SQL and XQuery editor to configure multiple servers for any data source.

Procedure

Configure multiple federated servers by using one of the following methods.