Cart|
|
Home > Online Product Documentation > Table of Contents > Creating a DB-to-XML Data Source Creating a DB-to-XML Data SourceThe process of creating a DB-to-XML data source in Stylus Studio involves the following steps:
1. Open a new DB-to-XML data source document in Stylus Studio. See
Opening a New DB-to-XML Data Source Document.
Stylus Studio displays the Scenario Properties dialog box.
2. Specify a scenario name (or accept the default) and the information needed to connect to the database server and log in to the database. This information includes
3. Save the scenario. Stylus Studio automatically connects to the database and logs you into the server. The database schema, table, view, and column information for the database you specified in the scenario appears in the DB-to-XML editor.
4. Compose the SQL/XML SELECT statement to query the database. (UPDATE and INSERT statements, which write modified data back to the database, are optional.) See
Composing SQL/XML in Stylus Studio.
5. Execute the query and review the XML it returns.
6. Optionally (if you have written SQL/XML to write new or modified data to the database), save the XML document returned by the SQL/XML query to write data back to the database. See
Working with Relational Data as XML.
The remainder of this chapter describes these steps in greater detail. |
Transforming Non-XML Documents with XML Tools
This pages has audio from the Stylus Studio Presentation at Exchange 2005.
XPath Generator
Stylus Studio includes an XPath generator that helps you easily create XPath expressions. This page illustrates how you can accomplish this.
XSLT Editor
Stylus Studio's XSLT Editor is the most advanced XSLT development tool on the market. This powerful tool provides backmapping, XSLT transformation preview, debugging, peformance profiling, and more!
Web Service Data-to-XML Mapper
Stylus Studio provides a powerful standards-based solution for accessing and transforming live Web service XML data. Intuitive tools like the Web Service Call Composer and UDDI Browser make developing Web service applications a snap.
