Oracle Support

Altova XMLSpy® 2011 provides important XML support for data modeling, editing, and server administration for Oracle XML DB and is a must-have tool for Oracle database administrators and developers.

Oracle 9i and 10g XML DB Support

Oracle XML DB is a new feature of Oracle Database 9i and 10g that provides high-performance, native XML storage and retrieval technology available with Oracle 9i and 10g. Oracle XML DB provides full support for XML Schema and implements a WebDAV repository interface, which makes Oracle 9i and Oracle 10g ideally suited for use in conjunction with Authentic® 2011 for building document frameworks (Web-based XML content applications).

Since Oracle 9i and 10g and XMLSpy® 2011 all implement WebDAV, XML files stored inside Oracle 9i/10g can be browsed through the XMLSpy® 2011 WebDAV explorer window shown in the following screenshot:

Browse Oracle XML DB

In addition, XMLSpy® 2011 provides an Execute Query dialog box that allows DBAs to query Oracle XML DB using either Oracle's DBURI or an XPath expression, as shown in the following screenshot:

Search Oracle XML DB

XMLSpy® 2011 provides an easy interface for listing all XML Schemas stored in Oracle 9i/10g XML DB. The XML Schemas can be viewed/edited in XMLSpy® 2011's Schema Design View, as shown below:

List Schemas in Oracle XML DB

Finally, any XML Schema developed using the XMLSpy® 2011 XML Schema Editor can easily be saved and registered with Oracle 9i/10g XML DB, as shown here:

Add Schema to Oracle XML DB

Oracle 9i and 10g Data Access

XMLSpy® 2011 includes full support for Oracle 9i and 10g data access in its extensive Database Import/Export interface.

Oracle 9i/10g Database Import

This includes importing and exporting data between XML documents and relational tables, as well as the conversion of a relational database schema into an XML Schema.

Download a free 30-day trial of XMLSpy.

Oracle Corporation recently published a technical whitepaper on the subject of Oracle XML DB, which promenently mentions XMLSpy. In additon, the Seybold Consulting group has published a business whitepaper entitled "Uniting XML Content and Data", which also mentions XMLSpy® 2011.

XMLSpy was pre-viewed at a keynote speech at the Oracle Open World Conference in San Francisco by Chuck Rozwat, Executive Vice President of Oracle Server Technologies, and Sandeepan Banerjee, Director of Product Management, Content Management & Application Development, Oracle Server Technologies. The keynote speech talked about Oracle XML DB, highlighting XMLSpy authoring support for Oracle XML Schema Extensions, and stressed the overall importance of XML technologies.

Altova already includes support for the Oracle XML DB Extensions to XML Schema in the XMLSpy® 2011 graphical XML Schema editor.