Altair® Panopticon

 

Database Connectors

Apache Cassandra

The Apache Cassandra connector allows connection to Apache and Datastax Cassandra instances, by executing a pre-defined CQL query, and retrieving the resulting data.

Steps:

1.     Select Cassandra from the Data Sources pane. The Cassandra Settings pane and the retrieved Cassandra source are displayed.

 

 

2.     Enter the following information:

Property

Description

Host

Apache Cassandra host address.

Port

Apache Cassandra host port. Default is 9042.

KeySpace

Namespace that defines data replication in nodes.

User Id

The username used to connect to the Apache Cassandra service.

Password

The password used to connect to the Apache Cassandra service.

 

3.     Select whether the parameters should be automatically enclosed in quotes, by checking the Enclose parameters in quotes box.

4.     Enter the CQL Query, which can contain parameters in a similar manner to the database connector.

5.     Date/Time values of output data and Date/Time inputs, where supported, is by default unchanged.

You can opt to define the Show in Timezone and Source Timezone settings.

6.     Set the row limit of the data set.

7.     Tap the Preview Selected Data Source slider to turn it on.

8.     Click  to display the data preview.