Connecting to .NET for Teradata - SQL Assistant

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.