Establishing a Connection
The provider wraps the official Teradata Database driver; you can connect to the CData ADO.NET Provider for Teradata using the same connection properties and access the same functionality as the underlying Teradata driver.
Before You Connect
Before you can establish a connection, you must install the official Teradata .NET Data Provider into the Windows GAC. Refer to Microsoft's documentation for instructions for installing assemblies into the GAC.
Connecting to Teradata
Required Properties
To connect to Teradata, provide the following authentication information and specify the database server name.
- AuthScheme: Set this to either TD2 (default) or LDAP depending on the required authentication mechanism of your Teradata server.
- User: Set this to the user name of a Teradata user.
- Password: Set this to the password of the Teradata user.
- DataSource: Specify the Teradata server name, DBC Name, or TDPID.
- Port: Specify the port the server is running on.
- Database: Specify the database name. If not specified, the provider connects to the default database.
TLS/SSL Configuration
Enable DataEncryption to encrypt connections with TLS/SSL.