Create a Foreign Server | Teradata Studio - Creating a Foreign Server - Teradata Studio

Teradata® Studio™ User Guide

Product
Teradata Studio
Release Number
17.00
Published
January 2021
Language
English (United States)
Last Update
2021-01-11
dita:mapPath
lex1576517377362.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2041
lifecycle
previous
Product Category
Teradata Tools and Utilities

Creating a foreign server requires the CREATE SERVER privilege on the database that stores the server objects. Associating a server with table operators requires the EXECUTE FUNCTION and SELECT privileges on those table operators.

See Granting and Modifying Object-Level Privileges for more information on granting the relevant privileges.

  1. In the Navigator view, double-click Foreign Servers.
  2. In the Object List Viewer toolbar, click "" .
  3. Click General.
    1. In Name, type the name of the foreign server object; for example, hcatalog_server.
    2. In Host Type, specify the type of the host; for example, hadoop.
    3. [Optional] In Comment, type any 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. [Optional] In Trusted Credential, select a security type from the list.
      Option Description
      Definer Indicates the authorization describing the trusted remote user credentials is present in the database that contains the foreign server.
      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.
    2. In Authorization, type the name for the authorization.
  5. 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 are automatically generated as available using pairs. The pairs are global attributes of the server object. The host type name value pair is always displayed as the first in the name value pairs table; other pairs cannot be moved above it.
    Name value pairs for host type must be edited in the General tab.
    Button Action
    Add
    1. Click Add.
    2. Click in the Value Type column and select the type.
      • If you selected Simple Value or Scalar SubQuery Value, enter the name in the Name column and the value or subquery in the Value column.
      • If you selected System Variable Value, enter the Name, click in the Value column, and select a system variable.
    Remove Removes the selected name value pair
    Up Moves the selected name value pair up in the list order
    Down Moves the selected name value pair down in the list order
  6. [Optional] Click Import to associate an IMPORT table operator with this foreign server for importing data into Vantage.
    The name value pairs you create to import data are local attributes of the IMPORT table operator.
    1. In Database, select the name of the database containing the import table operator.
    2. In Table Operator, select 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 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 Vantage.
    The name value pairs you create to export data are local attributes of the EXPORT table operator.
    1. In Database, select the name of the database containing the export table operator.
    2. In Table Operator, select 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 export data.
  8. [Optional] Click SQL to view the generated DDL.
  9. Click Commit.