XML parsers

You can analyze XML documents and extract their data using SQL character-string operations, such as substring, charindex, and patindex. However, it is more efficient to use Java in SQL, and to use tools written in Java, such as XML parsers.

XML parsers can:

Many XML parsers are available with a free license or are in the public domain. They normally implement two standard interfaces: the Simple API for XML (SAX) and the Document Object Model (DOM).

Applications that use the SAX and DOM interfaces are portable across XML parsers.