17.00 - Verifying Installation of the .NET Data Provider for Teradata - Teradata Tools and Utilities

Teradata® Tools and Utilities for Microsoft Windows Installation Guide

Product
Teradata Tools and Utilities
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-11-20
dita:mapPath
ofn1544831946734.ditamap
dita:ditavalPath
dpj1465132351025.ditaval
The complete installation of .NET Data Provider for Teradata includes an unsupported ad-hoc query tool NQuery.exe. Use this tool to test successful installation of .NET Data Provider for Teradata and to verify connection to Vantage.
  1. Navigate to %PROGRAMFILES%\Teradata\NET Data Provider for Teradata\version \Samples\Bin\ or %PROGRAMFILES(x86)%\Teradata\NET Data Provider for Teradata\version \Samples\Bin\, depending on the Windows platform.
  2. Double-click NQuery.exe.
  3. Select Connection > Connect.
  4. Select .NET Data Provider for Teradata for the Data Provider.
  5. Enter values in the Connection String box.
    The connection string is a semicolon-separated list of name=value pairs. It uses the format Data Source = system_name ; User Id = username ; Password = password ; where:
    • Data Source = system_name (the tdpid of the Vantage system)
    • User Id = username (the logon name by which the user of this client computer accesses Vantage)
    • Password = password, the password for the username
    For example, to connect to database vixen with username jackieo and password sVnglass3s, type:

    Data Source = vixen ; User Id = jackieo ; Password = sVnglass3s ;

  6. Click Connect.
  7. Type Select Date; in the SQL Command pane and click Execute.
    The Vantage system you connect to returns the current system date in the Command Result pane.
  8. Click Connection > Disconnect.
  9. Click File > Exit.