Defining a .NET Data Provider for Teradata Data Source - 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

Defining a .NET Data Provider for Teradata Data Source

Use the Connection Information dialog box to create, edit, and delete data sources for .Net Data Provider for Teradata. The dialog box is also used to connect to existing Teradata.Net data sources.

Data source definitions are saved to a file named DataSources.config.
This file is located in \Users\<username>\AppData\Teradata\SQL Assistant.

Additionally, ‘system level’ data sources can be defined. These are stored in a file of the same name, located in \ProgramData\Teradata\SQL Assistant.

When a System level data source is selected, a padlock icon appears to the right of the data source name. For a Windows user with Standard rights, many of the properties within such a data source can not be changed. A user with Administrative rights can change any property. However, if he or she changes certain properties, a new user level data source is created. This user level data source appears instead of the system level data source going forward. If he or she later deletes that data source, the original System level data source is restored.

1 Open Teradata SQL Assistant.

2 Select Teradata .NET from the provider drop down list, next to the Connect tool button.

3 Click the Connect icon or go to Tools > Connect.

4 Use the Connection Information dialog box to select a .NET data source.

  • Create a new data source by entering the name and server and other applicable information
  • Delete an existing data source by clicking Delete.
  • Use this dialog box to modify existing sources.
  • 5 Use the Advanced tab to make additional changes to a data source.

    The figure below shows the .NET dialog box.

    Table 3 describes the options in the .NET dialog box.


    Table 3: Description of the Teradata.NET Connection Dialog Box 

    Dialog Box Item


    Basic tab

    Data Source Name

    Enter the name of the data source or use the drop down menu to select an existing name.


    Enter the name of the data source or the IP address.

    Use Integrated Security

    Use your Windows credentials for this connection.


    Select a security mechanism and parameter. The default Mechanism is used if this is left blank.


    Enter your security parameters if required by the selected Mechanism.

    User Name

    Enter the appropriate user name information.


    Enter the appropriate password information.

    Default Database

    Enter the default database if applicable.

    If the Default Database is not entered, the Username is used as the default. All tables, views, and macros are assumed to be in this default database unless explicitly prefixed by a database name in the query.

    Account String

    Enter the default account string if applicable.

    Advanced tab

    Session Character Set

    Use the drop down menu to select a character set to be associated with the data source.

    Session Mode

    Use Session Mode to select the type of session. Options include ANSI, DEFAULT, and TERADATA.

    Response Buffer Size

    Enter a buffer size between 4096 and 1040000. The default is 65535.

    Port Number

    Enter a port number. The default is 1025.

    Connection Timeout

    Enter the length of time in seconds that SQL Assistant should wait for a connection to be established before determining that the system is unavailable. The default setting is 20 seconds.

    Data Source DNS Entries

    [Optional] Enter the number of IP Addresses defined for the Teradata system (1 to 999). The default setting is blank.

    Use X views

    Select this box to force the driver to read the X (restricted) views instead of the regular views when fetching catalog data for the Database Tree.

    Note: This option makes retrieving Database Tree information less efficient but might be required due to security restrictions for some users.

    Use Data Encryption

    Select this box to use data encryption.

    Verify Message Integrity

    Select this box to set the .NET Data Provider to perform integrity checks on all messages sent to and received from Teradata. The box is not selected by default.

    Use Enhanced Schema

    Select this box to set the .NET Data Provider to return additional metadata information. This option also controls whether the StatementInfo parcel is returned by the database. The box is selected by default.

    Show Color Bar

    Select this box to display a narrow bar of color across the top of any Query window that is connected to this data source.

    Use the Color selection control to the right to select a color.

    This same color is used to underline the Data Source name in the Database Explorer Tree when you are connected to this data source.