To create a data connection to Teradata utilizing the .NET Data Provider for Teradata, start a Microsoft Visual Studio instance. Establishing a connection may be performed without creating a project or solution in Visual Studio.
- The Visual Studio menu contains a view menu item. Select Server Explorer in the View menu to display this pane.
- Either from the Tools menu item (select Connect to Database) or right click the Data Connections on the Server Explorer pane (select Add Connection) and change the Data Source by selecting the Change button on the Data Connections dialog box.
- Select the Teradata database from the Data Source list box. Insure that the .NET Data Provider for Teradata is selected in the Provider list box. Select the OK button to continue.
- A dialog box customized to a Teradata data source is displayed. Complete the server name and supply a valid user name and password for this example. Select the Test Connection pushbutton to insure a correctly defined data source. Upon a successful connection, select the OK button to save this data source. You may rename the connection from the Server Explorer pane.
A short description of the connection dialog follows:
- Data source: The Teradata data source should be present indicating the .NET Data Provider for Teradata.
- Server name: The Advanced SQL Engine server name.
- Windows Authentication: Checking this box enables integrated security, by providing the logon credentials from Microsoft Windows. The user name and password are disabled.
- User name: The Teradata user name. This field must be supplied for all mechanisms, unless Windows Authentication is selected.
- Password: The Teradata password. This field must be supplied for all mechanisms, unless Windows Authentication is selected.
- Save my password: This streams the password into the connection stream and saves the information for a future connection.
- Mechanism: This list box contains authentication mechanisms supported by Teradata. The .NET TeraGSS configuration must be configured to enable all applicable site mechanisms. Leaving the mechanism box blank will utilize the default mechanism defined in the .NET TeraGSS configuration. If the .NET TeraGSS configuration does not specify a default mechanism, then the server default mechanism is selected.
The advanced button is available for custom authentication strings, and should be utilized for the LDAP mechanism for releases prior to Teradata 6.2. The key field names (or formats) may differ depending upon the site LDAP definition. An example of a LDAP authentication definition:
AuthenticationString = "authcid=guestldap password=passLDAP01"
AuthenticationMechanism = "LDAP"
For further information on mechanisms please see the Security Administration manual.
- Domain: Mechanisms such as SPNEGO utilize this field to define a domain which may be required for these mechanism authentication strings. This is site specific, and this field may be left blank indicating no domain will be supplied in the authentication string.
- Database Name: During a connection, the database name may be changed from the default database name by providing a database name.
- Character Set: The default session character set of ASCII is utilized unless another entry is supplied from the available items in the list box.
- Account String: An optional account name or account string that specifies a user account.