Search

PowerExchange for Cassandra User Guide

PowerExchange for Cassandra User Guide

10.5.7
- 10.5.9
- 10.5.8
- 10.5.6
- 10.5
- 10.4.0

Back Next

Cassandra ODBC Data Source Name Advanced Properties

Cassandra ODBC Data Source Name Advanced Properties

The following table describes the advanced properties for the Cassandra ODBC data source name:

Property	Description
Query Mode	The query modes that the ODBC driver uses to process queries. You can select one of the following query modes: SQL CQL SQL with CQL Fallback
Tunable	The consistency levels that you can use when you read data from or write data to a Cassandra database. You can select one of the following tunable configurations: ANY ONE TWO THREE QUORUM LOCAL QUORUM EACH QUORUM ALL LOCAL ONE
Load Balancing policy	The policies that the ODBC driver uses to determine which host communicates with the ODBC driver. You can select one of the following load balancing policies: DC Aware Round Robin
Binary Column Length	The default length to report when exposing BLOB columns. Default is 4000.
String Column Length	The default length to report when exposing ASCII, TEXT, and VARCHAR columns. Default is 4000.
Virtual Table Name Separator	The separator name for naming a virtual table built from a collection. Default is _vt_.
Blacklist hosts	The host names or IP addresses that you want to ignore while establishing the connection. You can enter the host names in quotation marks, separated by comma.
Whitelist hosts	The host names or IP addresses that you want to connect. You can enter the host names in quotation marks, separated by comma.
Blacklist datacenter hosts	The datacenter names that you want to ignore while establishing the connection. You can enter the host names in quotation marks, separated by comma.
Whitelist datacenter hosts	The datacenter names that you want to connect. You can enter the host names in quotation marks, separated by comma.
Enable Token Aware	Specifies how the ODBC driver reduces load on Cassandra nodes. When you enable token aware option, the driver uses the primary key of queries to route requests directly to the Cassandra nodes.
Enable Latency Aware	Specifies how the ODBC driver restricts sending new queries to slow performing Cassandra nodes.
Enable Null Values Insertion	The null values in an INSERT statement.
Enable Case Sensitive	Specifies whether the ODBC driver differentiates between lowercase and uppercase letters in schemas, tables, and columns. You can specify the case by using double quotation marks.
Use SQL_WVARCHAR for string data type	Specifies whether to use SQL_WVARCHAR for data types that support Unicode character sets.
Enable Paging	The number of rows that the ODBC driver reads or writes per page from the Cassandra database for large volumes of data.
SSL	Not Applicable.

Configuring the Cassandra ODBC Advanced Properties for Data Source Name

Watch

Comments

0 COMMENTS

We’d like to hear from you! Log in to comment.