2.10 - Migrating 1.0x Teradata Foreign Server Definitions to 2.0x Teradata Connectors - Teradata QueryGrid

Teradata® QueryGrid™ Installation and User Guide

prodname
Teradata QueryGrid
vrm_release
2.10
created_date
September 2019
category
Administration
Configuration
Installation
User Guide
featnum
B035-5991-099K
QueryGrid 2.0x Teradata connectors are compatible with the SQL data manipulation language used for QueryGrid 1.0x Teradata-to-X connectors. In 2.0x, if you want to use the same SQL you use with your 1.0x connectors, you can migrate your 1.0x foreign server definitions for use with 2.0x connectors.

The following procedure preserves the FOREIGN SERVER grants and access rights for users.

  1. Stop all queries running on the QueryGrid 1.0x foreign server.
  2. For the FOREIGN SERVER used on QueryGrid 1.0x, type the following to display the FOREIGN SERVER description, the list of custom clauses, and the import and export functions used for the FOREIGN SERVER:
    SHOW FOREIGN SERVER bock_classic2;
    CREATE FOREIGN SERVER TD_SERVER_DB.bock_classic2
    EXTERNAL SECURITY INVOKER TRUSTED UT1PROXY3 USING
    Hosttype  ('Teradata')
    remotehost  ('bock1.labs.teradata.com')
    ip_device  ('byn1')
    port  ('5000')
    read_timeout  (200 )
    listen_timeout  (60 )
    concurrentstreams  (1 )
    DO IMPORT WITH SYSLIB.LOAD_FROM_TD ,
    DO EXPORT WITH SYSLIB.LOAD_TO_TD ;
    
  3. Drop all old NVPs from the QueryGrid 1.0x foreign server.
    ALTER FOREIGN SERVER TD_SERVER_DB.bock_classic2 DROP hosttype, drop remotehost, drop ip_device, drop port, drop read_timeout, drop listen_timeout, drop concurrentstreams, drop IMPORT, drop EXPORT;
  4. Add the new NVPs to the QueryGrid 1.0x foreign server.
    ALTER FOREIGN SERVER TD_SERVER_DB.bock_classic2 ADD link(‘bock_ng’), add IMPORT WITH TD_SYSFNLIB.QGINITIATORIMPORT, add export with TD_SYSFNLIB.QGINITIATOREXPORT;
  5. Show the new 2.0x FOREIGN SERVER.
    SHOW FOREIGN SERVER bock_classic2;
    CREATE FOREIGN SERVER TD_SERVER_DB.bock_classic2
    EXTERNAL SECURITY INVOKER TRUSTED UT1PROXY3 USING
    LINK(‘bock_ng’)
    DO IMPORT WITH TD_SYSFNLIB.QGINITIATORIMPORT,
    DO EXPORT WITH TD_SYSFNLIB.QGINITIATOREXPORT;
    
    For more information about configuring the 2.0x foreign server with QueryGrid 2.0x name value pairs, see: