• 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
  • 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
    • Fields
    • Buttons
    • For More Information
  • 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 > Options - Module Settings - DBtoXML - Default Connection

Options - Module Settings - DBtoXML - Default Connection

You use this page of the Options dialog box to establish default settings you want to use

To display the Options dialog box, select Tools > Options from the Stylus Studio menu bar. Expand Module Settings and Java and click Debugger.

Fields

Connection settings vary from database to database, but they typically include the following:

Database Type

The type of database to which you want to connect. You can connect to one of the default relational databases supported by Stylus Studio (Oracle, MS SQL Server, Informix, and so on), or you can use DataDirect SequeLink to connect to any ODBC database you specify.

Server URL

The server URL (and, in some cases, other connection parameters). In addition to the server's location, connection parameters can include the server name, the port through which the connection is established, and other information, such as a server ID (SID).

Username

Username required to log in to the database.

Password

Password associated with the username.

Buttons

Connect

The button you use to test your connction to the database.

For More Information

Specifying Connection Settings

Overview of DB-to-XML Data Sources

Chapter 12Accessing Relational Data as XML