Description
Establishes a connection with the database.
Parameters
Allows to specify 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 to specify the server address of the database that is being connected. For example, 127.0.0.1 или localhost.
Allows to specify the port of the database that is being connected. For example, 3306.
Allows to specify the name of the database that is being connected. For example, db_Employees.
Allows to specify the user credentials of the database.
Connection string
- Calculate a value: 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 to the activity. The input text will be displayed above the activity name.