Miscellaneous
This section provides a complete list of the Miscellaneous properties you can configure in the connection string for this provider.
Property | Description |
DisableAutoCommitInBatch | Specifies whether or not disable the autocommit when executing the batch operation. |
HttpsPort | Connects to the database on the Transmission Control Protocol/Internet Protocol (TCP/IP) port specified for HTTPS/TLS connections. |
MaxRows | Limits the number of rows returned when no aggregation or GROUP BY is used in the query. This takes precedence over LIMIT clauses. |
Other | These hidden properties are used only in specific use cases. |
QueryPassthrough | This option passes the query to the Teradata server as is. |
Readonly | You can use this property to enforce read-only access to Teradata from the provider. |
RTK | The runtime key used for licensing. |
SslCa | Specifies the file name of a PEM file that contains Certificate Authority (CA) certificates for use with SSLMODE=VERIFY-CA or VERIFY-FULL. |
SslCaPath | Specifies a directory of PEM files that contain Certificate Authority (CA) certificates for use with SSLMODE=VERIFY-CA or VERIFY-FULL. |
SslMode | Specifies the mode for connections to the database. |
SslProtocol | Specifies the TLS protocol for HTTPS/TLS connections. |
Timeout | The value in seconds until the timeout error is thrown, canceling the operation. |
UpperCaseIdentifiers | This property reports all identifiers in uppercase. This is the default for Oracle databases and thus allows better integration with Oracle tools such as the Oracle Database Gateway. |
UseXViews | Specifies which Data Dictionary views should be queried to return result sets from DatabaseMetaData methods. |