Defining a .NET Data Provider for Teradata Data Source - Teradata SQL Assistant

Teradata® SQL Assistant for Windows User Guide

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

Use the Connection Information dialog to create, edit, and delete data sources for .NET Data Provider for Teradata. The dialog 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 list.

  3. Click .
  4. Use the Connection Information dialog 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 to modify existing sources.
    Use the Advanced tab to make additional changes to a data source.
  5. Set the options for the data source.
    Field Description
    Basic tab
    Data Source Name Enter the name of the data source or use the drop down menu to select an existing name.
    Server Enter the name of the data source or the IP address.
    Use Integrated Security Use your Windows credentials for this connection.
    Mechanism Select a security mechanism and parameter. The default mechanism is used if this is left blank.
    Parameter Enter your security parameters if required by the selected mechanism.
    User Name Enter the appropriate user name information.
    Password Enter the appropriate password information.
    Save my pasword

    If the user checks this box then the [encrypted] password will be saved along with the rest of the connection information for that data source.

    The next time the user selects that data source the password will automatically be populated in the Password field.

    The password can ONLY be decrypted on the same system, by the same user.

    If significant changes are made to the system [hardware changes or new OS], all saved passwords will become unusable and must be re-entered.

    Default Database

    Enter the default database if applicable.

    If this field is left blank, 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.
    Recovery Mode This field allows you to set the Recoverable Network Protocol (RNP) and Redrive property to be used after a network error or database failure. The values are:
    • Default – Setting is defined by the system's TASM Redrive setting.
    • Off – RNP/Redrive will not be used.
    • RNP – Enables reconnection after a network issue. Commands may be re-issued after a network failure.
    • Redrive – Enables Redrive after a network or database failure. Spool files will survive across a database restart.
    Connection Timeout

    Enter a time limit in seconds for SQL Assistant to establish a connection to an available system before timing out.

    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.

    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 default is not selected.

    Optimized Edit Table

    When this option is checked, the application creates more efficient SQL for updating and deleting rows through the Edit Table grid.

    However, this option requires that the table have a Primary Key or Unique constraint of some kind.

    T update/delete rows for a table that does not have a Primary Key or Unique constraint, you must uncheck this option.

    The default is selected.

    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.