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

Teradata® Tools and Utilities for Microsoft Windows Installation Guide

Teradata Tools and Utilities
Release Number
June 2020
English (United States)
Last Update
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.