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.