Follow-On Topics

Related Topics

# About the Database Query (ODBC) Tool

The Database Query (ODBC) 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.

Once obtained, the information is then available to other Format or Output Steps 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.

## Features

|  | Support for SQL 89 & 92 and variations thereof

|  | ODBC Direct or ODBC Via DAO

|  | System, User and File DSNs

|  | Forward-Only or Scrollable Cursors

|  | Catalogues and Schemas

|  | Support for all primary SQL clauses

|  | System Tables, User Tables, Views

|  | Inner joins, Outer joins, Formula Joins, Cartesian product

|  | Formula Columns

|  | Table Aliasing

|  | Flexible Pre-built Date Criteria

|  | Drag & Drop Visual Criteria building with nested parentheses (brackets)

|  | Common and custom Predicates

|  | SQL Free-type mode

Copyright © 2018 Quadrant Software B.V. All rights reserved.