Creating or editing an endpoint for Cassandra activity

Endpoints provide the configuration information that the Studio and the Integration Appliance use to connect to Cassandra platform. Cassandra uses internal authentication mechanism so as to authorize users to perform operations. Internal authentication equates to having user login accounts and their passwords being managed inside Cassandra.

Selecting or editing a Cassandra endpoint

  1. In the Create Endpoint or Edit Endpoint pane, configure the Cassandra endpoint as described in the following table.
    Note: Changing the configuration properties of an endpoint affects all orchestrations that use that endpoint in the project. The edits are global, not local.
  2. Click Test Connection to confirm that the connection details are valid and you are able to connect to the Cassandra successfully.
  3. Click OK.
Table 1. Connection properties
Field Name Description
Server Details
Node Names Specifies the list of Nodes in the cluster for Cassandra instance
Port Number Specifies the list of Ports in the cluster for Cassandra instance.
Authentication
User Name Specifies the Authentication user name used for accessing the Cassandra instance. Username should be same for all the nodes.
Password Specifies the Authentication password used for accessing the Cassandra instance. Password should be same for all the nodes.
Additional Parameters
Write Consistency Level The consistency level determines the number of replicas on which the write must succeed before returning an acknowledgment to the client application. Following are the Write Consistency Level supported:
  • ALL
  • EACH_QUORUM
  • QUORUM
  • LOCAL_QUORUM
  • ONE
  • TWO
  • THREE
  • LOCAL_ONE
  • ANY

User can change the value by selecting any of the write consistency level.

Read Consistency Level The consistency level specifies how many replicas must respond to a read request before returning data to the client application.

Following are the Read Consistency Level supported:

  • ALL
  • EACH_QUORUM
  • QUORUM
  • LOCAL_QUORUM
  • ONE
  • TWO
  • THREE
  • LOCAL_ONE
  • ANY

User can change the value by selecting any of the Read consistency level.

Connection Pool Options
Core Connections per Host The core number of connections per host. Default value is 8 for Local Host Distance and 2 for Remote Host Distance.
Max Connections per Host The maximum number of connections per host. Default value is 8 for Local Host Distance and 2 for Remote Host Distance.
Heartbeat Interval (seconds) Default: 30 seconds. The driver provides application-side keep alive in the form of a connection heartbeat by sending a dummy request. The feature is enabled by default.
Pool Time Out (milli seconds) The time duration for which the driver is blocked to wait for the connection availability from host pool. If this option is set to zero, the driver won't wait at all.
Security
Enable Encryption Specifies that the connection should use SSL.
Note: In addition with the above parameters; there is also a provision for Secure Connector configuration to connect the Endpoint with Cassandra instance.

Data Types Supported by the Cassandra Connector

Following Data Types are supported by the Cassandra Connector:

  • Ascii
  • bigint
  • Blob
  • boolean
  • Counter
  • Decimal
  • Double
  • Float
  • Inet
  • Int
  • List
  • Map
  • Set
  • text
  • timestamp
  • timeuuid
  • tuple
  • uuid
  • varchar
  • varint



Feedback | Notices


Timestamp icon Last updated: Tuesday, 27 September 2016


http://pic.dhe.ibm.com/infocenter/wci/v7r0m0/topic/com.ibm.wci.doc/Cassandra_creating_an_endpoint_activity.html