I wanna know that how we can connect datastax Cassandra database into the intellij idea as a data source? i have tried several times with the Generated token but i was unable to do that.
Go to the datastax dashboard and download the SCB bundle to the local an unzip it.
After unzipping the file and the open the config.json
file. it contains the following details that we want to use. (host
,cql_port
, keyStorePassword
)
Go to the intellij idea's DataSource section and make new Apache Cassandra DataSource like below.
config.json -> host
config.json -> cql_port
generated token -> clientId
generated token -> secret
ca.crt
file from unzipped foldercert
file unzipped folderkey
file from unzipped folderconfig.json -> keyStorePassword
finally apply the changes and test the connection.
if you are facing issue when deleting and updating data via the configured connection, make sure to set the consistency level
in startup script
as CONSISTENCY LOCAL_QUORUM;
(As you want).