CassandraDB Activities - RPA Component

Products

Studio

StudioX

Business Solutions

Professional Services

Collections

Products

Business Solutions

Professional Services

Collections

English

Japanese

Marketplace

Listings

Custom Activity

CassandraDB Activities

Overview Versions Reviews Q&A

Summary

Overview

Cassandra DB Scope
Handles the authentication to CassandraDB.

Inputs:
ConnectionString - The connection string used to access the database
DatabaseName - The name of the database that you are trying to access
HostName - The host of the database
Password - The password used to log in to the database
Port - The port used in the connection to the database
Username - The username used to log in to the database
Outputs:
OutSession - Returns the session that contains the connection to the database
Execute Non-Query
Executes a non-query statement.

Inputs:
Statement - Used for general purposes, other than select. For example Insert, Update or Delete.Insert into KeyspaceName.TableName(ColumnName1, ColumnName2, ColumnName3 . . . .)
values (Column1Value, Column2Value, Column3Value . . . .)
Update KeyspaceName.TableName 
Set ColumnName1=new Column1Value,
      ColumnName2=new Column2Value,
      ColumnName3=new Column3Value,
      ...
Where ColumnName=ColumnValue
Delete from KeyspaceName.TableName
	Where ColumnName1=ColumnValue
Outputs:
Result - A string that shows the status of the transaction performed.
Select
Executes a Select on a CassandraDB and returns the result.

Inputs:
Statement - A query string, for example:Select ColumnNames from KeyspaceName.TableName Where ColumnName1=Column1Value AND
	ColumnName2=Column2Value
Outputs:
Result - A data table containing the result of the select query
Create Keyspace
Creates a new keyspace.

Inputs:
Keyspace Name -  A string representing the name of the keyspace to be created
Strategy Class - A string representing the replication class
SubOptions - A dictionary in which key is the name of sub-options, value is a value for that sub-option. For example, here you can specify the replication_factor.
Outputs: N/A

Get Keyspace Name
Gets the name of the current keyspace.

Inputs: N/A

Outputs:
Keyspace Name - Returns the name of currently used keyspace.
Change Keyspace
Changes the current keyspace.
Inputs:
Keyspace Name - A string representing the name of the keyspace to change into.
Outputs: N/A
Delete Keyspace
Deletes a keyspace.
Inputs:
Keyspace Name - A string representing the name of the keyspace to be deleted.
Outputs: N/A
Get Cluster
Returns the cluster information and the state.
Inputs: N/A
Outputs:
Cluster - A Cluster variable representing the cluster information and the state.