What Is XML SQL Utility (XSU)?
XML has become the format for data interchange. At the same time, a substantial amount of business data resides in object-relational databases. It is therefore necessary to have the ability to transform this relational data to XML. XML SQL Utility (XSU) enables you to do this as follows: XSU can transform data retrieved from object-relational database tables or views into XML. XSU can extract data from an XML document, and using a canonical mapping, insert the data into appropriate columns or attributes of a table or a view. XSU can extract data from an XML document and apply this data to updating or deleting values of the appropriate columns or attributes.
Related Questions
- I would like to use XML SQL Utility to load XML where some of the data is stored in attributes; yet, XML SQL Utility seems to ignore the XML attributes. What can I do?
- Does XML SQL Utility commit after it is done inserting, deleting, or updating? What happens if an error occurs?
- What Is XML SQL Utility (XSU)?
