«SQL» module

The «SQL» module provides work with databases. Supported DBMSs: MS SQL and PostgreSQL.

Module interface

This module provides work with databases. The following DBMSs are supported: MS SQL and PostgreSQL. To work with a database you need to fill out all the fields in the «SQL» module window.

The window consists of the following fields: «DBMS», «Data source», «Data base», «Login», «Password», «SQL-script» and «Variable».


The fields «Data source», «Database», «Login» and «Password» provide a connection to the database.

The «SQL-script» field. The script in SQL language is entered into this field, entering variables of the Studio is supported.

The «Variable» field. The name of the variable is entered in the field into which the response from the database will be entered in the form of a table. Only one table can be returned in one SQL module, subsequent ones will be ignored.