Federated three-part names

With federated three-part names, you can reference remote objects directly. When you reference remote objects directly, you do not need to create nicknames for the remote objects.

Federated three-part names are very useful for environments in which the federated server accesses a large amount of remote tables. In previous releases, in addition to setting up the servers, you had to create nicknames for all of the tables that you want to access. Federated three-part names allow you to issue SQL statements against any data that you are authorized to access in a set of servers. When you use federated three-part names, you no longer need to create nicknames.

The metadata for remote objects referenced in federated three-part names is retrieved at runtime. This feature makes improves synchronization of locally stored metadata with remote servers.

Federated three-part table names are supported for all relational data sources.