question

If you've already setup your Astra DB, you will need to do two things:

• generate an application token, and
• download the secure bundle for your Astra DB.

The application token is what you would use in place of a username and password. The secure bundle contains connection details specific for your database.

Once you've downloaded your secure bundle, unpack/unzip it. For example:

cd /path/to/scb
$ unzip secure-connect-myastradb.zip

Here is an example file listing after unpacking the bundle:

/
  path/
    to/
      scb/
        ca.crt          <----- CA certificate
        cert            <----- SSL certificate
        cert.pfx
        config.json.    <----- text file containing DB details
        cqlshrc
        identity.jks
        key
        trustStore.jks

Obtain information about your database from the config.json file. Here is an example:

{
  "host": "70bf8560-105f-11ec-a3ea-0800200c9a66-us-west1.db.astra.datastax.com",
  "port": 98765,
  "cql_port": 34567,
  "keyspace": "mykeyspace",
  "localDC": "us-west-2",
  "caCertLocation": "./ca.crt",
  "keyLocation": "./key",
  "certLocation": "./cert",
  "keyStoreLocation": "./identity.jks",
  "keyStorePassword": "Kga1OJ83EF2oBQYR5",
  "trustStoreLocation": "./trustStore.jks",
  "trustStorePassword": "n8F9ptJO3H7YRxTW1",
  "csvLocation": "./data",
  "pfxCertPassword": "9b3HgFChtY60m4nfJ"
}

Using the details above, follow the procedure for creating an Apache Cassandra connection in CP4D:

• Hostname - use the value in host field
• Port number - use the value in cql_port field
• Keyspace - use the value in keyspace field
• Username and password - use the string token and the token you generated above
• SSL certificate - use the certificate files above

Cheers!