Description

This activity allows you to establish the connection to any of the following DBMS types: MySQL, PostgreSQL, MSSQL, and Oracle. After the connection is established, you can execute a query. 

Parameters

DBMS type

Allows you to specify the database management system (DBMS) to be used.

List of supported DBMS:

Set up method

Basic parameters

DBMS host

Allows specifying the server address of the database that is being connected. For example, 127.0.0.1 or localhost.

DBMS port

Allows specifying the port of the database that is being connected. For example, 3306.

Database name

Allows specifying the name of the database that is being connected. For example, db_Employees.

Login and password

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.

Note. If you want to use the values of login and password from variables in the activity “Connect to database“, you need to use “Connection string“ as a method of connection to DB with the following syntax:

`mssql://${username}:${password}@localhost?database=TESTDB2&request%20timeout=25000`

where username​ - is the variable that contains the value of the login; password​ - is the variable that contains the value of the password.
In the mandatory parameter “Login and password“ of this activity you can set any value, it won't affect the performance of the activity.

Connection string

1. 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.

Here, look at another example of passing a connection string to the Oracle database. In the "Calculate the Value" field add localhost:port/SID.

Comment

Contains an annotation of the activity. The input text will be displayed above the activity name.