Chapter 12 Accessing Relational Data as XML


		The features for working with relational data as XML described in this chapter are available only in Stylus Studio XML Enterprise Edition and Stylus Studio XML Professional Edition.

This chapter describes the different ways you can access relational data and render that data as XML in Stylus Studio:

DB-to-XML data sources, which you can use to query and, optionally, to modify data in a relational database from within Stylus Studio


		Watch it! You can view a video demonstration of this feature by clicking the television icon or by clicking this link: watch the Creating DB-to-XML Data Sources video.

A complete list of the videos demonstrating Stylus Studio's features is here: http://www.stylusstudio.com/xml_videos.html.

This chapter covers the following topics:

Overview of DB-to-XML Data Sources

Creating a DB-to-XML Data Source

Specifying Connection Settings

Using an ODBC Data Source in Stylus Studio

Working with Scenarios

Composing SQL/XML in Stylus Studio

Working with Relational Data as XML

< Previous | Next >

Learn XQuery Visually

Stylus Studio offers three infomative XQuery demonstration videos illustrating Stylus Studio's XQuery Editor, Mapper, Debugger and other advanced functionality. Watch them today!

Stylesheet Design - How to Publish your Data Using a Stylesheet Designer

Simplify Stylesheet Design with Stylus Studio's XML Publisher, a visual stylesheet designer and code generator to help you create XSLT or XQuery to publish your data to HTML+CSS or XSL:FO.

To transform EDI to XML, whether for X12 or EDIFACT, Stylus Studio provides the design tools and run-time support. EDIFACT, X12 and custom EDI formats can be translated, validated and mapped using the EDI Mapping adapter technology described here.

Learn XQuery in 10 Minutes, by Dr. Michael Kay - An XQuery Tutorial

Learn XQuery in 10 Minutes By Dr. Michael Kay is for all those people who really want to know what XQuery is, but don't have the time to find out. It's the fastest XQuery tutorial on the planet - read it now!

Chapter 12 Accessing Relational Data as XML

Learn XQuery Visually

Stylesheet Design - How to Publish your Data Using a Stylesheet Designer

EDI Mapping

Learn XQuery in 10 Minutes, by Dr. Michael Kay - An XQuery Tutorial

Stylus Most Wanted