Configuring access to Informix data sources

To configure a federated server to access Informix® 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 Informix Client SDK software must be installed and configured on the server that will act as the federated server.
  • Check the setup of the federated server.
  • Check the federated parameter to ensure that federation is enabled.
  • On AIX® federated servers, the AIX Base Application Development Math Library must be installed. You can determine if the Library is installed by issuing the AIX command lslpp -l bos.adt.libm.

About this task

Restrictions

The Informix wrapper is not supported in trusted mode on SuSE Linux® Enterprise Server, Version 9.2 or later.

Procedure

  1. Set up and test the Informix client configuration file.
  2. Set the Informix environment variables.
  3. Register the wrapper.
  4. Register the server definition.
  5. Create the user mappings.
  6. Test the connection to the server.
  7. Register nicknames for Informix tables, views, and synonyms.