Federation: 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.

About this task

You can configure a federated server to access data that is stored in Teradata data sources by using the DB2® Control Center or by issuing SQL statements on the DB2 command line. The DB2 Control Center includes a wizard to guide you through the steps that are necessary to configure the required federated objects.

Procedure

To configure access to Teradata data sources:

Test the connection to the Teradata server.
Verify that the Teradata library is enabled for run-time linking (AIX®).
Set the environment variables for the Teradata wrapper.
Register the wrapper.
Register the server definition.
Create the user mappings.
Test the connection to the Teradata server.
Register nicknames for Teradata tables and views.