Input Tools

The Call Stored Procedure (OLEDB) tool executes database stored procedures and functions to provide read, write, and automated data processing.

The Database Query (ODBC) tool allows 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 for manipulation or delivery, or both.

The Database Query (OLEDB) tool allows 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 for manipulation or delivery, or both.

The Import Flat File tool imports a delimited or fixed-width file from disk into BPA Platform, extracts the file content including any file properties, then outputs it as either a recordset or as XML. The columns that make up the recordset, and the nodes and nested elements for the XML file, can either be inferred from an imported example or created manually.

The Import XML Document tool imports an XML document to be used and processed by other task steps. To validate the XML documents at runtime, you can either import an XML schema file (XSD), inferred from an existing XML document, or manually constructed.

Inbound messages to ToucanText can be processed using the Retrieve Text Message tool. Delivery receipts for messages sent by the Retrieve Text Message tool can also be processed.