On systems with Viewpoint 16.20, 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 the following:
- A stored procedure that provides a simple interface for executing basic SQL queries
- Push profile code, associated functions, and macros that allow you to use Teradata Database Remote Table Optimization (RTO) with QueryGrid
This procedure includes the following:
- Running an installation script to unpack and distribute the Teradata connector package components
- Additional setup steps
- Make sure the connector package has been downloaded from Teradata's software download site and uploaded to the QueryGrid portlet, and that the connector has been added to the fabric.
- Under Fabric Configuration, select Fabrics.
- Click the fabric containing the Teradata Database initiating nodes.
- Select Connectors tab.
- Click next to the Teradata initiating connector for the Teradata Database nodes and select Install.
From Connector Installation, select one of the following:
- In the Select driver node list, select the driver node you want to use to run the installation script.
- To allow the installation script to run, provide the Username and Password log on for an Administrator, such as DBC, of the initiating Teradata Database system.
In the Transaction Mode list, select one of the following:
The mode determines how a stored procedure can be executed.
Option Description For systems running in Teradata mode: Select TERA. For systems running in ANSI mode: Select ANSI.
- Click Run. The stored procedure and RTO components are installed on all the Teradata Database nodes.
- Verify successful installation by checking that the driver node specified in the Select driver node list is represented in the Success field.
[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.
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.
GRANT SELECT on td_server_db.target_server_name_efssp to initiating_end_user;
Submit the DDL or DCL query on the target system.
.logon initiating_end_user, initiating_end_user CALL SYSLIB.ExecuteForeignSQL(‘DDL’, ‘target_server_name_efssp’);