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 on Windows 7 or \Documents and Settings\<username>\Application Data\Teradata\SQL Assistant otherwise.
Additionally, ‘system level’ data sources can be defined. These are stored in a file of the same name, located in \ProgramData\Teradata\SQL Assistant on Windows 7 or \Documents and Settings\All Users\Application Data\Teradata\SQL Assistant otherwise.
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.
To define a Teradata .NET data source
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 choose a .NET data source.
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.
|
Dialog Box Item |
Description |
|
Basic tab |
|
|
Data Source Name |
Enter the name of the data source or use the drop down menu to choose 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. |
|
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. |