Input Tools

Pulls information into TaskCentre from a source such as a relational database (RDBMS), file format or other structured source and exposes this to other Actions.

Input Tools - Database Query

The Database Query 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 to name but a few. Once obtained by this action the information is then available to other Format or Output Tools for manipulation and/or delivery.

The Database Query (ODBC) Tool has comprehensive ODBC support for both modern and legacy platforms supporting both the SQL 89 and SQL 92 ODBC standards and variations thereof.

Input Tools - Call Procedure

The versatile Stored Procedure Tool provides the ability to execute database stored procedures and functions to provide read, write and automated data processing. The Tool supports any RDBMS with a functional OLEDB Provider thus enabling native support for a multitude of data sources. If a procedure generates a result set, the Tool can return this to other Tools for format and/or delivery. Conversely, the Tool can consume a result set to enable multiple procedure calls or indeed simply execute a single procedure. Procedure calls can be passed static or dynamic parameters in order to control the precise nature of the call being made.

Input Tools - Database Query (OLEDb)

The Database Query (OLEDb) Tool is used to create a Task Step that allows the extraction of specific information sets from relational database systems such as ERP, Financial, Accounting, MRP, Production, CRM, HR, Project and Bespoke systems to name but a few.

Input Tools - XML Document Import

This tool allows XML files on disk (local or UNC) to be imported into TaskCentre. It can retrieve a specific file specified or from a previous step, or a wild carded file name. If a wild carded selection is made it will retrieve the oldest file first so can be used to process files in the order that they are created.

Input Tools - Flat File Import Tool

The Flat File Import provide the ability to import flat files such as plain text or csv (delimited or fixed width), extract data from flat files and expose that information as either a recordset or XML for use in other TaskCentre BPM Tool, Import flat files types that have multiple record types i.e. orders and product lines within a single file and import flat files in sequence so that business applications are updated chronologically.