How to Connect Cassandra Datastax in intellij idea?

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 dashboard and create your token.

• Go to the intellij idea's DataSource section and make new Apache Cassandra DataSource like below.

step-1 (Basic Credentials)

• host: from config.json -> host
• port: from config.json -> cql_port
• username: from generated token -> clientId
• password: from generated token -> secret

Step-2 (SSL)

• CA file: ca.crt file from unzipped folder
• Client certificate file: cert file unzipped folder
• Client Key File: key file from unzipped folder
• Client Key password: from config.json -> keyStorePassword

finally apply the changes and test the connection.

Additional

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).