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.

The URL Builder, which lets you create an XML document based on a table or view you select from a relational database


		Watch it! You can view a video demonstration of this feature by clicking the television icon or by clicking this link: watch the Using the URL Builder 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

Using the URL Builder

< Previous | Next >

Using OASIS XML Catalogs in Stylus Studio

Learn about Stylus Studio's XML catalog support and how to work with XML catalogs in your Stylus Studio XML projects.

XML-DEV Discussion Forum

XML-DEV is a leading technical forum for XML discussion and a valuable free XML learning resource. Subscribe to the XML-DEV email discussion forum today to help further your XML education.

Visual Data Integration Using Stylus Studio XML Pipeline

XML Pipeline is a visual data integration tool for designing, editing, debugging and deploying XML applications. This tutorial covers building a data integration application that aggregates CSV and EDI data and publishes a report to HTML and PDF.

Chapter 12 Accessing Relational Data as XML

Using OASIS XML Catalogs in Stylus Studio

XML-DEV Discussion Forum

Manufacturing

Visual Data Integration Using Stylus Studio XML Pipeline

Stylus Most Wanted