2.06 - Adding a User Mapping - 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
dita:id
lfq1484661135852
Teradata QueryGrid Overview
Teradata QueryGrid Description
Teradata QueryGrid Components
Active, Pending, and Previous Teradata QueryGrid Configurations
Teradata QueryGrid Security
Teradata QueryGrid 1.0x and 2.0x Connectors
Teradata QueryGrid in the Teradata Public Cloud
Preparing for Software Installation
Preparing for Installation
Prerequisites
QueryGrid Installation Workflow
Obtaining a Change Control Number
Downloading Required Packages
Software Packages
Installing and Configuring Software
Installing and Configuring Teradata QueryGrid Manager
Installing Teradata QueryGrid Manager
Creating a Join Token
Clustering Deployed QueryGrid Manager Instances
Default publicAddress, bindAddress, and clusterAddress Overview
Modifying the publicAddress, bindAddress, and clusterAddress for a QueryGrid Manager Instance
Adding Aliases for Other Servers
Setting Up Teradata QueryGrid in the Viewpoint Administration Portlets
Installing a QueryGrid Root Certificate
Adding QueryGrid
Adding a Role
Configuring Teradata QueryGrid in the QueryGrid Portlet
Adding the QueryGrid Portlet to the Viewpoint Portal
Editing a Service Account
Updating the Teradata QueryGrid Manager Password in the Monitored Systems Portlet
Uploading Connector Software
Uploading Fabric Software
Uploading Node Software
Adding a Data Center
Adding a Data Source System
Add Data Source Nodes to a System
Adding Nodes Automatically
Adding Nodes Manually
Configuring Virtual IP Addresses
Adding a Dedicated Bridge System
Add Non-Data Source Nodes to a Dedicated Bridge System
Adding Nodes Automatically
Adding Nodes Manually
Configuring Virtual IP Addresses
Adding a Bridge System Using Data Source Nodes
Configuring QueryGrid for a Teradata FICON Node
Adding a Fabric
Adding a Connector
Adding a Network
Adding a Communication Policy
Adding a User Mapping
Adding a Role Mapping
Adding a Link
Running a Connector Diagnostic Check
Running a Link Diagnostic Check
Running a Link Bandwidth Test
Configuring and Using Connectors
Using the Teradata Connector with Teradata QueryGrid
Completing the Teradata Connector Configuration
Teradata Connector and Link Properties
Teradata Initiator Connector Tasks
Confirming the QueryGrid Functions
Configuring a Foreign Server and Granting Privileges for a Teradata-to-TargetConnector
Completing the Teradata Initiator Connector Installation on Teradata Database Nodes (Viewpoint 16.10)
Completing the Teradata Initiator Connector Installation on Teradata Database Nodes (Viewpoint 16.20)
Teradata Target Connector Tasks
Setting Up the Proxy User for a Teradata-to-Teradata Connector when Authentication Mode is Set to Trusted
Setting Up User Mapping
Testing Teradata Connectors and Links
Validating a Teradata-to-TargetConnector Link
Teradata Connector Privileges and Security
Required Teradata Initiator Connector Privileges
Teradata Initiator Connector Security and User Sessions
Authorization Objects
Teradata Target Connector Security Guidelines
Teradata Gateway Encryption
Using the Teradata Connector
Data Dictionary Views for Teradata QueryGrid
SQL Syntax for the Teradata Connector
SQL Command Reference for the Teradata Connector
ALTER FOREIGN SERVER
Syntax Elements
Modify Options
Drop Options
Required Privileges
BEGIN LOGGING
COMMENT (Comment Placing Form)
Syntax Element
CREATE AUTHORIZATION and REPLACE AUTHORIZATION
Syntax Elements
Usage Notes
Examples of Creating and Replacing the Authorization
CREATE FOREIGN SERVER
Syntax Elements
USING
DO IMPORT WITH
DO EXPORT WITH
Required Privileges
Usage Notes
Examples: Using CREATE FOREIGN SERVER
DROP FOREIGN SERVER
Syntax Elements
server_name
Example: Using DROP FOREIGN SERVER
END LOGGING
Syntax Elements
ON operation
EXPLAIN
GRANT and REVOKE
HELP FOREIGN
Syntax Elements
Examples of Using HELP FOREIGN
Required Privileges
INSERT Syntax and the Teradata Connector
SELECT Syntax and the Teradata Connector
SHOW FOREIGN SERVER
Syntax Elements
IN XML
TD_SERVER_DB.
server_name
Required Privileges
Example of Using SHOW FOREIGN SERVER
Overriding Session Properties
Remote Table Optimization (RTO)
RTO Process
Default Push Profiles
Push Profile Attributes
Push Profile Defaults
Custom Push Profiles
Creating a Custom Push Profile
Query Concurrency on Teradata Database
Tuning Query Concurrency on Teradata Database
Using APIs to Monitor Queries Between Teradata and a Foreign Server
Teradata QueryGrid Stored Procedures, Functions, and Table Operators
ExecuteForeignSQL
Table Operators and Function
QueryGrid Data Transformation
Data Type Mapping for Teradata QueryGrid Connectors
Teradata Data Type Mapping
Teradata Connector Limitations
Migrating 1.0x Teradata Foreign Server Definitions to 2.0x Teradata Connectors
Using the Presto Connector with Teradata QueryGrid
Completing the Presto Connector Configuration
Presto Connector and Link Properties
Presto Initiator Connector Tasks
Completing the Presto Connector Installation by Running the Installation Script Manually (Viewpoint 16.10)
Completing the Presto Connector Installation with the QueryGrid Portlet (Viewpoint 16.20)
Completing the Presto Connector Installation by Running the Installation Script Manually (Viewpoint 16.20)
Setting Up the Presto Initiator Catalog Properties File
Presto Target Connector Tasks
Testing Presto Connectors and Links
Validating a Presto-to-TargetConnector Link
Presto Connector Privileges and Security
Presto Initiator Connector Security and User Sessions
Presto Target Connector Security Guidelines
Kerberos Authentication Setup
Kerberos Maintenance
Presto Target Connector Privileges
Using the Presto Connector
SQL Syntax for the Presto Connector
SQL Command Reference for the Presto Connector
SELECT Syntax for the Presto Connector
INSERT Syntax for the Presto Connector
SHOW Syntax for the Presto Connector
Overriding Session Properties
QueryGrid Data Transformation
Data Type Mapping for Teradata QueryGrid Connectors
Presto Data Type Mapping
Presto Connector Limitations
Using the Hive Connector with Teradata QueryGrid
Completing the Hive Connector Configuration
Hive Connector and Link Properties
Hive Initiator Connector Tasks
Configuring the Primary Group for Hive Users (CDH Only)
Configuring a Non-Native Table for a Hive-to-TargetConnector
Hive Target Connector Tasks
Configuring the Hive Class Path (CDH Only)
Configuring the Hive Connector for Use with a Custom Hadoop Library Path or Custom JAR Path
Hadoop JAR Files
Testing Hive Connectors and Links
Validating a Hive-to-TargetConnector Link
Hive Connector Privileges and Security
Required Hive Initiator Connector Privileges
Hive Target Connector Security Guidelines
Hive Target Connector Privileges
Verifying Permission to Run kinit
Updating Hive Classpath after Upgrading the Hive Connector
Using the Hive Connector
SQL Syntax for the Hive Initiator Connector
SQL Syntax for the Hive Target Connector
SQL Command Reference for the Hive Connector
DESCRIBE Syntax for the Hive Initiator Connector
EXPLAIN Syntax for the Hive Initiator Connector
INSERT Syntax for the Hive Initiator Connector
SELECT Syntax for the Hive Initiator Connector
SHOW Syntax for the Hive Initiator Connector
Overriding Session Properties
QueryGrid Data Transformation
Data Type Mapping for Teradata QueryGrid Connectors
Hive Data Type Mapping
Hive Connector Limitations
Using the Spark SQL Connector with Teradata QueryGrid
Completing the Spark SQL Connector Configuration
Spark SQL Connector and Link Properties
Creating an HDFS Directory for the Spark SQL Connector
Spark SQL Initiator Connector Tasks
Starting Scala REPL
Configuring a Group for Spark Connector Users for Logging Purposes
Configuring a Foreign Server for a Spark SQL-to-TargetConnector
Spark SQL Target Connector Tasks
Configuring the Spark Connector for Use with a Custom Hadoop Library Path
Hadoop JAR Files
Testing Spark SQL Connectors and Links
Validating a Spark SQL-to-TargetConnector Link
Spark SQL Connector Privileges and Security
Spark SQL Target Connector Security Guidelines
Verifying Permission to Run kinit
Restarting the Spark Thrift Server after Upgrading the Spark Connector
Using the Spark SQL Connector
Syntax for the Spark SQL Initiator Connector
SQL Syntax for the Spark SQL Target Connector
Foreign Server Library API Reference for the Spark SQL Initiator Connector
Constructor
Creating a New Foreign Server Object
Restoring an Existing Foreign Server Object
Static Methods
dropForeignServer
getDatasetFromSql
showForeignServers
sql
EXPLAIN Syntax for the Spark SQL Initiator Connector
INSERT Syntax for the Spark SQL Initiator Connector
SELECT Syntax for the Spark SQL Initiator Connector
Instance Methods
create
describe
drop
show
showColumns
showSchemas
showTables
Overriding Session Properties
QueryGrid Data Transformation
Data Type Mapping for Spark SQL QueryGrid Connectors
Spark SQL Data Type Mapping
Spark SQL Connector Limitations
Using the Oracle Connector with Teradata QueryGrid
Completing the Oracle Connector Configuration
Oracle Connector and Link Properties
Oracle Target Connector Tasks
Setting Up User Mapping
Setting Up Role Mapping
Testing Oracle Connectors and Links
Oracle Connector Privileges and Security
Oracle Target Connector Security Guidelines
Oracle Target Connector Privileges
Using the Oracle Connector
Oracle Connector Supported Operations
Select
Insert
Explain
Show or Describe
Pass Through
Overriding Session Properties
QueryGrid Data Transformation
Oracle Data Type Mapping
Oracle Connector Limitations
Managing QueryGrid
Modifying an Existing QueryGrid Configuration
Working with Active, Pending, or Previous Versions
Replacing Active Network Versions with Pending or Previous Versions
Replacing Active Communication Policies Versions with Pending or Previous Versions
Replacing Active Fabrics, Connectors, and Links Versions with Pending or Previous Versions
Editing a Fabric
Editing a Connector
Editing a Link
Editing a Data Center
Editing a System
Editing a Network
Editing a Communication Policy
Editing a User Mapping
Teradata QueryGrid Monitoring, Logging, and Error Handling
Fabric Overview
Viewing a Fabric Overview
Viewing Component Details
Component Details
Viewing Components with the Navigation Panel
Issues
Viewing Issues History
Issues Details
Monitoring User Queries Between Local and Remote Servers
Logging and Error Handling
Troubleshooting
Solutions for Job Problems
Administrative Tasks
Teradata QueryGrid Manager Settings and Account Management
Managers
Managers Tab
Editing Manager Settings
Service Accounts Tab
Adding a Service Account
Resetting a Service Account Password
Settings Tab
Restarting a Fabric
Resetting Teradata QueryGrid Manager to Default Settings
Removing Teradata QueryGrid Manager from a Cluster
Backup and Restore
Backup
Restore
Migrating QueryGrid Manager to a New Server
QueryGrid Manager RESTful APIs
Upgrading Software
Upgrading QueryGrid
Teradata QueryGrid Upgrade Overview
Upgrading Teradata QueryGrid Manager
Upgrading Teradata QueryGrid Node Software
Upgrading Teradata QueryGrid Connectors and Fabrics
Removing Old Software Versions from Teradata QueryGrid Manager
QueryGrid Portlet Metrics
Communication Policies Metrics
Connector Diagnostic Check Metrics
Connector Software Metrics
Connectors Metrics
Data Centers Metrics
Fabric Software Metrics
Fabrics Metrics
Issues History Metrics
Issues Metrics
Link Bandwidth Test Metrics
Links Metrics
Managers Metrics
Networks Metrics
Node Details Metrics
Node Installation Status Metrics
Node Software Metrics
Node Status Metrics
Roles Metrics
Service Account Metrics
System Metrics
System Nodes Metrics
User and Role Mappings Metrics
Users Metrics
QueryGrid Portlet Table and Row Actions
Table Actions
Row Actions
Notation Conventions
About Notation Conventions
Syntax Diagram Conventions
Additional Information
Audience
Changes and Additions
Teradata Links
Related Documentation
Under Fabric Components , select User and Role Mappings .
Click next to User and Role Mappings .
Type a name, up to 256 characters.
Type a description, up to 1,000 characters.
Click Save .
In the list of user mappings, select the mapping you just added.
On the Users tab, click next to Users .
Type the name of the user on the initiating system.
You can map multiple users to single remote user; however, you can only use an initiating user once.
Type the name of the user on the target system you want to map to.
Click Save .