Format Tools - Recordset to XML

The Recordset to XML Tool is used to create a Task Step that converts recordsets produced by other tools such as the ODBC query into XML documents either for use in other tools such as connector tools feeding other systems or saving to file for consumption by another system. Multiple recordsets can be included in a hierarchical XML document.

There is no global configuration required for this tool.

The tool has two modes: Auto Generation of the output XML, and manual generation. In auto mode, the structure of the XML and the key fields within each level are automatically determined by the tool. In manual mode, the user may change the structure and key fields, which will in turn affect how the data is translated into XML.

The XML documents produced can be consumed by connector tools such as the SalesLogix or Sage Line 500 Connector tools or can be consumed by the Save to File Tool. It is also possible to convert them back to a recordset using the Recordset to XML tool.

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.

• Query Database
• Call Procedure
• Save as File
• Flat File Import Tool

Dependencies

These are other products, technologies, protocols or systems that are required for the tool to work.

• TaskCentre Connectors developed for passing and receiving data into and from other systems.

Consumes

Objects that the Tool consumes that are exposed by other actions. Match these with `Exposes' in other Tool specifications.

• Recordset - Information Structured into Columns and Rows

Exposes

Objects that the Tool exposes that can be utilised by other tools. Match these with `Consumes' in other Tool specifications.

• XML Documents - Hierarchically structured information