16.20 - 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
September 2019
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 a Teradata Database.
  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 Teradata Database system)
    • User Id = username (the logon name by which the user of this client computer accesses the Teradata Database)
    • 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 Teradata Database that you connect to returns the current system date in the Command Result pane.
  8. Click Connection > Disconnect.
  9. Click File > Exit.