Follow-On Topics

Related Topics

# Technical Summary

## Working with other Tools

The other steps that the Database Query (ODBC) tool interacts with directly, whether by exposing information to it or consuming information from it, are listed below:

### Consuming from Other Tools

The Database Query (ODBC) tool does not consume directly from any other tool. Instead, it directly queries the King Task Centre database.

### Objects Consumed

Objects that the Database Query (ODBC) step consumes that are exposed by other steps are listed below.

|  | Variables (Text) — Textual data is extracted from selected variables

### Exposing to Other Tools

Icon | Tool Name | Tool Category
--- | --- | ---
| Convert Recordset to XML | Format
| Create Workflow Job | Format
| Format as Flat File | Format
| Format as HTML | Format
| Format as Text | Format
| Run Crystal Report | Format
| Run Microsoft Reporting Services | Format
| Run Microsoft Word (Merge) | Format
| Transform Data | Format
| Save File | Output
| Transfer File (FTP) | Output
| Call COM Object | Execute
| Run External Program | Execute
| Filter Data | General

### Objects Exposed

Objects that the Database Query (ODBC) step exposes that can be utilised by other steps are listed below.

|  | Recordset — Information structured into columns and rows

|  | Step Properties — A number of properties for the step are exposed in the Environment tab of the Task Browser dialog box

## Dependencies

The products, technologies, protocols or systems that are required for the Database Query (ODBC) step to work are listed below.

|  | ODBC Compliant Data Source

|  | ODBC driver Level 2.0 Support, ANSI 89, ANSI 92

NOTE:

The UDT (User define data) type available through SQL Server 2008 is NOT currently supported.

## Supported SQL Server Versions

Supported SQL Server editions are listed below:

|  | Microsoft SQL Server 2005

Express, Standard, and Enterprise editions

32- or 64-bit

|  | Microsoft SQL Server 2008

Express, Standard, Workgroup, Developer, and Enterprise editions

32- or 64-bit

|  | Microsoft SQL Server 2008 R2

Express, Standard, Web, Workgroup, Parallel Data Warehouse, Fast Track, Datacenter, Evaluation, Developer, and Enterprise editions

32- or 64-bit

|  | Microsoft SQL Server 2012

Express, Standard, Web, Workgroup, Parallel Data Warehouse, Fast Track, Datacenter, Evaluation, Business Intelligence, Developer, and Enterprise editions

32- or 64-bit

|  | Microsoft SQL Server 2014

Express, Evaluation, Standard, Web, Developer, Business Intelligence, and Enterprise editions

32- or 64-bit

|  | Microsoft SQL Server 2016

Express, Evaluation, Standard, Developer, and Enterprise

64-bit

|  | Microsoft SQL Server 2017

Express, Evaluation, Standard, Enterprise, Developer, and Web Edition

64-bit

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