MarketplaceStudioActivityCassandraDB Activities

Create your first automation in just a few minutes.Try Studio Web

CassandraDB Activities

CassandraDB Activities

by Internal Labs

StarStarStarStarStarStarStarStarStarStar

0

Activity

Downloads

469

back button
back button
carouselImage0
next button
next button

Summary

Summary

Activities that access and perform operations on CassandraDB

Overview

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.

Features

Features

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

Additional Information

Additional Information

Dependencies

CassandraCSharpDriver Lz4net

Code Language

Visual Basic

Runtime

Windows Legacy (.Net Framework 4.6.1)

Publisher

Internal Labs

Visit publisher's page

License & Privacy

License Agreement

Privacy Terms

Technical

Version

1.0.2

Updated

June 12, 2020

Works with

Studio: 21.10 - 22.10

Certification

Silver Certified

Support

UiPath Community Support

Similar Listings