CartHome > Learn XML > XML Video Demos > Box Office > Learn SQL/XML > Accessing Databases as XML: Part II
Using Stylus Studio's Database-to-XML Editor to Query and Update Relational Databases using SQL/XML
In addition to accessing relational databases through the file explorer (as demonstrated in the last video in this series), you can also use Stylus Studio's DB-to-XML data-source editor to query relational databases and render the results as XML. The ability to retrieve relational database data and render it as XML is a powerful feature used to tap into your enterprise data resources. Watch and learn how easy it is to define relational-to-XML mappings for getting XML out of relational data and updating relational databases from XML using industry-standard SQL/XML extensions and Stylus Studio's DB-to-XML data-source editor.
The Camtasia Studio video content presented here requires JavaScript to be enabled and the latest version of the Macromedia Flash Player. If you are you using a browser with JavaScript disabled please enable it now. Otherwise, please update your version of the free Flash Player by downloading here.
Catch the entire Relational Database to XML Mapping series!
Using Stylus Studio's Database-to-XML Editor to Query and Update Relational Databases using SQL/XML covers the following topics:
- Creating a relational data source using the DB-to-XML Editor to connect to SQL Server, Oracle, IBM DB2, Sybase, Informix and other ODBC compliant databases.
- Specifying database connection properties including the server URL, username and password.
- Connecting to a relational database and browsing database objects including databases, tables, views and metadata.
- Understanding the
SELECTtab for using SQL/XML to query relational databases. - Understanding the
UPDATEtab to push XML data back into a relational database. - Querying a relational database as XML using Stylus Studio's drag and drop user-interface that can automatically generate SQL/XML code.
- Using the
XMLELEMENTfunction to define relational-to-XML mappings according to the SQL/XML standard. - Executing a SQL/XML query and previewing the results in Stylus Studio's XML text view and XML grid view.
- Creating the SQL/XML statement needed to insert new rows into a database table.
- Using the relational database connection as a target data source in the XSLT mapper.
Learn Convert to XML
Convert to XML lets you convert .txt, binary, and EDI files to XML documents. Convert to XML works on a single document, or to build reusable converters that let you open flat files as XML documents. Free online demonstration!
XSD Documentation Generator
Stylus Studio®'s XSD Editor includes an integrated XSD documentation generator, allowing you to easily publish XML content models defined in XSD in a convenient, HTML format.
Banks That Bank on Stylus Studio for Enhanced XML Productivity
Guess what! You can pass go and collect 200 dollars because with Stylus Studio 2006 you can save your banking company time and labor in every day work activities. Come see which banking companies are already taking advantage of Stylus Studio today!
Stylus Studio Lends a Helping Hand to the New Orleans Reconstruction Efforts
Read how Stylus Studio is helping with the on-going hurricane Katrina reconstruction efforts in New Orleans.
