Configuring access to SAP Sybase data sources

To configure a federated server to access Sybase 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 Sybase client software must be installed on a server that will act as the federated server. When you install the Sybase client on Windows, you must specify the Full or Custom option. If you specify the custom option, you must the XA Interface Library for ASE Distributed Transaction Manager option.
• Federation component 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. Set the Sybase environment variables.
2. Set up and test the Sybase client configuration file using one of the following methods depending on your operating system:
   • Set up and test the Sybase client configuration file (Linux®, UNIX).
   • Set up and test the client configuration file (Windows)
3. Register the wrapper.
4. Register the server definition.
5. Create the user mappings.
6. Test the connection to the Sybase server.
7. Register nicknames for Sybase tables and views.