Creating a connection to a Cassandra database
Procedure
-
In the connection wizard, fill in the general properties of the connection you need to
create, such as Name, Purpose and Description.
The information you fill in the Description field will appear as a tooltip when you move your pointer over the connection.
When done, click Next to proceed to the next step. -
Select Cassandra from the DB
Type list and Cassandra version of the database you are
connecting to from the DB Version list, and
specify the following details:
-
Enter the host name or IP address of the Cassandra server in the Server field.
-
Enter the port number of the Cassandra server in the Port field.
The wizard can connect to your Cassandra database without you having to specify a port. The port you provide here is only for use in the Cassandra component that you drop onto the design workspace from this centralized connection.
-
If you want to restrict your Cassandra connection to a particular keyspace only, enter the keyspace in the Keyspace field.
If you leave this field blank, the wizard will list the column families of all the existing keyspaces of the connected database when you retrieve schemas.
- Enter the name of the Cassandra datacenter in the Datacenter field.
-
If your Cassandra server requires authentication for database access, select the Require authentication check box and provide your username and password in the corresponding fields.
-