DataDirect XQuery is a high-performance Java component that implements both XQuery and the XQuery for Java API, used to query XML and relational data together. It supports most relational databases, runs on any Java platform, and is easily embeddable into almost any Java program. DataDirect XQuery works with any J2EE Application Server, although no application server is required. Stylus Studio further simplifies relational and XML data integration by providing advanced XQuery tools support for building XQuery applications with DataDirect XQuery.
Edit and Design DataDirect XQuery Applications
The Stylus Studio XQuery editor and XQuery mapper provide integrated support for developing XQuery applications which are powered by DataDirect XQuery. The integration is seamless — simply write your code using Stylus Studio's productive XQuery tools as you would normally do. Click on the scenario properties button and select DataDirect XQuery as your default processor, as illustrated below:
Scenario properties are various settings which you specify to describe the configuration of your XQuery. For example, you can specify which processor you'd like to use, as well as other parameters such as validation and profiling options.
Accessing Relational and XML Data
A primary benefit of using the DataDirect XQuery processor over other conventional in-memory processors, and other proprietary XQuery processors
is that you can extend your XQuery applications to access any relational database. Accessing relational and XML data using XQuery and Stylus Studio is easy, using the
Currently, DataDirect XQuery provides seamless access to the following databases:
Visually Map Relational and XML Data
Once you've defined your relational database sources as XQuery collections, you can use them in Stylus Studio's XQuery mapper as though it were just another XML file on the local file System. Data integration is so easy — just load your data sources, your target output format, and draw lines from input to output. The XQuery code needed to implement the various mapping operations is automatically generated for you. Using both DataDirect XQuery and Stylus Studio's XQuery tools together is the easiest way to build applications that need to access both relational and XML data.
Integrated Code Generation
Once you've built and tested your data integration application using Stylus Studio, it's easy to then take the XQuery code and deploy it to your production environment using the integrated Java Code Generator (a runtime DataDirect XQuery license is required for this). To invoke the Java code generator, select "XQuery" -> "Generate Java Code", as illustrated below. Stylus Studio automatically creates all of the files that are needed to invoke your XQuery from within any Java application. Using the integrated Java IDE, you can compile and run the generated Java application with just one mouse click.
Extending DataDirect XQuery to Access Non-Relational Data
Need to integrate relational, XML, and legacy data? No problem. DataDirect XML Converters provide a powerful and standards-based way to further extend DataDirect XQuery, enabling access to any legacy data format including EDI, X12, EDIFACT, binary data, TSV, CSV, DBASE and more! Stylus Studio provides thousands of built-in converters for the most common legacy file formats, and using Convert to XML, it's easy to visually define custom XML converter definitions for any proprietary data format. All of the tools discussed previously in this article (XQuery editing, mapping, code generation, etc.) work with your legacy data sources as though they were just another file on the local file system. In a nutshell, Stylus Studio, DataDirect XML Converters, and DataDirect XQuery provides the tools & components needed to develop and deploy any data integration application.
Why DataDirect XQuery?
DataDirect XQuery is ideal for applications that do XML publishing, XML Report Writing, Data Integration, XML processing for SOAP and Web Services, or Dynamic Web sites. Using DataDirect XQuery significantly simplifies application development by reducing the amount of code developers write and maintain to use XML and relational data together. For more information about Stylus Studio and DataDirect XQuery, watch this informative video demonstration.
PURCHASE STYLUS STUDIO ONLINE TODAY!!
Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!
Get DataDirect XQuery Tools Now
Simplify XML and Relational data integration with DataDirect XQuery and Stylus Studio - Download a free trial today!
What's New for X15?
New XQuery & Web Services Tools, Support for MySQL, PostgreSQL, HL7 EDI, Microsoft .NET Code Generation and much more!
Using Stylus Studio and DataDirect XQuery
A new online video tutorial demonstrates just how easy it is to develop and deploy advanced data integration applications that access Relational, XML and other legacy data using Stylus Studio and DataDirect XQuery.