Configuring an XML Transform

If the data source you configured for your Input Source doesn’t already contain data in the relational database result set format, you must configure WorkSpace Data Federation to transform the data into result set format.

Prerequisites 

Before starting this procedure, you must already have selected the Transform tab in the Input Source Properties dialog, clicked Define, and selected From XML to Result Set in the Transform Definition Wizard.

Start this task from the Transform Definition XML to Result Set Transform page.

  1. Use the Row Element browser to select the repeating element in your XML document that delimits the “rows” in the data.
  2. Click Next. The Column Definitions page appears.
  3. (Optional) Add parameters, Delete parameters, or change the order of the parameters in the displayed table (Move Up, Move Down).
  4. Edit the column properties as needed. The fields that define the columns are described elsewhere.
  5. Click Finish to save your changes and close the wizard.
Next 

Configure error handling for this Input Source.

Related reference
Properties Dialog Field Descriptions

Send your feedback on this help topic to Sybase Technical Publications: pubs@sybase.com

Your comments will be sent to the technical publications staff at Sybase, Inc. For product-related issues or technical support, contact Sybase Technical Support at 1-800-8SYBASE.