Format Tools - XML to Recordset

The XML to Recordset Tool is used to create a Task Step that converts XML produced by other tools such as connector tools feeding other systems into Recordsets for use in the many other tools which consume recordsets for uses such as powering alerts via fax/email/sms, create reports, power a workflow, perform FTP transfer, etc.

The options set in the configuration of the step determine the fields present in the output recordset. Only those fields selected from the tree structure will be created in the output recordset.

At runtime, the data exposed in the output Recordset of the step is a union of all the child objects selected in the XML structure, thereby converting the hierarchical data contained within the XML into a flat recordset as used by many other tools in TaskCentre.

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
• Format as Text
• Format as HTML
• Run Crystal Report
• File Transfer (FTP)
• Run Program
• Call COM Object
• Run VB Script
• Decision
• Data Filter
• XML Document Import
• Flat File Import Tool

Dependencies

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

• None

Consumes

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

• XML Documents - Hierarchically structured information

Exposes

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

• Recordset - Information Structured into Columns and Rows