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.

Validating X12 Documents with XML Schemas

Either before or after transforming X12 EDI content, generated XML Schemas will make sure that we have all of the necessary components, our codes are all according to the standard codelists, and every little delimiter is in the right place.

XSD Editor

XSD Editor provides a synchronized split-pane interface that simultaneously shows both a visual XSD Diagram and the underlying code, with changes in one pane immediately reflected in the other

Support for the Saxon XQuery Processor

Stylus Studio's XQuery tools feature integrated support for the Saxon SA 8.7.3 XQuery and XSLT processor so you can Edit, Debug and Run XQuery using Saxon. Java code generation support lets you deploy Saxon XQuery applications with just one click.

XSLT Mapper

Simplify XSLT mapping with the Stylus Studio XSLT Mapper - supports multiple data sources, round-trip engineering (synchronized editing views), XSLT function blocks, integrated XSLT preview and more.

Stylus Most Wanted

Site Map | Privacy Policy | Terms of Use | Trademarks
Free Stylus Studio XML Training:
W3C Member
Stylus Studio® and DataDirect XQuery™are products from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2007 All Rights Reserved.