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.

DB-to-XML data sources allow you to write your own SQL/XML and update the relational database.

This section covers the following topics:

XSD Editor

XSD Editor provides a synchronized split-pane interface that simultaneously shows both a visual XSD Diagram and the underlying code, with changes in one pane immediately reflected in the other

XSD Documentation Generator

Stylus Studio®'s XSD Editor includes an integrated XSD documentation generator, allowing you to easily publish XML content models defined in XSD in a convenient, HTML format.

Investments and Financial Companies That Use Stylus Studio

Stylus Studio provides XML tools & components to leading investment and financial companies! See which top investment and financial companies are banking on Stylus Studio 2006 to simplify their dollars and cents.

Introduction to Convert to XML

Convert to XML is Stylus Studio's all-purpose utility for getting legacy data integration of all sorts into a custom XML format. This video provides an overview of the tool and walks you through a sample CSV to XML data transformation project.

Stylus Most Wanted

 
Free Stylus Studio XML Training:
W3C Member