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.
» Third party product and technology license disclaimer
Works with other Tools
These are other Tools that this Tool will interact directly with whether by exposing information to it or consuming information from it.
Call Procedure
Format as Text
Format as HTML
Run Crystal Report
File Transfer (FTP)
Save as File
Run Program
Call COM Object
Run VB Script
Decision
Data Filter
Dependencies
These are other products, technologies, protocols or systems that are required for the tool to work.
- • ODBC Compliant Data Source
- • ODBC driver - Level 2.0 Support, ANSI 89, ANSI 92
Exposes
Objects that the Tool exposes that can be utilised by other tools. Match these with ‘Consumes’ in other Tool specifications.
- • Recordset - Information Structured into Columns and Rows
