Data sources

In workflow's global actions one can add automations that get executed "on start (cyclical)". It's hard to keep an overview of all workflows with such automations through all application groups, applications, processes and workflows. To get an overview one can create an MSSQL data query with the current database as connection and the following SQL query.

While the most common way is a centralized source / dictionary, it’s also possible to create tags without a dictionary.

MS Fabric is a powerful platform containing data tables in the Microsoft OneLake. This article describes how to integrate a MS Fabric lakehouse, set up necessary Entra app and connection and data source in WEBCON Designer Studio.

Using the WEBCON BPS 2025 R1 SDK type CustomRESTAuthentication

The OCR AI recognition action, thanks to its integration with ABBYY FineReader, reads the relevant items from the file attached to the workflow instance and then enters their values into the corresponding form fields. This article describes the prerequisites for updating the attachment database to improve the operation of this action for Unicode characters.

How to use proxies like HTTP Toolkit to view outgoing HTTP Requests. For example when a choose field uses a web service data source.

Version 2023 R3 introduced the ability to use the CONCAT function within the LIKE function to create advanced filter conditions on Data sources. This is particularly applicable when configuring Choice fields, allowing the list of returned values to be limited to those required by the user.
This article provides a description of the functionality along with a business case for its use.

This article provides a definition and instructions for creating the Domain users data source, its comparison with the BPS users data source, and a proposal for practical use based on a prepared business case.

Version 2021 has introduced a new feature for the environments in which there are many different people creating and modifying applications and processes. Now, you can define dedicated connections and data sources for your applications which should simplify the administration work. You will also avoid situations in which a person using a data source in one application modifies it without knowing that it may affect another application that also uses the same source.

The WEBCON BPS system enables the synchronization of exchange rates. The available sources of currency data are exchange rate tables provided by the National Bank of Poland, the European Central Bank, and the Central Bank of Russia. This article describes how to download and convert the rates provided by the European Central Bank (ECB). The table of exchange rates of the ECB returns the conversion rate of how many units of a given currency corresponds to the value of one euro. The article also shows how to convert the exchange rate on weekends (the ECB exchange rate table does not return values for weekends).