Creating a Foreign Server - Teradata Studio

Teradata Studio IDE Plug-in User Guide
Product
Teradata Studio
Release Number
15.11
Published
May 2016
Language
English (United States)
Last Update
2018-05-03
dita:mapPath
xjy1467322272664.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2043
lifecycle
previous
Product Category
Teradata Tools and Utilities

To define a foreign server, you must have CREATE SERVER privilege on the database that stores the server objects. To associate a server with table operators, you must also have EXECUTE FUNCTION and SELECT privileges on the specified table operators.

  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 List Viewer toolbar, click (Create Foreign Server). The Foreign Server property form appears in the Details view.
  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. In Remote Server, type the DNS host name or IP address of the foreign server.
    4. In Port, type the port number the foreign server uses.
    5. [Optional] In Comment, type 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. [Optional] 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.
    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, remote server, and port are automatically generated as available using pairs. The pairs are global attributes of the server object. These name value pairs are always displayed as the first three in the name value pairs table (other pairs cannot be moved above them).
    Name value pairs for host type, remote server, and port must be edited from the General tab.
    • To add a name value pair, click Add and type a name in the Name column and the value in the Value column.
    • To remove a pair, select the name value pair and click Remove.
    • 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. The name value pairs that you create for importing data are local attributes of the IMPORT table operator.
    1. In Database, select 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. The name value pairs that you create for exporting data are local attributes of the EXPORT table operator.
    1. In Database, select 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 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. Click SQL to view the generated DDL that creates the foreign server.
  9. Click Commit to execute this statement.