Applies to version 2017.1.x; Author: Tomasz Pytlak Introduction: SharePoint lists are a convenient method of data storage to which choice fields can use as data sources and refer to its values. However after exceeding a certain amount of data, using them as a form fields’ data source significantly slows down the system. In this case, […]
Category: Data sources
Configuration of internal and external data sources that can be used by WEBCON BPS
Connections and data source definitions
Applies to version 2017.1.x and newer; Author: Karol Wożniak Overview In older versions of WEBCON BPS, the operations on external and internal data sources were enclosed in a relatively simple mechanism. In order to use the information stored in the database or available through external services (e.g. REST API) we used to create a dedicated […]
BPS Integration scenarios with SalesForce and Dynamics REST API
Applies to version 2016.1.x; Author: Karol Wozniak BPS version 2016 introduced new functionalities which allow simple integration with external service providers. The integration is conducted through the usage of API (Application Programming Interface) supplied by third party vendors. From the perspective of WEBCON BPS, the API can be employed in one of two ways: As […]
‘Domain users’ type data source
Applies to version 2016.1.x; Author: Damian Matuła Every business process has a number of so-called “participants”: Authors (aka. originators, e.g. an employee registering a business trip) Approvers (e.g. superiors in a vacation process, accountants in an expense report workflow) All other assignees, delegates and decision makers involved in a process directly or indirectly (e.g. employees […]
WEB SERVICE – Action and Data source
Applies to version: 2016.1.x; Authors: Piotr Bagazja & Karol Woźniak Expectations & Limitations WSDL The Web Service description (WSDL file – interface definition) can either be provided locally from the hard drive or through HTTP/HTTPS protocol. In both cases, it must fulfill certain requirements: For HTTP/HTTPS, if authentication is required, the user must provide a […]
Absence process – Types of data sources
Applies to version 8.3 and higher; Author: Damian Matuła WEBCON BPS is capable of quickly generating a leave of absence/vacation process. This is possible through an ‘Absence process wizard’ available from the ‘Tasks’ menu at the top of Designer Studio. Generating a process through the wizard is very straightforward, it is made up of ten […]
Improving MSSQL performance – the forgotten TEMPDB database
Applies to all versions; Author: Paweł Jawień The performance of WEBCON BPS is closely related to the performance of MS SQL on which the BPS database operates. Once we’ve overcome RAM shortages, optimized storage space for the process database, relieved overburdened processors and implemented a suitable database maintenance schedule, we may think that we’ve got […]
Reporting from WEBCON BPS Database
Applies to version: 8.x; Author: Bartłomiej Spyrka 1. Introduction 1.1. Content This document contains piece of information about data kept in workflow database. Document is focused on two primary SQL tables: 1) WFElements Table contains information about data provided by uses due to filling the forms (process). 2) WFElementDetails Table contains data provided by users […]
Creating SharePoint list from template
aplies to version 8.0.x; author: Karol Wozniak Action allows to create a new SharePoint list from existing list template. It creates possibility for rapid replication of existing list which was earlier saved as list template. Combined with a possibility of saving any SharePoint list with content as a template this action can boost efficiency and […]