Search: database-connect

. Database connection Your akaBot Center machine needs to be connected with your Database server. Moreover, please prepare below information for akaBot Center to connect to your database: # Information

. Save changes and exit Press ESC then type: :wq 2.4.2.3. Configure Oracle Database connection 1

: 32GB or more * Core: 8 CPU or more * SSD: 500GB == 1.2. Database connection == Your akaBot Center machine needs to be connected with your Database server. Moreover, please prepare below information for akaBot Center to connect to your database: (% style="width:427.778px" %) |(% style="width:43px

with another port. Installation 1. MySQL 8.0 1.1. Create new database for conductor by the following sql create database automationinsight; 1.2. Config mysql connection: open file application-prod.yml 2

port. == **Installation** == === 1. MySQL 8.0 === 1.1. Create new database for conductor by the following sql (% style="color:#3498db" %)create database automationinsight; 1.2. Config mysql connection

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

)*- 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

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

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

. 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

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