Creating the user mapping for a Teradata data source

When you attempt to access an Teradata server, the federated server establishes a connection to the Teradata server by using a user ID and password that are valid for that data source.

About this task

Create a user mapping for each user ID that will access the federated system to send distributed requests to the Teradata data source.

Procedure

Issue a CREATE USER MAPPING statement.

For example:

CREATE USER MAPPING FOR local_userID SERVER server_definition_name
       OPTIONS (REMOTE_AUTHID 'remote_userID', REMOTE_PASSWORD 'remote_password')

Although the REMOTE_AUTHID and REMOTE_PASSWORD variables are specified as options in the CREATE USER MAPPING statement, these options are required to access Teradata data sources.

What to do next

After you complete this task, test the connection from the federated server to the Teradata server.