Additional Cassandra Configuration - Mule 4

Configure Anypoint Connector for Cassandra to work in your environment with basic authentication and DataSense functionality.

Enable Cassandra Authentication

By default, accessing the Cassandra database does not require credentials. You need to configure Cassandra to enable authentication. The Cassandra connector configuration must match the Cassandra configuration for basic authentication.

After enabling authentication, run the cqlsh command from the Cassandra installation home directory as shown in this example, which uses default credentials with username cassandra and password cassandra:

bin/cqlsh localhost -u cassandra -p cassandra
Connected to Test Cluster at localhost:9042.
[cqlsh 5.0.1 | Cassandra 3.10 | CQL spec 3.4.4 | Native protocol v4]
Use HELP for help.
  1. After installing Cassandra, open the conf\cassandra.yaml file for editing.

  2. Optionally, change the value of AllowAllAuthenticator to PasswordAuthenticator.

  3. Restart Cassandra.

  4. In a separate terminal tab, verify that Cassandra is running:

    bin/nodetool status

POJO Configuration

The connector exposes multiple operations in the Cassandra Connector Reference. The below operations accept some POJOs as input parameters, which are needed for the DataSense functionality:

addNewColumn, changeColumnType, createKeyspace, createTable, deleteColumnsValue, deleteRows, dropColumn, dropKeyspace, dropTable, executeCQLQuery, getTableNamesFromKeyspace, renameColumn, select, and update.