Configuring access to Microsoft SQL Server data sources

To configure the federated server to access Microsoft SQL Server data sources, you must provide the federated server with information about the data sources and objects that you want to access.

Before you begin

• The ODBC driver must be installed and configured on the federated server.
• Federation must be installed on a server that acts as the federated server.
• Check the setup of the federated server.
• Check the federated parameter to ensure that federation is enabled.

1. Use one of the following methods to prepare the federated server and federated database depending on your operating system.
   • Prepare the federated server and federated database (Windows).
   • Prepare the federated server and federated database (UNIX).
2. Set the environment variables for the Microsoft SQL Server wrapper.
3. Register the wrapper.
4. Register the server definition.
5. Create the user mappings.
6. Test the connection to the Microsoft SQL Server remote server.
7. Register nicknames for Microsoft SQL Server tables and views.

Example

How to Query Microsoft SQL Server by using Db2 Federation SQL Server native wrapper