DataStax Enterprise connection

To access your data in DataStax Enterprise, create a connection asset for it.

DataStax Enterprise is a NoSQL and vector database that is built on Apache Cassandra

Supported versions

DataStax Enterprise 6.8.

Create a connection to DataStax Enterprise

To create the connection asset, you need these connection details:

  • Hostname or IP address
  • Port number
  • Keyspace
  • Read consistency: Specifies the number of replicas that must respond to a read request before the data is returned to the client application.
    • all: Data is returned to the application after all replicas have responded. This setting provides the highest consistency and lowest availability.
    • local_one: Data is returned from the closest replica in the local data center.
    • local_quorum: Data is returned after a quorum of replicas in the same data center as the coordinator node has responded. This setting voids latency of inter -data center communication.
    • local_serial: Data within a data center is read without proposing a new addition or update. Uncommitted transactions within the data center are committed as part of the read.
    • one: Data is returned from the closest replica. This setting provides the highest availability, but increases the likelihood of stale data being read.
    • quorum: (Default). Data is returned after a quorum of replicas has responded from any data center.
    • serial: Data is read without proposing a new addition or update. Uncommitted transactions are committed as part of the read.
    • three: Data is returned from three of the closest replicas.
    • two: Data is returned from two of the closest replicas.  
  • Write consistency: Specifies the number of replicas for which the write request must succeed before an acknowledgment is returned to the client application.
    • all: A write must succeed on all replica nodes in the cluster for that partition key. This setting provides the highest consistency and lowest availability.
    • any: A write must succeed on at least one node. Even if all replica nodes for the given partition key are down, the write can succeed after a hinted handoff has been written. This setting provides the lowest consistency and highest availability.
    • each_quorum: A write must succeed on a quorum of replica nodes across a data center.
    • local_one: A write must succeed on at least one replica node in the local data center.
    • local_quorum: A write must succeed on a quorum of replica nodes in the same data center as the coordinator node. This setting voids latency of inter -data center communication.
    • local_serial: The driver prevents unconditional updates to achieve linearizable consistency for lightweight transactions within the data center.
    • one: A write must succeed on at least one replica node.
    • quorum: (Default). A write must succeed on a quorum of replica nodes.
    • serial: The driver prevents unconditional updates to achieve linearizable consistency for lightweight transactions.
    • three: A write must succeed on at least three replica nodes.
    • two: A write must succeed on at least two replica nodes.

 

Credentials

  • Username and password

Certificates

  • Port is SSL-enabled: Enable this option if the port you have chosen is configured to accept SSL connections.

If the Port is SSL-enabled option is enabled, fill in the following fields:

  • SSL certificate: Enter the SSL certificate of the host to be trusted
  • Hostname in SSL certificate: The hostname in SubjectAlternativeName or Common Name (CN) part of the SSL certificate
  • Validate the SSL certificate: Enable this option to validate that the SSL certificate returned by the host is trusted.

For Credentials and Certificates, you can use secrets if a vault is configured for the platform and the service supports vaults. For information, see Using secrets from vaults in connections.

Federal Information Processing Standards (FIPS) compliance

This connection cannot be created in a FIPS environment.

Primary keys in SQL statements

If you create a target table with an SQL statement and you do not specify a key column, the first column is designated as the primary key.

DataStax Enterprise setup

Getting started with DataStax Enterprise

Learn more

Related connection: Apache Cassandra connection