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!

  1. Accessing Relational Databases as XML with Stylus Studio's File Explorer
  2. Using Stylus Studio's Database-to-XML Editor to Query and Update Relational Databases

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 SELECT tab for using SQL/XML to query relational databases.
  • Understanding the UPDATE tab 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 XMLELEMENT function 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.
 
Free Stylus Studio XML Training: