2.10 - Completing the Teradata Initiator Connector Installation on Teradata Database Nodes (Viewpoint 16.10) - 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
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. The QueryGrid Manager TMS, VM, or server can be part of a cluster.
  2. Run the following script at the prompt as root or the tdqgm user: /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’);