Connecting to Apache Cassandra
You can use this connection:
- In Enterprise Designer for reading and writing data
- In Metadata Insights to create physical models
-
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 Data Sources.
- Click the Add button .
-
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.
- In the Type field, choose Apache Cassandra.
- In the Host field, enter the machine name or the IP on which the Apache Cassandra database is installed.
- In the Keyspace field, enter the name of the keyspace of the data center you wish to access.
- In the Port field, enter the port on which the Apache Cassandra database is configured.
- Enter the user name and password to use to authenticate to the Cassandra database.
- 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.
- In the Fetch Size, enter the number of resultset rows you wish to fetch on each read transaction.
- To test the connection, click Test.
- Click Save.