Connecting to Apache Cassandra

  1. Access the Data Sources page using one of these modules:
    Management Console:
    Access Management Console using the URL: http://server:port/managementconsole, where server is the server name or IP address of your Spectrum™ Technology Platform server and port is the HTTP port used by Spectrum™ Technology Platform.
    Note: By default, the HTTP port is 8080.
    Go to Resources > Data Sources.
    Metadata Insights:
    Access Metadata Insights using the URL: http://server:port/metadata-insights, where server is the server name or IP address of your Spectrum™ Technology Platform server and port is the HTTP port used by Spectrum™ Technology Platform.
    Note: By default, the HTTP port is 8080.
    Go to Connect.
  2. Click the Add connection button .
  3. In the Name field, enter a name for the connection. The name can be anything you choose.
    Note: Once you save a connection you cannot change the name.
  4. In the Type field, choose Apache Cassandra.
  5. In the Host field, enter the machine name or the IP on which the Apache Cassandra database is installed.
  6. In the Keyspace field, enter the name of the keyspace of the data center you wish to access.
  7. In the Port field, enter the port on which the Apache Cassandra database is configured.
  8. Enter the user name and password to use to authenticate to the Cassandra database.
  9. In the Consistency Level field, select how consistent data rows must be across replica nodes for a successful data transaction. This can be at least one, or all, or a combination of available nodes.
  10. In the Fetch Size, enter the number of resultset rows you wish to fetch on each read transaction.
  11. To test the connection, click Test.
  12. Click Save.