<%@ page language="C#" masterpagefile="~/templates/Documentation.master"  
			inherits="Page" 
			pagetitle="Chapter 12	Accessing Relational Data as XML"
			keywords="Chapter 12	Accessing Relational Data as XML"%>
<asp:content id="DocToc" contentplaceholderid="DocToc" runat="Server" xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:asp="http://www.w3.org/1999/XSL/Transform">
  <li class="NavMenuListItem">
    <div>
      <a href="d_start2.html">Chapter 1: Getting Started with Stylus Studio®</a>
    </div>
  </li>
  <li class="NavMenuListItem">
    <div>
      <a href="d_edit.html">Chapter 2: Editing and Querying XML</a>
    </div>
  </li>
  <li class="NavMenuListItem">
    <div>
      <a href="d_flatfileconversion.html">Chapter 3: Converting Non-XML Files to XML</a>
    </div>
  </li>
  <li class="NavMenuListItem">
    <div>
      <a href="d_xslt.html">Chapter 4: Working with XSLT</a>
    </div>
  </li>
  <li class="NavMenuListItem">
    <div>
      <a href="d_xslt_xmlxml.html">Chapter 5: Creating XSLT Using the XSLT Mapper</a>
    </div>
  </li>
  <li class="NavMenuListItem">
    <div>
      <a href="d_java.html">Chapter 6: Debugging Stylesheets</a>
    </div>
  </li>
  <li class="NavMenuListItem">
    <div>
      <a href="d_schema.html">Chapter 7: Defining XML Schemas</a>
    </div>
  </li>
  <li class="NavMenuListItem">
    <div>
      <a href="d_dtd.html">Chapter 8: Defining Document Type Definitions</a>
    </div>
  </li>
  <li class="NavMenuListItem">
    <div>
      <a href="d_xpath.html">Chapter 9: Writing XPath Expressions</a>
    </div>
  </li>
  <li class="NavMenuListItem">
    <div>
      <a href="d_xquery.html">Chapter 10: Working with XQuery in Stylus Studio</a>
    </div>
  </li>
  <li class="NavMenuListItem">
    <div>
      <a href="d_webservices.html">Chapter 11: Composing Web Service Calls</a>
    </div>
  </li>
  <li class="NavMenuListItemActive">
    <div>
      <a href="d_rdb.html">Chapter 12: Accessing Relational Data as XML</a>
    </div>
    <ul>
      <li>
        <a href="d_rdb2.html#wp269369">Overview of DB-to-XML Data Sources</a>
      </li>
      <li>
        <a href="d_rdb7.html#wp368277">Creating a DB-to-XML Data Source</a>
      </li>
      <li>
        <a href="d_rdb12.html#wp380892">Specifying Connection Settings</a>
      </li>
      <li>
        <a href="d_rdb18.html#wp461275">Using an ODBC Data Source in Stylus Studio</a>
      </li>
      <li>
        <a href="d_rdb23.html#wp447997">Working with Scenarios</a>
      </li>
      <li>
        <a href="d_rdb30.html#wp363169">Composing SQL/XML in Stylus Studio</a>
      </li>
      <li>
        <a href="d_rdb34.html#wp371273">Working with Relational Data as XML</a>
      </li>
    </ul>
  </li>
  <li class="NavMenuListItem">
    <div>
      <a href="d_pipeline.html">Chapter 13: Building XML Pipelines</a>
    </div>
  </li>
  <li class="NavMenuListItem">
    <div>
      <a href="d_publisher.html">Chapter 14: Publishing XML Data</a>
    </div>
  </li>
  <li class="NavMenuListItem">
    <div>
      <a href="d_3rd_party_file_systems.html">Chapter 15: Integrating with Third-Party File Systems</a>
    </div>
  </li>
  <li class="NavMenuListItem">
    <div>
      <a href="d_adv.html">Chapter 16: Extending Stylus Studio</a>
    </div>
  </li>
  <li class="NavMenuListItem">
    <div>
      <a href="d_deploy_comps.html">Chapter 17: The Stylus Studio Java API</a>
    </div>
  </li>
  <li class="NavMenuListItem">
    <div>
      <a href="d_help.html">Chapter 18: Stylus Studio GUI Reference</a>
    </div>
  </li>
</asp:content>
<asp:content id="DocPage" contentplaceholderid="DocPage" runat="Server">
  <a name="wp331853"/>
  <p class="BreadCrumbs">
    <span>
      <a href="/" title="Stylus Studio Home">Home</a>&#160;&gt;
    </span>
    <span>
      <a href="/docs/" title="Online Product Documentation">Online Product Documentation</a>&#160;&gt;
    </span>
    <span>
      <a href="." title="Table of Contents">Table of Contents</a>&#160;&gt;
    </span>
    <span class="BreadCrumbsThisPage">Chapter 12	Accessing Relational Data as XML</span>
  </p>
  <div style="float:right;margin-bottom:1em;" class="navHelp">
    <a class="navHelp" href="d_webservices27.html">&lt;
			Previous
    </a>|
		
    <a class="navHelp" href="d_rdb2.html">Next
			&gt;
    </a>
  </div>
  <a shape="rect" name="wp331853"> </a>
  <h1 class="pTitle">
Chapter 12	Accessing Relational Data as XML

  </h1>
  <hr/>
  <a shape="rect" name="wp411485"> </a>
  <p class="pAnchor">
	
  </p>
  <div align="left">

    <table border="1">

  
      <tr bgcolor="#E8E8E8" align="left">    
        <td rowspan="1" colspan="1">
          <a shape="rect" name="wp411477"> </a>
          <div style="color: #cc0000; font-family: Arial, Verdana, Helvetica, sans-serif; font-size: 12px; font-style: normal; font-variant: normal; font-weight: bold; margin-bottom: 0pt; margin-left: 0pt; margin-right: 0pt; margin-top: 3pt; text-align: right; text-decoration: none; text-indent: 0pt; text-transform: none">

            <img src="images/pro_only_logo.gif" height="32" width="30" border="0" hspace="0" vspace="0"/>


          </div>

        </td>
    
        <td rowspan="1" colspan="1">
          <a shape="rect" name="wp411479"> </a>
          <p class="pBody">
&#160;

          </p>

        </td>
    
        <td rowspan="1" colspan="1">
          <a shape="rect" name="wp411483"> </a>
          <p class="pBody">
The features for working with relational data as XML described in this chapter are available only in Stylus Studio XML Enterprise Suite and Stylus Studio XML Professional Suite.

          </p>

        </td>

      </tr>
  
      <caption align="bottom"/>

    </table>

  </div>
  <p class="pAnchor">


  </p>
  <a shape="rect" name="wp367818"> </a>
  <p class="pBody">
This chapter describes the different ways you can access relational data and render that data as XML in Stylus Studio:

  </p>
  <div class="pSmartList1">
    <ul class="pSmartList1">

      <a shape="rect" name="wp408551"> </a>
      <div class="pSmartList1">
        <li>DB-to-XML data sources, which you can use to query and, optionally, to modify data in a relational database from within Stylus Studio</li>
      </div>

    </ul>
  </div>
  <a shape="rect" name="wp470699"> </a>
  <p class="pAnchor">
	
  </p>
  <div align="left">

    <table border="1">

  
      <tr bgcolor="#E8E8E8" align="left">    
        <td rowspan="1" colspan="1">
          <a shape="rect" name="wp470693"> </a>
          <div style="color: #cc0000; font-family: Arial, Verdana, Helvetica, sans-serif; font-size: 12px; font-style: normal; font-variant: normal; font-weight: bold; margin-bottom: 0pt; margin-left: 0pt; margin-right: 0pt; margin-top: 3pt; text-align: right; text-decoration: none; text-indent: 0pt; text-transform: none">

            <img src="images/tvset34.gif" height="49" width="47" usemap="#tvset34_gif" border="0" hspace="0" vspace="0"/>


            <map name="tvset34_gif">

              <area href="http://www.stylusstudio.com/videos/dbtoxml1/dbtoxml1.html" shape="rect" coords="0,1,44,47"/>

            </map>


          </div>

        </td>
    
        <td rowspan="1" colspan="1">
          <a shape="rect" name="wp470695"> </a>
          <p class="pBody">
&#160;

          </p>

        </td>
    
        <td rowspan="1" colspan="1">
          <a shape="rect" name="wp470697"> </a>
          <p class="pBody">
Watch it! You can view a video demonstration of this feature by clicking the television icon or by clicking this link: 
            <a shape="rect" href="http://www.stylusstudio.com/videos/dbtoxml1/dbtoxml1.html">watch the Creating DB-to-XML Data Sources video</a>.

          </p>

        </td>

      </tr>
  
      <caption align="bottom"/>

    </table>

  </div>
  <p class="pAnchor">


  </p>
  <a shape="rect" name="wp342258"> </a>
  <p class="pBody">
A complete list of the videos demonstrating Stylus Studio's features is here: 
    <a shape="rect" href="http://www.stylusstudio.com/xml_videos.html">http://www.stylusstudio.com/xml_videos.html</a>.

  </p>
  <a shape="rect" name="wp470951"> </a>
  <p class="pBody">
This chapter covers the following topics:

  </p>
  <div class="pSmartList1">
    <ul class="pSmartList1">

      <a shape="rect" name="wp196278"> </a>
      <div class="pSmartList1">
        <li>
          <a shape="rect" href="d_rdb2.html#wp269369">Overview of DB-to-XML Data Sources</a>
        </li>
      </div>

      <a shape="rect" name="wp447293"> </a>
      <div class="pSmartList1">
        <li>
          <a shape="rect" href="d_rdb7.html#wp368277">Creating a DB-to-XML Data Source</a>
        </li>
      </div>

      <a shape="rect" name="wp380733"> </a>
      <div class="pSmartList1">
        <li>
          <a shape="rect" href="d_rdb12.html#wp380892">Specifying Connection Settings</a>
        </li>
      </div>

      <a shape="rect" name="wp461396"> </a>
      <div class="pSmartList1">
        <li>
          <a shape="rect" href="d_rdb18.html#wp461275">Using an ODBC Data Source in Stylus Studio</a>
        </li>
      </div>

      <a shape="rect" name="wp343424"> </a>
      <div class="pSmartList1">
        <li>
          <a shape="rect" href="d_rdb23.html#wp447997">Working with Scenarios</a>
        </li>
      </div>

      <a shape="rect" name="wp365828"> </a>
      <div class="pSmartList1">
        <li>
          <a shape="rect" href="d_rdb30.html#wp363169">Composing SQL/XML in Stylus Studio</a>
        </li>
      </div>

      <a shape="rect" name="wp374654"> </a>
      <div class="pSmartList1">
        <li>
          <a shape="rect" href="d_rdb34.html#wp371273">Working with Relational Data as XML</a>
        </li>
      </div>

    </ul>
  </div>
  <div style="float:right;margin-top:1em;" class="navHelp">
    <a class="navHelp" href="d_webservices27.html">&lt;
			Previous
    </a>|
		
    <a class="navHelp" href="d_rdb2.html">Next
			&gt;
    </a>
  </div>
</asp:content>