16.00 - Altering Foreign Server Properties - Teradata Studio

Teradata Studio User Guide

prodname
Teradata Studio
vrm_release
16.00
created_date
March 2017
category
User Guide
featnum
B035-2041-126K
You can modify certain attributes of an existing foreign server object, such as the name value pairs associated with the server.
  1. In the Navigator pane of the Administration perspective, right-click on Foreign Servers and select Show Foreign Servers from the pop-up menu. A list of foreign servers displays in the Object List Viewer.
  2. In the Object Viewer, right-click on the desired foreign server and select Modify Foreign Server from the pop-up menu. The Foreign Server property form displays in the Details view.
  3. [Optional] Click General to edit foreign server information: You cannot edit the name of the foreign server.
    Option Description
    Host Type Change the type of the host.
    Comment Change the comments for the foreign server.
  4. [Optional] Click Security to specify the name and security type for the authorization that stores the credentials for the foreign server.
    1. In Trusted Credential, select a security type from the list.
      • Definer — Indicates the authorization that describes the trusted remote user credentials is present in the database that contains the foreign server. You can specify either a Definer or an Invoker, but not both.
      • Invoker — Indicates the authorization that describes the trusted remote user credentials is present in the user database at the time the foreign server is accessed. You can assign only one INVOKER authorization name per database.
      • None — Indicates that this foreign server does not support associated credentials.
    2. In Authorization, change the name for the authorization.
  5. [Optional] Click Name Value Pairs and identify the name value pairs that the table operators can use to connect to this foreign server. Name value pairs for host type, remote server, and port are automatically generated as available using pairs. Changing the server information in General, changes the name value pairs. The pairs are global attributes of the server object.
    • To add a name value pair, click the Add button and type a name in the Name column and the value in the Value column.
    • To edit a name value pair, change the name in the Name column or the value in the Value column, and click Add.
    • To remove a pair, select the name value pair and click Remove. You cannot remove the host type, remote server, or port using pairs.
    • To move a pair up in the list order, select the name value pair and click Up.
    • To move a pair down in the list order, select the name value pair and click Down.
  6. [Optional] Click Import to associate an IMPORT table operator with this foreign server for importing data into Teradata Database. These name value pairs are local attributes of the IMPORT table operator.
    1. In Database, type the name of the database that contains the import table operator.
    2. In Table Operator, type the name of the table operator to use.
    3. In Name Value Pairs, use the Add, Remove, Up, and Down buttons to create a list of name value pairs that this table operator uses to import data.
  7. [Optional] Click Export to associate an EXPORT table operator with this foreign server for exporting data out of Teradata Database. These name value pairs are local attributes of the EXPORT table operator.
    1. In Database, type the name of the database that contains the export table operator.
    2. In Table Operator, type the name of the table operator to use.
    3. In Using Pairs, use the Add, Remove, Up, and Down buttons to create a list of name value pairs that this table operator uses to export data.
  8. Click SQL to view the generated DDL that changes the foreign server definition.
  9. Click Commit to execute this statement.