Follow-On Topics

Related Topics

# Technical Summary

## Working With Other Tools

The other tools that the Transform Data tool directly interacts with to consume XML or recordset data from 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
| Call Stored Procedure (OLEDB) | Input, Data Connectors, Output, and Execute
| Import Flat File | Input
| Import XML Document | Input
| Convert Recordset to XML | Format
| Convert XML to Recordset | Format
| Transform Data | Format
| Call Task | Execute
| Filter Data | General
| Web Service Connector | Data Connectors
| Applications Platform Connector | Data Connectors

### Objects Consumed

Objects that the Transform Data step consumes that are exposed by other steps are listed below.

|  | XML — XML data from any King Task Centre tool capable of exposing XML, such as the Convert Recordset to XML or Import XML Document tool.

|  | Recordset — Information structured into columns and rows produced by a tool such as the Database Query (ODBC) tool.

### Exposing to Other Tools

A Transform Data tool can directly expose its XML output for use by the following steps listed below.

Icon | Tool Name | Tool Category
--- | --- | ---
| Format as Flat File | Format
| Run Microsoft Reporting Services | Format
| Save File | Output
| Call Task | Execute
| Applications Platform Connector | Data Connectors

### Objects Exposed

Objects that the Transform Data tool exposes that can be utilised by other tools are listed below.

|  | OutputXML — The object XmlString is the XML document produced by the tool. The XML structure is based on the structure set within the Main tab and contains data governed by the tool mappings. The object XmlSchema contains the output schema in XSD format.

|  | ErrorXML — The object XmlString contains any error data reported by the tool at runtime, this object is only populated in the event of a step failure. Error messages posted to the King Task Centre event log appears in the XML document. The object XmlSchema contains the error schema in XSD format.

|  | Step Properties — Standard step properties are also available allowing you to utilise statistical data of the Transform Data step.

## User Security

The Transform Data tool appears within the User Properties dialog box under the Tool Access tab. Only users with the tool selected have permission to use the tool when building a task.

## Global Configuration

The Transform Data tool does not require any global configuration before being used in a task.

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