If you wish to follow the video you will require
- The training database, available from:
- For the Database to be imported the end client must have at least SQL 2017 installed
BPA Platform - Specification as listed here:
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.