Specifies whether the provider establishes a connection to Teradata immediately upon opening the connection. Set ConnectOnOpen to True if immediate connectivity verification is necessary.

Data Type

bool

Default Value

false

Remarks

When ConnectOnOpen is True, the provider performs a "Test Connection" operation, commonly used in database tools to verify connectivity. This operation does not persist any session data; rather, it confirms that a connection can be established, functioning like a NOOP (no operation) command.

When ConnectOnOpen is False, the connection is deferred until required for operations. This may improve performance in situations where connections are frequently opened and closed without immediate activity.