2.06 - Usage Notes - Teradata QueryGrid

Teradata® QueryGrid™ Installation and User Guide

Product
Teradata QueryGrid
Release Number
2.06
Published
September 2018
Language
English (United States)
Last Update
2018-11-26
dita:mapPath
blo1527621308305.ditamap
dita:ditavalPath
ft:empty
  • The target platform of the foreign server object must be running and reachable when you create the foreign server object for it in Teradata Database.
  • You can create multiple named foreign server objects that reference the same server using the same link.
  • Foreign server object names that are stored in TD_SERVER_DB must be unique.
  • Name value pairs in the server area of the syntax apply to the connection to the remote platform and to both of the table operators specified in the IMPORT WITH and EXPORT WITH clauses.
  • Server options, names, and name value pairs can appear only once in the CREATE FOREIGN SERVER syntax.
  • The order of the DO IMPORT WITH and DO EXPORT WITH clauses in the CREATE SERVER syntax does not matter.
  • You must grant SELECT, INSERT, and SHOW privileges on foreign server objects to users who need to query foreign server objects.
  • The use of the EXTERNAL SECURITY clause is required when the target platform uses credentials for authentication. This applies for Trusted, Kerberos, or LDAP.