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. |
XML PRODUCTIVITY THROUGH INNOVATION ™
