• Chapter 1: Getting Started with Stylus Studio®
• Chapter 2: Editing and Querying XML
  • Creating XML Documents
  • Using Document Wizards to Create XML
    • How to Use a Document Wizard
    • Creating XML from XML Schema
    • Creating XML from DTD
    • Creating XML from HTML
    • Creating XML from ADO
  • Updating XML Documents
  • Using the Text Editor
  • Updating DOM Tree Structures
  • Using the Grid Tab
  • Diffing Folders and XML Documents
  • Using Schemas with XML Documents
  • Converting XML to Its Canonical Form
  • Querying XML Documents Using XPath
  • Printing XML Documents
  • Saving XML Documents
• Chapter 3: Converting Non-XML Files to XML
• Chapter 4: Working with XSLT
• Chapter 5: Creating XSLT Using the XSLT Mapper
• Chapter 6: Debugging Stylesheets
• Chapter 7: Defining XML Schemas
• Chapter 8: Defining Document Type Definitions
• Chapter 9: Writing XPath Expressions
• Chapter 10: Working with XQuery in Stylus Studio
• Chapter 11: Composing Web Service Calls
• Chapter 12: Accessing Relational Data as XML
• Chapter 13: Building XML Pipelines
• Chapter 14: Publishing XML Data
• Chapter 15: Integrating with Third-Party File Systems
• Chapter 16: Extending Stylus Studio
• Chapter 17: The Stylus Studio Java API
• Chapter 18: Stylus Studio GUI Reference

Home > Online Product Documentation > Table of Contents > Creating XML from ADO

Creating XML from ADO

You can use the XML from ADO document wizard to create XML from relational database objects like tables and views. This document wizard allows you to access any relational database that supports OLE DB, such as SQL Server.

After you specify the OLE DB provider and database server connection information on the Microsoft Data Link Properties dialog box, Stylus Studio displays the Import from External Source dialog box, shown here:

Figure 118. Import from External Source Dialog Box

You use this dialog box to specify either:

When you click OK, Stylus Studio selects the database object (or executes the SQL statement) and returns it as an XML document in the XML Editor.