DB2XML 1.4 |
 |
Transforming relational databases into XML documents
DB2XML is a tool for transforming data from relational databases into
Extensible Markup
Language (XML) documents. It is written in 100% pure Java. DB2XML
provides three main functions:
- Transforming the results of database queries or complete
databases into XML documents or into HTML documents using XSLT stylesheets.
- Providing attributes describing characteristics of the data (i.e. meta data).
- Easy integration of XSLT stylesheet processors
DB2XML can be used:
- as a standalone tool (with GUI or command line),
- as a servlet to dynamically generate XML-documents (see online demo).
- using the DB2XML API
The generated XML is represented as a W3C DOM object or by DB2XML
specific data structure. These objects can also be accessed as streams
or as byte arrays.
DB2XML comes with an easy to use graphical user interface and accesses
databases using JDBC drivers. It requires JDK 1.1.x and a database with
a JDBC driver (or a ODBC driver using the JDBC-ODBC bridge). It has
been tested with several different databases and drivers including
Oracle, Microsoft Access and SQL-Server, InstantDB, DB2 and MySQL.
The license
conditions are stated in the DB2XML license policy.
For a list of JDBC drivers see JavaSoft JDBC
page.
Note: The term DB2XML is not affiliated in any manner with the IBM DB2 Universal
Database product.
Future developments
Release 1.4 is one step towards Version 2 which will give users
much more control over the structure of the XML
documents.
Paper
There is a paper on the design of DB2XML available:
Making legacy data accessible for XML applications
(ps, pdf)
Contents
Last updated: October, 1 2001.
DB2XML Home page
The location of the DB2XML
home page: http://www.informatik.fh-wiesbaden.de/~turau/DB2XML/index.html
New in Version 1.4
- October, 1 2001 Version 1.4
- Bug-Fixes
- Ant Makefile
- Interface for JAXP-conform XML parsers and XSLT processors
- Better documentation (for servlet application)
TO DO
- More flexible translation scheme
- Introduce better naming scheme for properties
- Improve GUI
- Support import of generated XML documents
- Support default values for columns
- Support the generation of beans
- Provide more examples
Contact
Technical questions, comments, and bug reports to
turau@informatik.fh-wiesbaden.de.
Please include information about your environment:
name and version of
database, name and version of driver, operating system and version of DB2XML.
Author
Volker Turau
Authors Home Page