SQL

The SQL integration in linqi allows you to interact with external SQL databases. For example, you can write data to an external database from within a process or load values from it.

info

To work with SQL actions, you must create a corresponding connection and activate the corresponding feature.

SQL Command

With this action, you can execute a SQL query. The query can be used to read, write, or delete data.
The following configuration options are available:

• Connection:
  Select the connection (see above) that is used to authenticate with the server.
• Query:
  Define the SQL query that should be executed on the server.
• Parameters:
  This section allows you to define parameters. These can be input as well as output parameters. For each parameter, you can configure the following values:
  • Name:
    Specifies the name of the parameter. This name is used to reference the parameter in the query.
  • Type:
    Select the data type of the parameter.
  • Value:
    If the parameter is an input parameter, define the value that is passed to the parameter here.
  • Output:
    If this switch is disabled, the parameter is treated as an input parameter. Otherwise, the parameter is used as an output parameter.
    Output parameters are then available as placeholders.
• Output columns:
  In this section, you can define the output columns. These are required so that linqi can provide the columns as placeholders.
  For each column, you must define the following values:
  • Name:
    Specifies the name of the column. This value must match the column name in the SQL query to ensure correct mapping.
  • Type:
    Select the data type of the column.
• Enable error output:
  Once you enable this option, you can catch and process errors.

This action provides the following placeholders:

• Output parameters:
  Output parameters can be referenced as placeholders. The data type of the output parameter determines the format of these placeholders.
• Output columns:
  Output columns can also be referenced as placeholders. They can additionally be iterated over using a loop.