Follow-On Topics

Related Topics

# Technical Summary

## Working with other Tools

The other tools that the Filter Data Step interacts directly with, whether by exposing information to it or consuming information from it, are listed below.

### Consuming from Other Tools

Icon | Tool Name | Tool Category
--- | --- | ---
| Database Query (ODBC) | Input and Data Connectors
| Database Query (OLEDB) | Input and Data Connectors
| Import Flat File | Input
| Convert XML to Recordset | Format

### Objects Consumed

Objects that the Filter Data Step consumes that are exposed by other Steps are listed below.

|  | Recordset — Information structured into columns and rows

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

### Exposing to Other Tools

Icon | Tool Name | Tool Category
--- | --- | ---
| Call Stored Procedure (OLEDB) | Input, Data Connectors, Output, and Execute
| 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

### Objects Exposed

Objects that the Filter Data Step exposes that can be utilised by other Steps are listed below.

|  | RecordSource — Displays the columns included in the recordset being used as the data source.

|  | Recordset — A subset of the consumed recordset information structured into columns and rows

|  | FilterDefinitions — Displays the Filters assigned to the Step and the data being used.

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

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