English

Marketplace

Listings

Custom Activity

CassandraDB Activities

Bronze Certified

Custom Activity

0 reviews

362

Version:

CassandraDB Activities

Bronze Certified

Custom Activity

0 reviews

362

Version:1.0.2

Overview Reviews Questions

Versions

Summary

Activities that access and perform operations on CassandraDB

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.

Benefits

Published: 12 Jun 2020 | Updated: 18 Dec 2020

Internal Labs

License

Apache 2.0

Code Language

Visual Basic

Runtime

.NET Framework

Microsoft Azure Active Directory…

Custom Activity

Official UiPath activities for Azure Active Directory, Microsoft's cloud identity & access management service - automate important operations on users, groups, lifecycle policies, directory roles.…

1.1k

Silver Certified

Supported by Publisher

Microsoft PowerPoint Related Activities…

Custom Activity

The package is meant to automate building out and changing content on a PowerPoint presentation…

20.3k

Bronze Certified

Supported by Publisher

Xebia - SQL Query Builder…

Custom Activity

SQL Query Builder for "OR" or "AND" Statement which can be used in select query in Database or DataTable …

307

Bronze Certified

Supported by Publisher

RPA Brasil Date Activities…

Custom Activity

Some actions that we need to do with dates are often very complex to perform and often require complex code. This package contains activities that facilitate manipulation of dates without the need for code.…