TDV Adapter for Oracle

Build 22.0.8462

Connection String Options

The connection string properties are the various options that can be used to establish a connection. This section provides a complete list of the options you can configure in the connection string for this provider. Click the links for further details.

For more information on establishing a connection, see Basic Tab.

Authentication


PropertyDescription
ConnectionTypeConnection properties to use for authentication. Accepted entries are Server, OracleTNS, LDAP.
ServerThe host name or IP of the server hosting the Oracle database.
PortThe port used to connect to the server hosting the Oracle database.
ServiceNameThe service name of the Oracle database.
UserThe Oracle OCI user account used to authenticate.
PasswordThe password used to authenticate the user.
DataSourceOracle Net Services Name, Connect Descriptor (known also as TNS Connect String), or an easy connect naming that identifies the database to which to connect.
LDAPUriLDAP uri to connect the LDAP server.
LDAPUserThe User account for LDAP server.
LDAPPasswordThe password for the LDAP user.
LDAPVersionThe LDAP version used to connect to and communicate with the server.

Logging


PropertyDescription
LogModulesCore modules to be included in the log file.

Schema


PropertyDescription
LocationA path to the directory that contains the schema files defining tables, views, and stored procedures.
IncludeSynonymsQuery meta data for synonyms as they are being the reqular tables.
ShowMetadataDescriptionsControls whether table and column descriptions are returned via the platform metadata APIs and sys_tables / sys_views / sys_tablecolumns.
UseDBAMetadataViewsQuery meta data from DBA_.. system views instead of ALL_.. system views.

Miscellaneous


PropertyDescription
AllowPreparedStatementPrepare a query statement before its execution.
MaxLobSizeThe volume in numbers of bytes or UTF-8 chars which is allowed to query by non-parameterized SELECT query.
MaxRowsLimits the number of rows returned rows when no aggregation or group by is used in the query. This helps avoid performance issues at design time.
OtherThese hidden properties are used only in specific use cases.
ReadonlyYou can use this property to enforce read-only access to Oracle OCI from the provider.
ReconnectTimeoutThe sleep time, in seconds, before retrying to reconnect to the server on a maximum idle time exceeded error.
ReconnectTriesThe number of retry to connect server when a maximum idle time exceeded error is reported by server.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462