Skip to main content

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.
You can also load and edit the data of a lookup list from external databases.

info

To use the SQL integration, you must activate the corresponding feature in the business unit management.

Connection​

To communicate with a server via SQL actions in linqi, you must first create a corresponding connection in the connection management (the button in the navigation). In the connection list, you can use the plus button in the upper right corner and then select SQL.

In the connection settings, you have the following options:

  • Display name:
    The display name helps you reuse the connection and can be freely chosen.
  • Database system:
    Here you select the type of database system you want to connect to. You can choose between SQL Server, PostgreSQL, MySQL, and Oracle.
  • Connection string:
    Enter the connection string that will be used for the connection here. It cannot be retrieved again afterward.
  • Authorized users:
    Here you can restrict which users are allowed to use this connection in the process designer, details can be found here.

Actions​

You can find the SQL actions in the process actions section.