|
Apache Cassandra Connector
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 Connectors pane. The Cassandra Settings panel displays.
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.