Accessing Relational Databases as XML with Stylus Studio's File Explorer

Stylus Studio's File Explorer provides an easy and intuitive way to extract data from any relational database. This video demonstration covers how to create and re-use database connections that enable you to directly access relational data in real time for use in your XQuery and XSLT applications.

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

Accessing Relational Databases as XML with Stylus Studio's File Explorer covers the following topics:

  • Creating a connection to a relational database — for example, Oracle, Microsoft SQL Server, IBM DB2, Informix and Sybase
  • Creating the database connection string including server name, user name and password
  • Browsing database tables, views, schemas and other database objects from within the Stylus Studio file explorer
  • Writing an XQuery expression that accesses a relational data source
  • Understanding and using the XQuery collection function
  • Specifying which XQuery processor to use, for example, DataDirect XQuery or the built-in Stylus Studio XQuery processor.
  • Executing an XQuery application that accesses a relational database and previewing the resulting XML output in Stylus Studio.
 
Free Stylus Studio XML Training: