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 4.6 and later
Create a connection to DataStax Enterprise
To create the connection asset, you need these connection details:
- Hostname or IP address
- Port number
- Keyspace
- Username and password
- 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.
- SSL certificate (if required by the database server)
For Private connectivity, to connect to a database that is not externalized to the internet (for example, behind a firewall), you must set up a secure connection.
Choose the method for creating a connection based on where you are in the platform
- In a project
- Click Assets > New asset > Connect to a data source. See Adding a connection to a project.
- In a deployment space
- Click Import assets > Data access > Connection. See Adding data assets to a deployment space.
- In the Platform assets catalog
- Click New connection. See Adding platform connections.
Next step: Add data assets from the connection
Where you can use this connection
You can use DataStax Enterprise connections in the following workspaces and tools:
Projects
- DataStage (DataStage service). See Connecting to a data source in DataStage.
- Decision Optimization (watsonx.ai Studio and watsonx.ai Runtime)
- SPSS Modeler (watsonx.ai Studio service)
Catalogs
- Platform assets catalog
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
Learn more
Related connection: Apache Cassandra connection
Parent topic: Supported connections