| Active |
|---|
| This application does not need additional settings. So you can make connectionUnique, active service acces point to a network. There are different types of connections (API key, Oauth…). only by using your login credentials or by following the instructions below . |
![[Important]](https://docs.boost.space/wp-content/themes/bsdocs/docs-parser/HTML/css/image/important.png) |
Important |
|---|---|
|
Any references to third-party products or services do not constitute Boost.spaceA platform that centralizes and synchronizes company data from internal and external sources, offering a suite of modules and addons for project management, CRM, data visualization, and more. Has many features to optimize your workflow! Product Documentation nor do they create any contractual obligations. This material is for informational purposes only and is subject to change without notice. Boost.space does not warrant the availability, accuracy, reliability, completeness, or usefulness of any information regarding the subject of third-party services or systems. |
The above modulesa module is an application or tool designed to handle specific business functions, such as CRM, project management, or inventory. The system's modular architecture allows you to activate only the modules you need, enabling customization and scalability as your business requirements evolve. let you execute your custom logic directly on your database server through stored procedures. Boost.space IntegratorPart of the Boost.space system, where you can create your connections and automate your processes. loads interface of input/output parameters and recordIn Boost.space, a record is a single data entry within a module, like a row in a database. For example, a contact in the Contacts module or a task in the Tasks module. set dynamically so each parameter/value can be mapped individually.
Before you start configuring your scenarioA specific connection between applications in which data can be transferred. Two types of scenarios: active/inactive., make sure the account you’re using to connect to your database has read access to INFORMATION_SCHEMA.ROUTINES and INFORMATION_SCHEMA.PARAMETERS views.
Supported Versions: SQL Server 2012/2014/2016/2017/2019/2022
To learn more about creating a stored procedure, see Microsoft SQL Server documentation.
Boost.space Integrator does not support multiple record sets, only the first one is processed.
If SSL encryption is enabled, a valid SSL certification must be obtained. For more details, refer to the Microsoft SSL Configuration Guide.
When integrating SQL Server with other services, consider breaking down large datasets into smaller batches to ensure smooth data retrieval and avoid any potential issues.
This errorService is unavailable due to a failure, a service responds with unexpected data or the validation of input data fails. occurs when you modify the same data using multiple modules. It is caused by SQL transactions.
When any SQL modulea module is an application or tool designed to handle specific business functions, such as CRM, project management, or inventory. The system's modular architecture allows you to activate only the modules you need, enabling customization and scalability as your business requirements evolve. is executed then it starts the transaction (1) and the transaction is finished after the scenario is fully executed. If another module tries to access the same data used in another unfinished transaction (1) then it has to wait until the previous transaction (1) is finished – but it never happens because the first transaction (1) will be finished after the scenario is finished.
Solution
Turn on Auto-commit. It finishes (commits) every transaction immediately after the module execution is done.
1. Open Scenario settings.
2. Enable the Auto commitThe Auto commit option defines how Boost.space Integrator processes data transactions. Enabling Auto commit switches all operations to the commit phase. In the case of an error, data commits immediately and you cannot restore any lost data. checkbox.
3. Confirm the settings dialog by clicking the OK button.
