This video is intended as an overview of functionality.
The Database Query tool can be used to create SQL queries using drag and drop tools within BPA Platform.
This allows for the extraction of specific information sets from relational database systems such as ERP, Financial, Accounting, MRP, Production, CRM, HR, Project, and bespoke systems.
Once obtained, the data is then available to other task steps in BPA Platform for manipulation or delivery, or both.
There are two variants of the tool, Database Query (ODBC) and Database Query (OLEDB).
Both have comprehensive support for both modern and legacy SQL standards and the OLEDB version has the support for the Call Stored Procedure Tool.