Description
Establishes a connection with the database.
Parameters
Allows specifying the database management system(DBMS) that is used.
List of supported DBMS:
-
MySQL
- MSSQL
- PostgreSQL
- Oracle (64-bit versions are supported, 32-bit versions may not work stable)
Allows specifying the server address of the database that is being connected. For example, 127.0.0.1
or localhost
.
Allows specifying the port of the database that is being connected. For example, 3306
.
Allows specifying the name of the database that is being connected. For example, db_Employees
.
Allows specifying the user credentials of the database. Note that the "Login" and "Password" values will be passed to the {{login}}
and {{password}}
variables in the "Connection string" parameter.
Connection string
- Calculate a value: this allows you to use a special formula or a special method to set the query text.
For example, you can use the connection string to set the required timeout value:
`mssql://{{login}}:{{password}}@127.0.0.1?database=demo&request%20timeout=25000`
When using this string, make sure to change the parameter host 127.0.01
, the parameter database demo
and the parameter timeout 25000
to required values.
Contains an annotation of the activity. The input text will be displayed above the activity name.