< Previous | Next >

Overview of DB-to-XML Data Sources

SQL/XML is an extension of the Structured Query Language (SQL) that allows you to query relational data, render query results as XML, and write modified or new data back to a relational database. Stylus Studio supports the SQL/XML standard by allowing you to create a DB-to-XML data source, a file that contains

Connection settings used to connect to a specific relational database on a specific server. You specify connection settings in a scenario. See DB-to-XML Data Source Scenarios for more information.

SQL/XML statements (SELECT and UPDATE, for example) that you want to execute on that database. Query results returned by the DB-to-XML data source you define can be used in Stylus Studio anywhere you use XML.

If you need only to render an entire table or view as XML, use the URL Builder. Any time you need more control - writing your own SQL/XML or updating the relational database, for example - use a DB-to-XML data source. See Using the URL Builder for more information on the URL Builder Utility.

This section covers the following topics:

System Requirements

Supported Databases

DB-to-XML Data Source Scenarios

The DB-to-XML Data Source Editor

< Previous | Next >

Overview of DB-to-XML Data Sources

Stylus Most Wanted