Connect HomeMarketplaceComponentsCassandraDB Activities

CassandraDB Activities

Custom Activity

Custom Activity

Published: May 25th, 2020

Downloads: 4

Industry: cross-industry

Language compatibility: Visual Basic

Community Support

CassandraDB Activities

Custom Activity

Summary: 

Activities that access and perform operations on CassandraDB

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.

Details

Benefits

You can perform different operations on CassandraDB, such as:
- Authenticate in CassandraDB
- Change Keyspace
- Create Keyspace
- Delete Keyspace
- Execute Non-Query
- Get Cluster
- Get Keyspace Name
- Select

Compatibility

Studio 2019.4.3 or newer

Dependencies

CassandraCSharpDriver
Lz4net

Licensing

By clicking download you agree to the following license.