Altova Releases Advanced XML and Data Management Capabilities for IBM DB2 9 pureXML

Altova Releases Advanced XML and Data Management Capabilities for IBM DB2 9 pureXML

Altova announced the availability of Version 2007 Release 3 (v2007r3) of its software product line, now providing integration with the IBM DB2 9 data server and its pureXML technology. Altova v2007r3 offers exclusive new functionality within its XMLSpy, MapForce, StyleVision, and DatabaseSpy products, giving users capabilities for editing, exchanging, transforming, and querying XML data stored in IBM DB2 9 databases.


XMLSpy 2007: Support for IBM DB2 9

Altova XMLSpy is an XML editor and XML development environment for modeling, editing, transforming, and debugging XML-related technologies. In v2007r3, XMLSpy provides IBM users specialized database functionality designed to enhance productivity when working with DB2 9. New database capabilities in XMLSpy include:

  • Database XQuery execution. In addition to editing, debugging, and profiling XQuery statements, XMLSpy now can execute such XQuery statements against IBM DB2 9 databases. This allows users to query XML content in DB2 9 accurately, efficiently, and on a granular level. v2007r3 also provides support for IBM s extensions to XQuery.
  • Database query window. This new window lets users view the structure of databases and query them from within XMLSpy using SQL, SQL/XML, and XQuery statements. XML data can be edited in XMLSpy s text or grid view with full validation, then saved back to the DB2 9 data server. Database connectivity is provided through a versatile new quick-connect wizard.
  • XML Schema registration. XMLSpy 2007r3 provides user-friendly tools for registering XML Schemas in IBM DB2 9. Schema registration enables validation of XML data directly within the database. v2007r3 also provides support for reviewing and dropping schemas.


Learn more about the integration of Altova XMLSpy with IBM DB2 9 at


MapForce 2007: Support for IBM DB2 9

Altova MapForce is a data integration and Web services implementation tool that maps between any combination of XML, database, flat file, EDI, and/or Web service, then converts data on-the-fly or auto-generates program code for royalty-free use in custom data integration or Web services applications. New database integration features in MapForce include:

  • Integration of database XML fields. With MapForce 2007r3, users can map XML data directly to and from DB2 9 databases by assigning an XML Schema to the data. MapForce then renders the schema as a sub tree of the database field for direct mapping with disparate data formats via its visual drag-and-drop interface.
  • Enhanced database connectivity. Once only available in Altova DatabaseSpy, MapForce now includes a quick-connect wizard to access, preview, and integrate database data. A new database query window is also included, enabling users to directly analyze SQL data.
  • Extended data filtering functionality. Adding to its extensive library of data-processing functions, MapForce now supports the SQL WHERE filter, which allows for precise filtering of database sources used in data mapping projects.


Learn more about the integration of Altova MapForce with IBM DB2 9 at


StyleVision 2007: Support for IBM DB2 9

Altova StyleVision is a visual stylesheet designer for transforming XML and database content into HTML pages, Word/RTF documents, PDF reports, and Altova Authentic electronic forms. It is optimized for single-source publishing and allows multiple output styles from a single stylesheet design. New database enhancements in StyleVision include:

  • Rendering of database XML fields. StyleVision 2007r3 works directly with XML data stored inside DB2 9 databases. Users simply associate database XML fields with XML Schemas upon which their stylesheets will be based, then drag defined data elements to the design pane for rendering and publishing.
  • Command-line interface extensions. StyleVision now supports user-defined WHERE conditions via the command line, enabling users to produce multiple output documents in HTML, Word/RTF, and PDF formats from XML columns in DB2 9 database tables.


Learn more about the integration of Altova StyleVision with IBM DB2 9 at


DatabaseSpy 2007: Support for IBM DB2 9

Altova DatabaseSpy is a multi-database query and design tool. It connects to all major databases and eases SQL editing and database structure design. v2007r3 provides users of DB2 9 with added features and support for XML database content. New data management capabilities in DatabaseSpy include:

  • Database browser XML support. XML Schemas registered in databases are now displayed in DatabaseSpy s online browser database tree in hierarchical form. Table columns that contain XML data are also shown in the database tree, and the online browser indicates any XML Schemas used to validate them. Additionally, XML Schemas shown in DatabaseSpy can now be sent directly to XMLSpy for editing in its schema design view.
  • Design editor XML enhancements. New columns containing XML data can be added to database tables via the database design editor in DatabaseSpy 2007r3. Access to detailed properties of XML datatypes is also provided.


Learn more about the integration of Altova DatabaseSpy with IBM DB2 9 at

 More information about all the new features in the Altova product line is available at 30-day free trials of all Altova products may be downloaded from Information on IBM DB2 9 and all IBM Information Management solutions is available at



Price: Version 2007 Release 3 of Altova XMLSpy 2007, MapForce 2007, StyleVision 2007, and DatabaseSpy 2007 pricing starts at US$499, US$249, US$249, and US$129 respectively. These products may be purchased directly from the Altova Online Shop. The Altova MissionKit 2007 bundles up to eight Altova products for less than the price of two. All MissionKits include XMLSpy, MapForce, and StyleVision at substantial savings, plus options are available that add up to five additional application development and data management tools (including DatabaseSpy) effectively free of charge. The Altova MissionKit is currently available with pricing starting at US$740. Altova recommends the purchase of its Support and Maintenance Package (SMP) with all software purchases. Altova SMP provides free software version upgrades, maintenance releases, and priority technical support for the duration of the support period. SMP can be purchased for 25% of the product license price for a one-year period, or 20% per year for a two-year period.

Web Site:

Hide comments


  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.