Cassandra
Cassandra connection helps you connect to a Cassandra database and run queries directly from Infoveave.
Adding a Cassandra Connection
To create a new Cassandra connection:
- Go to the Database section.
- Select Cassandra from the available connectors.
- Fill in the required connection details in the New Cassandra Connection form.
Connection Parameters
When setting up a Cassandra connection, you need to provide the following details:
| Field | Description |
|---|---|
| Name | A unique name to identify your connection. |
| Port | Port number for Cassandra (default is usually 9042). |
| Server | The Cassandra server endpoint or cluster node. |
| Username | Your Cassandra username. |
| Password | The corresponding password for the username. |
| Database | The keyspace you want to connect to in Cassandra. |
| Schema | The schema to be used inside the database (optional). |
Steps to Validate and Save
- After filling in the details, click Validate to verify the connection.
- If validation succeeds, click Save to store the connection.
- You can now use Cassandra as a datasource in your Infoveave workspace.
Example Use Case
With a Cassandra connection configured, you can:
- Query distributed datasets stored across clusters.
- Use Cassandra Query Language (CQL) to fetch and analyze high-volume operational data.
- Integrate Cassandra data into Infoboards for dashboards, reports, and interactive insights.