Connecting to Apache Cassandra

In order for Spectrumâ„¢ Technology Platform to access data in a Cassandra database, you must define a connection to the Cassandra database using Management Console. Once you do this, you can create flows in Enterprise Designer that can read data from, and write data to, the Cassandra database.
Note: This connection is for use in the Metadata Insights module.
  1. Open Management Console.
  2. Go to Resources > Data Sources.
  3. Click the Add button .
  4. 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.
  5. In the Type field, choose Apache Cassandra.
  6. In the Host field, enter the machine name or the IP on which the Apache Cassandra database is installed.
  7. In the Keyspace field, enter the name of the keyspace of the data center you wish to access.
  8. In the Port field, enter the port on which the Apache Cassandra database is configured.
  9. Enter the user name and password to use to authenticate to the Cassandra database.
  10. 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.
  11. In the Fetch Size, enter the number of resultset rows you wish to fetch on each read transaction.
  12. To test the connection, click Test.
  13. Click Save.