Configuring Advanced Options

You can configure advanced options to modify the behavior of the connector.

To configure advanced options:

1. To access advanced options, open the ODBC Data Source Administrator where you created the DSN, then select the DSN, then click Configure, and then click Advanced Options.
2. In the Query Mode list, select an option to specify how the connector executes queries:
   • To execute all queries in SQL, select SQL.
   • To execute all queries in CQL, select CQL.
   • To execute queries in SQL by default and then execute failed queries in CQL, select SQL with CQL fallback.
3. In the Tunable Consistency list, select an option to specify a Cassandra replica or the number of Cassandra replicas that must process a query in order for the query to be considered successful. For detailed information about each option, see the topic Configuring data consistency in the Apache Cassandra 3.0 documentation: https://docs.datastax.com/en/cassandra-oss/3.0/cassandra/dml/dmlDataConsistencyTOC.html.
4. In the Load Balancing Policy list, select the load balancing policy to use:
   • To cycle through all nodes in the cluster on a per-query basis, select Round Robin.
   • To first try all nodes in a primary "local" data center before trying any nodes from other data centers, select DC Aware.
5. In the Binary Column Length field, type the default column length to report for BLOB columns.
6. In the String Column Length field, type the default column length to report for ASCII, TEXT, and VARCHAR columns.
7. In the Virtual Table Name Separator field, type a separator for naming a virtual table built from a collection.

   Note:

   For more information about virtual tables, see Virtual Tables.

8. To use a Blacklist or Whitelist when connecting to hosts in the Cassandra cluster, enter the host IP addresses in the Blacklist Hosts or Whitelist Hosts field.
   • Each IP addresses should be entered in quotation marks, separated by a comma. For example: "1.2.3.4","5.6.7.8".
9. To use a Blacklist or Whitelist of datacenter hosts, enter the host names or addresses in the Blacklist Datacenter Hosts or Whitelist Datacenter Hosts field.
   • Each name or addresses should be entered in quotation marks, separated by a comma. For example: "datacenter1","datacenter2".
10. To use a token-aware policy to improve load balancing and latency, select the Enable Token Aware check box.
11. To use a latency-awareness algorithm to distribute more of the workload onto faster machines, select the Enable Latency Aware check box.
12. Select how the connector handles null value INSERT statements:
    • To configure the connector to insert all NULL values as specified in INSERT statements, select the Enable null values insertion check box.
    • To configure the connector to ignore NULL values inserted into a column that contains only NULL values, clear the Enable null values insertion check box.

    Note:

    For more information about this option, see Enable Null Value Insert.

13. Select how the connector handles capitalization in schema, table, and column names:
    • To differentiate between capital and lower-case letters in schema, table, and column names, select the Enable Case Sensitive check box.
    • To ignore the capitalization of schema, table, and column names, clear the Enable Case Sensitive check box.

    Note:

    For more information about case sensitivity in Cassandra, see Enable Case Sensitive.

14. To map text and varchar data types in Cassandra to use SQL_WVARCHAR, select the Use SQL_WVARCHAR for string data type check box.
15. Select how the connector handles large result sets:
    • To configure the connector to split large result sets into pages, select the Enable paging check box and then type the maximum number of rows to display on each page in the Rows per page field.
    • To configure the connector to fetch all results into memory regardless of the result set size, clear the Enable paging check box.

    Important: Disabling paging and then fetching a large result set can cause issues such as out of memory errors and database timeouts.

16. To configure client-server verification over SSL, use the options in the SSL area. For more information, see Configuring SSL Verification.
17. To save your settings and close the Advanced Options dialog box, click OK.
18. To close the Simba Cassandra ODBC Driver DSN Setup dialog box, click OK.