Database Automation-Connect DB

ConnectDB

When to use ConnectDB

This activity is used to initiate a connection with the Database for further processing.

Figure 1

Activity Name

Picture

ConnectDB

ac

Technical Reference

Figure 1. 2

cp 

S.no

Description

1

Specify the database name to connect

2

Specify the database server name

3

Specify the password string for connecting the DB

4

Specify the DB time out value(  specifies the time limit in which the connection to the DB server must be made, else it will throw an exception)

5

Specify the username for connecting the DB

6

Displays the action that the activity performs in the workflow

7

Specify whether to continue executing the workflow even if the activity fails

8

Specify the Boolean variable which reveals the success state of the activity

9

Specify the SQLConnection variable which holds the DB connection which can be re used in all other DB activities

t    SqlConnection should be defined as a SqlConnection System.Data.SqlClient.SqlConnection

a Activity: The ConnectDB helps in creating a connection with the database to which any interaction needs to be done, post which any automation can be accomplished using the database.

 

Release date
Version
v4.0.2