• 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: Extending Stylus Studio
• Chapter 14: Stylus Studio GUI Reference
  • About Stylus Studio
  • Add Column
  • Add References to Schema
  • Add Table
  • Assign Shortcut
  • Attach to JVM
  • Backmap Stack
  • Breakpoints
  • Build Project From SCC
  • Call Stack
  • Choose Manager
  • Choose Module
  • Choose Provider
  • Choose Root Element (DTD)
  • Choose Root Element (XQuery Mapper)
  • Choose Schema
  • Choose Server
  • Choose Source and Destination Schema
  • Class Properties
  • Convert Fixed Width to XML
  • Convert to XML Editor
  • Create Schema or DTD
  • CSV to XML
  • Customize Command (Buttons)
  • Custom Document Wizard Arguments
  • Customize Toolbars
  • DB-to XML-Data Source Editor
    • Connection Settings
    • SELECT Tab
    • UPDATE Tab
    • Database Schema Tree
    • For More Information
  • Diff Folders
  • Document Wizards
  • DTD Schema Editor Text Tab
  • DTD Schema Editor Tree Tab
  • DTD to XML Schema
  • Find
  • Go To (Convert to XML)
  • Go To
  • Input
  • Insert Table
  • Java Class Browser
  • 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 - Application Settings - Backmapping
  • Options - Application Settings - Custom Document Wizards
  • Options - Application Settings - Custom File Systems
  • Options - Application Settings - Custom Tools
  • Options - Application Settings - Default Extensions
  • Options - Applications Settings - Editor Format
  • Options - Application Settings - Editor General
  • Options - Application Settings - File Types
  • Options - Application Settings - Java Virtual Machine
  • Options - Module Settings - DBtoXML - Default Connection
  • Options - Module Settings - Java - Debugger
  • Options - Module Settings - Java - External JVM
  • Options - Module Settings - Java - Java Compiler
  • Options - Module Settings - XML Diff - Engine
  • Options - Module - Settings - XML Diff - Presentation
  • Options - Module Settings - XML Editor - Custom Validation Engines
  • Options - Module Settings - XML Editor - XML Settings
  • Options - Module Settings - XML Schema Editor - Diagram
  • Options - Module Settings - XSLT Editor - External XSLT
  • Options - Module Settings - XSLT Editor - Mapper
  • Options - Module Settings - XSLT Editor - WYSIWYG
  • Options - Module Settings - XSLT Editor - XSLT Settings
  • Output Window
  • Project Window
  • Project Wizards
  • Properties for XML Converters
  • Properties for DTD Nodes
  • Properties for XML Schema Nodes
  • Query Output
  • Redefine Schema Symbols
  • Referenced Schemas
  • Register and Activate Stylus Studio
  • Rename Column
  • Scenario Properties Bindings Tab (Web Services)
  • Scenario Properties Connection Settings Tab
  • Scenario Properties General Tab (Web Services)
  • 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)
  • Select Source/Target Folder
  • Select XML Converter
  • Set Node and Pattern
  • Servlet Properties
  • Shortcut Keys
  • Source Code Control Properties
  • Stylus Studio
  • Text Catalog to XML Catalog
  • Type Derivation
  • UDDI Registry Browser
  • User-Defined Catalog Wizard
  • Value
  • Variables
  • Watch
  • Web Service Call Composer
  • XML Diff Editor - Merged View
  • XML Diff Editor - Split View
  • XML Editor Grid Tab
  • XML Editor Schema Tab
  • XML Editor Text Tab
  • XML Editor Tree Tab
  • XML Schema Editor Diagram Tab
  • XML Schema Editor Documentation Tab
  • XML Schema Editor Tree Tab
  • XPath for xsl: Elements
  • XQuery Editor
  • XQuery Editor - XQuery Source Tab
  • XQuery Editor - Mapper Tab
  • XSD from DTD (Trang)
  • xsl:choose
  • XSLT Editor - Mapper Tab
  • XSLT Editor - Params/Other Tab
  • XSLT Editor - WYSIWYG Tab
  • XSLT Editor - XSLT Source Tab
  • XSLT and XQuery Preview Window

Home > Online Product Documentation > Table of Contents > DB-to XML-Data Source Editor

DB-to XML-Data Source Editor

You use the DB to XML Data Source editor to

Connection Settings

You use the Connection Settings fields to identify the server, database, and username and password required to connect to the database you want to query.

Database Type

Drop-down list containing the databases supported by Stylus Studio. In addition, you can select DataDirect SequeLink, which allows you to connect to any ODBC-compliant database using the SequeLink product.

Server URL

The network location, server name and port number, and other information required to establish a connection with a specific database on a specific server. The parameters and syntax for this string will vary from database type to database type.

Username

The username required to log into the database.

Password

The password associated with the username you are using to log into the database.

Connect

You use the Connect button to connect to the database using the connection settings you have defined.

SELECT Tab

You use the SELECT tab to compose the SQL/XML SELECT statement you want to use to query the relational database. You can compose the SELECT statement manually, by typing directly in the editor, and you can drag and drop tables and columns from the database tree onto the editor.

UPDATE Tab

You use the UPDATE tab to compose the SQL/XML UPDATE, INSERT, and/or SELECT statement you want to use to write XML back to the relational database. You can compose the statement manually, by typing directly in the editor, and you can drag and drop tables and columns from the database tree onto the editor.

UPDATE and INSERT actions are always performed against the same database from which the SQL/XML query extracted the data.

Database Schema Tree

You use the database schema tree to review the tables in the database to which you have connected. You can expand and collapse leaves on the tree, and drag and drop tables and columns onto the SQL/XML editor SELECT and UPDATE tabs.

Stylus Studio displays the database tree by default once you connect to a database server. You can toggle the display by clicking the Show/Hide Database Schema button ( ) in the editor's toolbar.

For More Information

Composing SQL/XML in Stylus Studio