Database – your databases directly in the process
Most decisions need data that lies outside linqi – in SQL Server, MySQL and other databases. With the linqi database integration, your processes access this data directly: you run SQL queries and bring the results into your process run as values. This turns static evaluations into lively, process-driven decisions. The connection maintained as a central connection contains the required access data, so that access to your databases stays centrally controlled, is maintained in one place, and is not scattered across individual processes in a way that is hard to trace or update later.
The connection to your database is maintained centrally as a connection in linqi – including the required access data. This way all your processes use the same, maintained integration, instead of each integration being maintained separately. This keeps the access to your databases controlled, traceable and in one place. Your processes read the data they need and use it purposefully – without manual export and import.
From the process to the database – and back
With the database integration, your linqi processes access your databases directly. The connection is maintained centrally as a connection in linqi – including the required access data – so that all processes use the same, maintained integration. In the process itself you run SQL queries; the queried values are then available to the process run in a structured way and can be used for rules, documents or further processing. This eliminates the manual export and import of data, and your processes make decisions based on current, external data – controlled and in one place.
How you connect your database
- Create the connection:
You create a central database connection in linqi – with the connection to your database. - Run the SQL query:
In the process, a SQL query is run – for example to read certain data. - Result in the process:
The queried values are available to the process run – for rules, documents and further processing. - Centrally maintained:
All processes use the same connection – in one place, controlled and traceable.
This turns your database into a source your workflow accesses purposefully.
Frequently asked questions about the database integration
Which databases does linqi support?
linqi can access common relational databases via a central connection – the specific connection is set up when you create the connection.
What can a process do with the database?
It can run SQL queries and use the queried values in the process run – for rules, documents and further processing.
How is the connection maintained?
As a central connection in linqi – all processes use the same, maintained integration in one place.
Who does this benefit?
Anyone who makes decisions based on external, current data and does not want to manually export and import it.