TDV Adapter for Cassandra

Build 21.0.8137

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
AuthSchemeThe scheme used for authentication. Accepted entries are Basic, DSE, Kerberos, and LDAP.
ServerThe host name or IP address of the server hosting the Cassandra database.
PortThe port for the Cassandra database.
LDAPServerThe host name or IP address of the LDAP server.
UserThe Cassandra user account used to authenticate.
PasswordThe password used to authenticate the user.
LDAPPortThe port for the LDAP server.
DatabaseThe name of the Cassandra keyspace.
DefaultLDAPUserThe default LDAP user used to connect to and communicate with the server, it must be set if the LDAP server do not allow anonymous bind.
LDAPPasswordThe password of the default LDAP user. It must be set if the LDAP server do not allow anonymous bind.
SearchBaseThe search base for your LDAPServer, used to look up users.
SearchFilterThe search filter for looking up usernames in LDAP. The default setting is (uid=), When using Active Directory set the filter to (sAMAccountName=).
UseSSLThis field sets whether SSL is enabled.

Kerberos


PropertyDescription
KerberosKDCThe Kerberos Key Distribution Center (KDC) service used to authenticate the user.
KerberosRealmThe Kerberos Realm used to authenticate the user with.
KerberosSPNThe service principal name (SPN) for the Kerberos Domain Controller.
KerberosKeytabFileThe Keytab file containing your pairs of Kerberos principals and encrypted keys.
KerberosServiceRealmThe Kerberos realm of the service.
KerberosServiceKDCThe Kerberos KDC of the service.
KerberosTicketCacheThe full file path to an MIT Kerberos credential cache file.

SSL


PropertyDescription
SSLClientCertThe TLS/SSL client certificate store for SSL Client Authentication (2-way SSL).
SSLClientCertTypeThe type of key store containing the TLS/SSL client certificate.
SSLClientCertPasswordThe password for the TLS/SSL client certificate.
SSLClientCertSubjectThe subject of the TLS/SSL client certificate.
SSLServerCertThe certificate to be accepted from the server when connecting using TLS/SSL.

SSH


PropertyDescription
SSHAuthModeThe authentication method to be used to log on to an SFTP server.
SSHClientCertA certificate to be used for authenticating the user.
SSHClientCertPasswordThe password of the SSHClientCert certificate if it has one.
SSHClientCertSubjectThe subject of the SSH client certificate.
SSHClientCertTypeThe type of SSHClientCert certificate.
SSHServerThe SSH server.
SSHPortThe SSH port.
SSHUserThe SSH user.
SSHPasswordThe SSH password.
SSHServerFingerprintThe SSH server fingerprint.
UseSSHWhether to tunnel the Cassandra connection over SSH. Use SSH.

Firewall


PropertyDescription
FirewallTypeThe protocol used by a proxy-based firewall.
FirewallServerThe name or IP address of a proxy-based firewall.
FirewallPortThe TCP port for a proxy-based firewall.
FirewallUserThe user name to use to authenticate with a proxy-based firewall.
FirewallPasswordA password used to authenticate to a proxy-based firewall.

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.

Miscellaneous


PropertyDescription
AggregationsSupportedWhether or not to support aggregations in the Cassandra server. Note that in queries to the provider, you must use single quotes to define strings.
AllowFilteringWhen true, slow-performing queries are processed on the server.
CaseSensitivityEnable case sensitivity to the CQL sending to the server, if set to True, the identifiers in the CQL will be enclosed in double quotation marks.
ConsistencyLevelThe consistency level determines how many of the replicas of the data you are interacting with need to respond for the query to be considered a success.
FlattenArraysBy default, nested arrays are returned as strings of JSON. The FlattenArrays property can be used to flatten the elements of nested arrays into columns of their own. Set FlattenArrays to the number of elements you want to return from nested arrays.
FlattenObjectsSet FlattenObjects to true to flatten object properties into columns of their own. Otherwise, objects nested in arrays are returned as strings of JSON.
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.
NullToUnsetUse unset instead of NULL in CQL query when performing INSERT operations.
OtherThese hidden properties are used only in specific use cases.
PagesizeThe maximum number of results to return per page from Cassandra.
ReadonlyYou can use this property to enforce read-only access to Cassandra from the provider.
RowScanDepthThe maximum number of rows to scan to look for the columns available in a table.
TimeoutThe value in seconds until the timeout error is thrown, canceling the operation.
UseJsonFormatWhether to submit and return the JSON encoding for CQL data types.
VarintToStringMap Cassandra VARINT to String value.

Copyright (c) 2022 CData Software, Inc. - All rights reserved.
Build 21.0.8137