Configuring access to Teradata data sources

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

Before you begin

  • Teradata client software must be installed and configured on the server that acts as 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.

Procedure

  1. Test the connection to the Teradata server.
  2. Set the environment variables for the Teradata wrapper.
  3. Register the wrapper.
  4. Register the server definition.
  5. Create the user mappings.
  6. Test the connection to the Teradata server.
  7. Register nicknames for Teradata tables and views.