2.06 - Completing the Teradata Initiator Connector Installation on Teradata Database Nodes (Viewpoint 16.10) - 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
On systems with Viewpoint 16.10, use the following procedure to complete the installation of the Teradata connector components.
When you add a connector to a fabric, QueryGrid performs the following tasks on the Teradata Database initiating nodes in the system:
  • Creates the directories required for completing the installation
  • Installs the Teradata connector package. The Teradata connector package includes a stored procedure that provides a simple interface for executing basic SQL queries
The procedure includes the following:
  • Running an installation script to unpack and distribute the Teradata connector package components
  • Additional setup steps
  1. Log on to a Teradata QueryGrid Manager TMS, VM, or server as a root user. The QueryGrid Manager TMS, VM, or server can be part of a cluster.
  2. Enter the following at the prompt. /opt/teradata/tdqgm/bin/tdqg.sh install-connector
  3. From Connectors, enter the number for the Teradata connector.
  4. From Connector Version, enter the number for the Active or Pending version.
  5. From Driver Nodes, enter the number of the driver node you want to use to perform the installation.
  6. In Connector Properties, provide the administrator credentials, such as dbc and the password, for the initiating Teradata Database system.
  7. Enter the appropriate number for the mode the Teradata Database system is running in (TERA or ANSI).
    The mode determines how a stored procedure can be run.
    The Teradata connector components are installed.
  8. [Optional] Verify that the stored procedure is installed on the Teradata Database nodes.
    1. Log on as an Administrator, such as DBC, of the initiating Teradata Database system.
    2. Create the related foreign server.

      For example:

      CREATE FOREIGN SERVER target_server_name_efssp
      EXTERNAL SECURITY DEFINER TRUSTED target_server_auth
      USING
      LINK('linkname')
      VERSION ('version’)
      DO IMPORT WITH TD_SYSFNLIB.QGExecuteForeignQuery;
    3. From database td_server_db, grant the SELECT privilege on the target server to initiating end users.

      For example:

      GRANT SELECT on td_server_db.target_server_name_efssp to initiating_end_user;
      
    4. Submit the DDL or DCL query on the target system.

      For example:

      .logon initiating_end_user, initiating_end_user
       
      CALL SYSLIB.ExecuteForeignSQL(‘DDL’, ‘target_server_name_efssp’);