Search: database-connect

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

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

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

the application.yml file Step 2 - Update the database connection by updating the datasource section (database server

the database connection by updating the datasource section (database server, username, password…) [[image

machine. 1.4. MSSQL Database Connection Requirements The installation machine must have network connectivity to the pre-established MSSQL database. The required configuration information for Center to connect to the database includes: # Information Description 1 DB-SERVER IP address of the MSSQL Database

. === (% style="font-size:20px" %)**1.4. **(%%)**MSSQL Database Connection Requirements** === * The installation machine must have network connectivity to the pre-established MSSQL database. * The required configuration information for Center to connect to the database includes: |**#**|**Information**|**Description** |1|DB

. 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

. Configure Oracle Database connection 1. Open the file application-prod.yml cd /opt/tomcat/webapps/ROOT/WEB

: 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

and prepare below information of each database for connecting: # Information Description 1 DB-SERVER Database

ESC then type: :wq C. Configure Database connection 1. Open the file application-prod.yml cd

as a database, cache, message broker, and streaming engine, allows for fewer database accesses, which helps

that **these databases are ready to use** and prepare below information of each database for connecting: (% style="width

Database connection(%%) ===== (% style="margin-left:40px" %) ~1. Open the file application-prod.yml

Centers. |5|Redis Cache|(% style="width:690px" %)In-memory data structure store used as a database, cache