Cart|
Home > Online Product Documentation > Table of Contents > How to Create a DB-to-XML Data Source How to Create a DB-to-XML Data SourceTo create a DB-to-XML data source:
1. Select
File > New > DB to XML Data Source from the menu.
Stylus Studio displays the Scenario Properties dialog box.
2. Specify a scenario name (or accept the default).
3. Specify the information needed to connect to the database server and log in to the database. This information includes
See Specifying Connection Settings if you need help with this step. If you selected DataDirect SequeLink for the database type, see Using DataDirect SequeLink as a DB-to-XML Data Source. Alternative: If you have already defined a default connection setting and you want to use it for this scenario, click the Use Default Connection field.
4. Click
OK to 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 schema pane of the DB-to-XML Data Source Editor.
5. 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.
6. Click the
Execute Query button (
) the query and review the XML it returns.
7. 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. |
DTD Generator
Stylus Studio's DTD Generator supports the automatic generation and association of both internal and external DTDs based on XML instance documents.
Saxon XSLT Processor
Stylus Studio® has partnered with Saxonica, a leading provider of Java-based XSLT and XQuery processing components to offer a robust XSLT 1.0 and 2.0 development environment, featuring development and deployment using the Saxon XSLT processor.
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.
WSDL Editor
WSDL Editor featuring a graphical WSDL viewer, syntax help, Java Web Service code generation and more. Simplify Web Services development with Stylus Studio's Web Service Description Language (WSDL) Editor today!
