Search: database-connect

The Database Activities Pack enables the user to connect to a database and perform an entire palette of actions within it, such as executing transactions or queries and non queries. It can be used to connect to a large selection of databases, such as SQL Server, Oracle, DB2, and others, either directly

Database

Database

(% class="box" %) ((( The **Database Activities Pack** enables the user to connect to a database

. It can be used to connect to a large selection of databases, such as ##SQL Server, Oracle, DB2

/Activities/Database/Release%20Notes/]] * [[Activities>>path:/bin/view/Activities/Database/Activities/]]

to a database by using a standard connection string. (* for Mandatory) In the body of activity Configure

Connection String (String)* - The connection string used to establish a database connection. E.g: “Server

and structure your code better. Eg: Database Connect Output Database Connection - The database connection

Database Connect

Database Connect

Database

" %) ((( RCA.Activities.Core.DatabaseConnect == **Description** == This activity allows you to connect to a database by using a standard

)*** - The connection string used to establish a database connection. E.g: “Server=myServerAddress;Database=myDataBase

and structure your code better. Eg: Database Connect **Output** * **Database Connection **- The database

RCA.Activities.Core.DatabaseDisconnect Description This activity allows you to close a connection to a database. (* for Mandatory) Properties Connection Database Connection (DatabaseConnection)* - The database connection to be closed E.g: “Server=myServerAddress;Database=myDataBase;UserId

Database Disconnect

Database

Database Disconnect

" %) ((( RCA.Activities.Core.DatabaseDisconnect == **Description** == This activity allows you to close a connection to a database. [[image:image-20220506105152-1.png]] (* for Mandatory) == **Properties** == **Connection** * **Database Connection (DatabaseConnection)*** - The database connection to be closed E.g: “Server

. When this activity ends, the connection to the database is closed. This activity returns

Configuration Connection String (String)* - The connection string used to establish a database connection. E.g

and structure your code better. Eg: Database Transaction Use Transaction (Checkbox) Output Database Connection

Database Transaction

Database

Database Transaction

" %) ((( RCA.Activities.Core.DatabaseTransaction == **Description** == This activity allows you to connect to a database and features a Sequence

Configuration** * **Connection String (String)*** - The connection string used to establish a database connection. E.g: “Server=myServerAddress;Database=myDataBase;UserId=myUsername;Password=myPassword

Configuration Connection String (String)* - The connection string used to establish a database connection. E.g

(DatabaseConnection)- An already opened database connection obtained from the Database Connect and Database

statement on a database. For UPDATE, INSERT, and DELETE statements, the return value is the number of rows

Database

string used to establish a database connection. E.g: “Server=myServerAddress;Database=myDataBase;UserId

connection obtained from the Database Connect and Database Transaction activities. This property

" %) ((( RCA.Activities.Core.ExecuteNonQuery == **Description** == This activity allows you to execute a non-query statement on a database

)*- The connection string used to establish a database connection. E.g: “Server=myServerAddress;Database=myDataBase

database connection obtained from the Connect or Start Transaction activities. This property

on a database and returns the query result in a Datatable. (* for Mandatory) In the body of activity

Database

a database connection. E.g: “Server=myServerAddress;Database=myDataBase;UserId=myUsername;Password=myPassword;” * **Existing DbConnection (DatabaseConnection)** - An already opened database connection obtained from

allows you to execute a query on a database and returns the query result in a Datatable. [[image:image

installed and running normally in HTTP mode by using below components: Web server Apache Tomcat 8.5 Database

Scope) In an organization, all the machines are connected to an Active Directory server

normally in HTTP mode by using below components: ** Web server Apache Tomcat 8.5 ** Database MySQL or MSSQL

)(%%) === In an organization, all the machines are connected to an Active Directory server. They will fetch all certificates

Connection String (String)* - The connection string used to establish a database connection. E.g: “Server

(DatabaseConnection) - An already opened database connection obtained from the Connect or Start Transaction activities

) In the body of activity Configure Connection - Set connection string, data source, data provider. Data

Database

Configuration** * **Connection String (String)*** - The connection string used to establish a database connection. E.g: “Server=myServerAddress;Database=myDataBase;UserId=myUsername;Password=myPassword;” * **Existing DbConnection (DatabaseConnection)** - An already opened database connection obtained from