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.

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
• Recordset to XML
• XML to Recordset

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.