Cmdlets for Teradata

Build 24.0.9175

Miscellaneous

This section provides a complete list of the Miscellaneous properties you can configure in the connection string for this provider.


PropertyDescription
DisableAutoCommitInBatchSpecifies whether or not disable the autocommit when executing the batch operation.
HttpsPortConnects to the database on the Transmission Control Protocol/Internet Protocol (TCP/IP) port specified for HTTPS/TLS connections.
MaxRowsSpecifies the maximum rows returned for queries without aggregation or GROUP BY.
OtherSpecifies additional hidden properties for specific use cases. These are not required for typical provider functionality. Use a semicolon-separated list to define multiple properties.
QueryPassthroughThis option passes the query to the Teradata server as is.
ReadonlyToggles read-only access to Teradata from the provider.
RTKSpecifies the runtime key for licensing the provider. If unset or invalid, the provider defaults to the standard licensing method. Use this property only in environments where the standard licensing method is unsupported or requires a runtime key.
SslCaSpecifies the file name of a PEM file that contains Certificate Authority (CA) certificates for use with SSLMODE=VERIFY-CA or VERIFY-FULL.
SslCaPathSpecifies a directory of PEM files that contain Certificate Authority (CA) certificates for use with SSLMODE=VERIFY-CA or VERIFY-FULL.
SslModeSpecifies the mode for connections to the database.
SslProtocolSpecifies the TLS protocol for HTTPS/TLS connections.
TimeoutSpecifies the maximum time, in seconds, that the provider waits for a server response before throwing a timeout error. The default is 60 seconds. Set to 0 to disable the timeout.
UpperCaseIdentifiersThis 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.
UseXViewsSpecifies which Data Dictionary views should be queried to return result sets from DatabaseMetaData methods.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 24.0.9175
 

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 24.0.9175