Create XML Views of Relational Data Using DataDirect XQuery™

Previous versions of Stylus Studio® included support for DataDirect Connect for SQL/XML, a Java component for processing SQL/XML queries that could be used for creating XML documents from relational database data. This functionality has been deprecated as of Stylus Studio 2007 Release 2 (May 2007) in favor of DataDirect XQuery™ and DataDirect XML Converters™, which provides a far more powerful and extensible means of connecting to any relational database —including Microsoft Access, Microsoft SQL Server, Oracle, and others— and extracting data directly from Microsoft .NET or Java applications.

Using DataDirect XQuery™ Instead of SQL/XML

DataDirect XQuery™ is a high-performance, scalable, embeddable XQuery implementation that plugs easily into any Java architecture and accesses almost any data source (including Microsoft SQL Server) without being dependent on underlying servers or proprietary extensions to XQuery. If you need to access SQL server tables as XML, the advantages of using XQuery over SQL/XML include:

  • Easily query Microsoft SQL Server tables directly using W3C Standard XQuery
  • A powerful API for query processing and handling of the resulting XML documents
  • Significantly enhanced application scalability and faster performance
  • Greater extensiblity; you can join relational with both XML and non-XML data
  • Support for XQuery Updates — you can get XML back into your relational database

If you're using SQL/XML to manipulate relational data as XML, then you should seriously consider using Stylus Studio® instead— it includes built-in support for DataDirect XQuery™ and DataDirect XML Converters™, along with many other handy data integration tools for working with XML and database technologies — download a free trial today!


Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!

Buy Stylus Studio Now

Try Stylus XML Database Tool

Download a free trial of the leading SQL/XML development tool Today!

Attend a Live Webinar This Week!

Learn about Stylus Studio's unique features and benefits in just under an hour. Register for the Stylus Studio QuickStart Training WebCast!

Ask Someone You Know

Does your company use Stylus Studio? Do your competitors? Engineers from over 100,000 leading companies use Stylus Studio, and now you can ask someone from your own organization about their experiences using Stylus Studio.

Free Stylus Studio XML Training: