• Chapter 1: Getting Started with Stylus Studio®
• Chapter 2: Editing and Querying XML
• 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
  • About Stylus Studio XML Enterprise Suite
  • About Stylus Studio XML Home Edition
  • About Stylus Studio XML Professional Suite
  • Add Column
  • Add References to Schema
  • Add Table
  • Assign Shortcut
  • Associate XML Schemas to Project Folder
  • Attach to JVM
  • Authentication Required
  • Backmap Stack
  • Breakpoints
  • Build Project From SCC
  • Call Stack
  • Choose Manager
  • Choose Module
  • Choose Provider
  • Choose Root Element
  • Choose Server
  • Choose Source and Destination Schema
  • Class Properties
  • Configure External XQuery Processor
  • Connection Settings
  • Convert HTML to XML
  • Convert HTML to XSLT
  • Convert to XML Editor
  • Convert XML to XML Schema
  • Create Java Console
  • Create Java Servlet
  • Create Schema or DTD
  • Create User-Defined Catalog
  • Create XML Document from DTD
  • Create XML Document from XML Schema
  • Create XML Schema from EDIFACT Message Definition
  • Create XML Schema from IATA Message Definition
  • Create XML Schema from X12 Transaction Set
  • Custom Document Wizard Arguments
  • Customize Toolbars
  • DB-to XML-Data Source Editor
  • Default Value
  • Diff Folders
  • Document Wizards
  • DTD Schema Editor Text Tab
  • DTD Schema Editor Tree Tab
  • DTD to XML Schema (Trang)
  • Existing Java Files
  • Find
  • Find (Mapper)
  • File Explorer
  • Generate Java Code for XML Pipeline
  • Generate Java Binding Class
  • Generate Java Web Service Client
  • Generate Transformation
  • Go To (Convert to XML)
  • Go To
  • Import from External Source
  • Input
  • Insert Table
  • Java Class Browser
  • Java Code Generation
  • Java Editor
  • Keyboard Accelerators
  • Lookup List
  • Mark Logic Server Settings
  • Name
  • Named Template
  • Named/Matched Template
  • New Converter
  • Notes
  • Open and Save As
  • Options
  • Options - Application Settings
  • Options - General - Back-mapping
  • Options - General - Custom Document Wizards
  • Options - General - Custom File Systems
  • Options - General - Custom Tools
  • Options - General - Custom Validation Engines
  • Options - Module Settings - DB-to-XML - Default Database Connection
  • Options - General - Editor Format
  • Options - General - Editor General
  • Options - General - File Types
  • Options - General - Java Virtual Machine
  • Options - General - Spell Checking
  • Options - Module Settings - Java - Debugger
  • Options - Module Settings - XML Diff - Engine
  • Options - Module Settings - XML Diff - Presentation
  • Options - Module Settings - XML Editor - XML Settings
  • Options - Module Settings - XML Schema Editor - Diagram
  • Options - Module Settings - XML Schema Editor - Documentation
  • Options - Module Settings - XML Schema Editor - XML Schema to XML
  • Options - Module Settings - XQuery - XQuery Settings
  • Options - Module Settings - XSLT Editor - Mapper
  • Options - Module Settings - XSLT Editor - WYSIWYG
  • Options - Module Settings - XSLT Editor - XSLT Settings
  • Output Window
  • Personal Dictionary Editor
  • Preview Window
  • Processor Mismatch
  • Processor Settings (XQuery)
  • Processor Settings (XSLT)
  • Project Classpath
  • Project Window
  • Project Wizards
  • Properties for XML Converters
  • Properties for XML Pipelines
  • Properties for XML Publisher
  • Properties for DTD Nodes
  • Properties for XML Schema Nodes
  • Proxy Settings
  • Redefine Schema Symbols
  • Referenced Schemas
  • Register and Activate Stylus Studio
  • Rename Column
  • Replace
  • Saxon XSLT Settings
  • Scenario Properties Bindings Tab (Web Services)
  • Scenario Properties Connection Settings Tab
  • Scenario Properties Deployment Tab
  • Scenario Properties General Tab (XSLT)
  • Scenario Properties Parameter Values Tab (XSLT)
  • Scenario Properties Postprocess Tab (XSLT)
  • Scenario Properties Profiling Options Tab (XSLT)
  • Scenario Properties Processor Tab (XQuery)
  • Scenario Properties Processor Tab (XSLT)
  • Scenario Properties General Tab (XQuery)
  • Scenario Properties Parameter Values Tab (XQuery)
  • Scenario Properties Profiling Options Tab (XQuery)
  • Scenario Properties - Validation Tab (XQuery)
  • Scenario Properties - Validation Tab (XSLT)
  • Schema Diagram Properties
  • Schema Instances
  • Select Multiple URLs
  • Select Source/Target Folder
  • Select XML Converter
  • Set Node and Match Pattern
  • Setting a Classpath
  • Shortcut Keys
  • Source Code Control Properties
  • Spelling
  • Stylus Studio
  • Stylus Studio Update
  • Text Catalog to XML Catalog
  • Toolbox Pane
  • Type Derivation
  • UDDI Registry Browser
  • Value
  • Variables
  • View Sample XML
  • Watch
  • Watch Video Demos of Stylus Studio Features
  • Web Service Call Composer
  • XML Diff Editor - Merged View
  • XML Diff Editor - Split View - Text
  • XML Diff Editor - Split View - Tree
  • XML Editor Grid Tab
  • XML Editor Schema Tab
  • XML Editor Text Tab
  • XML Editor Tree Tab
  • XML Pipeline Editor Canvas
  • XML Publisher Canvas
  • XML Publisher Data Sources Panel
  • XML Publisher Namespaces Pane
  • XML Schema Editor Diagram Tab
  • XML Schema Editor Documentation Tab
  • XML Schema Editor Tree Tab
  • XPath Editor
  • XPath Query Editor
  • XPath for xsl: Elements
  • XQuery Editor
  • XQuery Editor - XQuery Source Tab
  • XQuery Editor - Mapper Tab
  • xsl:choose
  • XSLT Editor - Mapper Tab
  • XSLT Editor - Params/Other Tab
  • XSLT Editor - WYSIWYG Tab
  • XSLT Editor - XSLT Source Tab

Home > Online Product Documentation > Table of Contents > Import from External Source

Import from External Source

You use the Import from External Source dialog box to specify the database object (or SQL statement) you want to select from the relational database for conversion to XML. This dialog box appears after you specify the OLE DB provider and server connection settings in the ADO to XML document wizard.

Fields

Database Object

The type of database object you want to convert to XML (table or view, for example).

Object Name

The name of the database object you want to convert to XML.

SQL Statement

Instead of specifying a database object explicitly, you can choose to enter an SQL statement to query a database. In this case, the query result is returned as an XML document when you run the document wizard.

For More Information

Creating XML from ADO

Using Document Wizards to Create XML

Chapter 12Accessing Relational Data as XML