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
- 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.
- Enter the following at the prompt. /opt/teradata/tdqgm/bin/tdqg.sh install-connector
- From Connectors, enter the number for the Teradata connector.
- From Connector Version, enter the number for the Active or Pending version.
- From Driver Nodes, enter the number of the driver node you want to use to perform the installation.
- In Connector Properties, provide the administrator credentials, such as dbc and the password, for the initiating Teradata Database system.
-
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.
-
[Optional] Verify that the stored procedure is installed on the Teradata Database nodes.
- Log on as an Administrator, such as DBC, of the initiating Teradata Database system.
-
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;
-
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;
-
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’);