| | Name | Description |
|---|
 | AccountString |
Identifies an individual user account, and is associated with a specific User Id.
The account identifier can be up to 30 characters long.
|
| AllProxy |
The proxy server used on HTTP and/or HTTPS requests when HttpProxy and/or HttpsProxy are not
provided.
|
| AllProxyPassword | The password for TdConnectionStringBuilder.AllProxy authentication. |
| AllProxyUser | The username for TdConnectionStringBuilder.AllProxy authentication. |
| AuthenticationMechanism |
A session security context enabling data encryption and authentication. The following values
are supported: BEARER, CODE, EXTERNALBROWSER, JWT, LDAP, SPNEGO, TD2, TDNEGO.
|
| AuthenticationString |
AuthenticationString supports mechanisms that require additional authentication information.
|
| BrowsableConnectionString | Gets or sets a value that indicates whether the System.Data.Common.DbConnectionStringBuilder.ConnectionString property is visible in Visual Studio designers. (Inherited from System.Data.Common.DbConnectionStringBuilder) |
| BrowserTabTimeout |
Specifies the number of seconds to wait before closing the browser tab after Browser
Authentication is completed.
|
| CodeAppendFile |
Specifies how the CODE authentication mechanism (OIDC Device Code Flow) will return the
verification URL and code required to complete authentication.
|
| CommandTimeout |
This sets the default command timeout.
|
| ConnectionPooling |
Enables or disables connection pooling.
|
| ConnectionPoolingTimeout |
Specifies the time a connection may stay idle inside the pool.
|
| ConnectionString | Gets or sets the connection string associated with the System.Data.Common.DbConnectionStringBuilder. (Inherited from System.Data.Common.DbConnectionStringBuilder) |
| ConnectionTimeout |
Specifies the time to wait for a Teradata session to be opened
or established.
|
| ConnectMaxRetryCount | This represents the maximum number of attempts of a retryable error during TdConnection.Open before an error is returned to the application. |
| Count | Gets the current number of keys that are contained within the System.Data.Common.DbConnectionStringBuilder.ConnectionString property. (Inherited from System.Data.Common.DbConnectionStringBuilder) |
| Database |
The database selected as the default database when a Teradata connection is opened.
|
| DataEncryption |
Session level encryption is enabled, encrypting all messages bidirectionally to Teradata.
|
| DataIntegrity |
Session level integrity is enabled, performing integrity checking on all messages
bidirectionally to Teradata.
|
| DataSource |
The Teradata server name, or equivalently the DBC Name or TDPID.
|
| DataSourceDnsEntries |
The number of entries defined in DNS for the DataSource.
|
| DisableTokenCache |
Disables the use of the OIDC Token Cache.
|
| EnableDateTimeOffset | Enables and disables mapping of TIMESTAMP WITH ZONE to DateTimeOffset |
| EnableFIPS |
Enables FIPS mode.
|
| EnableTdDateTime | Enables and disables mapping of DATE, TIME, TIME WITH ZONE, TIMESTAMP and TIMESTAMP WITH ZONE to TdDate, TdTime, TdTimeWithTimeZone, TdTimestamp and TdTimestampWithTimeZone provider specific types. |
| EnableTdDecimal | Enables and disables mapping of Decimal(18) to TdDecimal provider specific type. |
| EnableTdIntervals |
Enables and disables mapping of all SQL Interval data types to
the corresponding Provider Specific Interval types.
|
| HttpProxy |
This value is no longer used.
|
| HttpProxyPassword |
This value is no longer used.
|
| HttpProxyUser |
This value is no longer used.
|
| HttpsPortNumber |
Specifies the HTTPS/TLS port number that the .NET Data Provider for Teradata uses to establish
a TLS-encrypted connection to the Teradata Gateway.
|
| HttpsProxy |
The proxy server used on HTTPS requests.
|
| HttpsProxyPassword | The password for TdConnectionStringBuilder.HttpsProxy authentication. |
| HttpsProxyUser | The username for TdConnectionStringBuilder.HttpsProxy authentication. |
| IntegratedSecurity |
Single Sign On is supported by setting this value. The User Id, Password, and
Authentication String values are ignored.
|
| IsFixedSize | Overridden.
Gets a value that indicates whether the TdConnectionStringBuilder has a fixed size.
|
| IsReadOnly | Gets a value that indicates whether the System.Data.Common.DbConnectionStringBuilder is read-only. (Inherited from System.Data.Common.DbConnectionStringBuilder) |
| Item | Overridden.
Gets or sets the value associated with the specified connection string keyword.
|
| JwsAlgorithm |
Specifies the JSON Web Signature algorithm to use when signing the JWT Bearer Token for client
authentication.
|
| JwsCert |
Specifies the file name of the X.509 certificate PEM file that contains the public key
corresponding to the private key in JwsPrivateKey.
|
| JwsPrivateKey |
Specifies the filename of the PEM or JWK file containing the private key to sign the JWT
Bearer Token for client authentication. PEM files are only supported on .NET 6 or later.
|
| Keys | Overridden.
Gets a collection of valid connection string keywords for the .NET Data Provider for Teradata.
|
| MaxDecimalPrecision |
Used to set the maximum precision of a decimal that can be retrieved from Teradata.
|
| MaxPoolSize |
Maximum number of Teradata sessions allowed in the pool.
|
| MinPoolSize |
Minimum number of Teradata sessions allowed in the pool.
|
| NewPassword | Gets or sets a string that contains a new password to be supplied during logons
that contain expired passwords.
|
| NodeDownTimeout | Obsolete. The number of seconds that must elapse before a connection attempt is made to a node previously marked as unavailable. |
| OidcClaim |
Specifies the OpenID Connect (OIDC) claim type to use for client authentication mechanisms
which require user interaction, such as EXTERNALBROWSER and CODE.
|
| OidcClientId |
Specifies the OpenID Connect (OIDC) Client ID to use for EXTERNALBROWSER Authentication
mechanism and other OIDC methods.
|
| OidcPrompt |
Specifies the OpenID Connect (OIDC) prompt to use for client authentication mechanisms which
require user interaction, such as EXTERNALBROWSER and CODE.
|
| OidcScope |
Specifies the OpenID Connect (OIDC) scope to use for EXTERNALBROWSER authentication mechanism
and other OIDC methods.
|
| OidcToken |
Specifies the kind of OpenID Connect (OIDC) token to use for client authentication mechanisms
that support it.
|
| Password |
The Advanced SQL Engine password.
|
| PersistSecurityInfo |
The data source object can persist sensitive authentication information
such as a password along with other authentication information.
|
| PortNumber |
Specifies the TCP/IP port number that the .NET Data Provider for Teradata
uses for connection to the Teradata Gateway.
|
| ProfileName |
Specifies the profile name to access the appropriate properties from the application
configuration file.
|
| ProxyBypassHosts |
A comma-separated list of hostnames that should be excluded from proxying.
|
| QueryBand |
Gets or Sets the Query Bands that are to be defined at the Connection Level.
|
| ReadAhead |
Enables additional buffering of results, while the current buffer is consumed by an
application. This is useful when executing queries that return large result sets.
|
| Recovery |
Sets Recoverable Network Protocol (RNP) and Redrive properties used during a network
error or database failure.
|
| RecoveryCommandTimeoutOverride | Enables a TdConnectionStringBuilder.RecoveryTimeout value to be supplied during reconnection for commands that contain a finite CommandTimeout. |
| RecoveryIntervalFactor |
This represents the adjustment in the recovery interval period from the preceding
interval period. The factor is an additive factor in seconds.
|
| RecoveryMaximumInterval | This represents the maximum interval time in seconds, used to limit the retry interval time adjusted by the TdConnectionStringBuilder.RecoveryIntervalFactor. |
| RecoveryStartInterval |
The starting time interval (in seconds) after which an attempt to retry a
reconnection is performed.
|
| RecoveryTimeout |
Recovery timeout in seconds used to re-establish a connection.
|
| ResponseBufferSize |
Gets and Sets the initial size of the internal communication data buffers.
|
| RestrictToDefaultDatabase | Indicates whether Schema queries TdConnection.GetSchema should be restricted to the Default Database. |
| SessionCharacterSet | Gets or sets the character encoding (Text.Encoding) for the connection. |
| SessionMode |
Gets or sets the Session-Mode.
|
| SslCA |
Specifies the full path and name of a PEM file containing CA certificates. This file may
contain one or more trusted root or intermediate CA certificates.
|
| SslCAPath |
Specifies the path to a directory containing certificate files in PEM format. The directory
will be searched for *.pem files. Each .pem file may contain one or more trusted root or
intermediate CA certificates.
|
| SslCRC |
Controls the behavior of the HTTPS/TLS connections to the Teradata Database depending on the
result of the certificate revocation check.
|
| SslCRCTimeout |
Sets the maximum amount of time to be spent during the retrieval of OCSP response or
certificate revocation list (CRL). A value of zero means no limits.
|
| SslMode |
Gets or sets the SslMode for connections to the database. SslMode is not used for validating
the OpenID Connect Identity Provider endpoint certificates, which are validated using the
system default settings.
|
| SslProtocol |
Specifies the minimum version of the TLS protocol for TLS-encrypted connections.
|
| UseEnhancedSchemaTable | Gets or sets a Boolean value that indicates whether TdDataReader.GetSchemaTable method should return additional metadata information (e.g. IsKey and IsUnique). |
| UseLocalCatalog | Gets or sets a boolean value that indicates whether TdDataReader.GetSchemaTable should return 'TD_LOCAL' in the BaseCatalogName column and VSD and HELP queries should return 'TD_LOCAL' in the CatalogName column for local objects in Teradata Database 20.00.28.43 or later. If this value is false or the Database is older, the return value for both columns will be DBNull for local objects. |
| UserId |
The Teradata user id.
|
| UseXViews |
All schema queries will return only user owned data.
|
| Values | Overridden. Gets a collection of connection string values for the TdConnectionStringBuilder. |