Contact Free trial Login

Additional Cassandra Configuration - Mule 4

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

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

See Also

We use cookies to make interactions with our websites and services easy and meaningful, to better understand how they are used and to tailor advertising. You can read more and make your cookie choices here. By continuing to use this site you are giving us your consent to do this.