Connecting to .NET for Teradata - SQL Assistant

Teradata SQL Assistant for Microsoft Windows User Guide

SQL Assistant
Release Number
English (United States)
Last Update
Product Category
Teradata Tools and Utilities

Connecting to .NET for Teradata

Use the following procedure to connect to a .NET for Teradata data source. For more information on defining .NET data sources, see “Defining a .NET Data Provider for Teradata Data Source” on page 25.

1 Use the Provider drop down menu to select Teradata.NET.

2 Do one of the following:

  • Select Tools > Connect.
  • On the toolbar click .
  • The Teradata .NET Connection Information dialog box opens.

    3 Select the data source and enter the applicable information.

    When Connected to a Teradata .NET Data Source

    The following list details what occurs when a connection is established with a Teradata .NET data source:

  • Teradata.NET always uses ANSI date mode.
    All date literals must be entered in 'YYYY-MM-DD' format.
  • Timestamp With Time Zone columns only sort correctly if you specify a date format of 'YYYY-MM-DD'.
  • A WITH (summary) clause in a Select statement causes the data return to fail.