Configuring Query Service - Teradata Software for Azure

Teradata Vantage™ on Azure (DIY) Installation and Administration Guide

Product

Teradata Vantage on Azure

Release Number

6.02

Published

January 2019

Language

English (United States)

Last Update

2019-01-04

dita:mapPath

bhl1545334018390.ditamap

dita:ditavalPath

TeradataAzure_PubCloud_6.02_Unity.ditaval

dita:id

B035-2810

lifecycle

Product Category

Cloud

You can use Query Service in the public cloud or on-premises.

The time zone for the Query Service VM defaults to the database time zone.

From the Azure portal, note the following information of the Query Service VM:
- The private IP address.
- Either the public IP or public DNS, if applicable.
Log on to the VM using the authentication type you chose when deploying the VM.
Obtain an admin password for Query Service.
1. Open an SSH client and connect to the Query Service VM:
```
# ssh azureuser@VM-public-IP-address
```
  where:
  - azureuser is the user name specified when you deployed the VM.
  - VM-public-IP-address is the public IP address of the Query Service VM.
2. Switch to the root user environment.
```
# sudo su -
```
3. Generate the password for the admin user:
```
/opt/teradata/rest/bin/azure_tdrest-password-generate
```
  Note the resulting password, which you will use to log in to the Query Service user interface.
From your browser, display the Query Service user interface using either the IP address or DNS name.
- http://VM-public-IP-address:1080
- http://VM-public-DNS:1080
where VM-public-IP-address is the public IP address and VM-public-DNS is the DNS host name of the Query Service VM.
Log in to the Query Service user interface as admin.
Create a system. See the Teradata® Query Service Installation, Configuration, and Upgrade Guide for Customers.