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

Teradata Tools and Utilities for Apple OS X Installation Guide

Teradata Tools and Utilities
August 2016
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.