Tag Archives: XML

To Web Services and Beyond…

The recent smash hit, Web Services, has played from coast to coast on the business “Hypo-Tronic Gizmo” for several years now.  One might even suggest that if DJ-Bob had a weekly Top 10 countdown featuring the most prolific debuts in business-hype history, Web Services would be at or near the top (clouds are also floating fairly high these days).  This Hypo-Tronic Gizmo (or HG device) is extremely unique because it plays only what the listener wishes to hear.  For top-level executives the device delivers a simple, “Cha-Ching”.  For mid-level managers it renders a more subtle, “Here we go again”, reprise.  But, for those in the trenches – the technical implementers and end users – it screams, “Fire in the hole!”  Yet, surprisingly, to those who have lived through the budget-blowing and non-committing trends of the past, Web Services has actually delivered a Certified Platinum hit that many advocates had hoped it would achieve. Continue reading

Creating XML in Oracle

In a previous posting (Creating XML in MSSQL : http://www.extol.com/blog/?p=651) I described the feature in MSSQL which allows for generation of XML data with a specially structured database query.   Other databases offer similar capabilities, so this post is meant to highlight how do accomplish the same task using Oracle.

For the purposes of this post I’ll be referring to Oracle 11g, which improved on the XML handling in 10g, and included features such as a binary XML data type superior XQuery support, and the ability to embed XML within PL/SQL. Continue reading

Creating XML in MSSQL

In my last blog I briefly touched upon storing XML documents in MSSQL.  Now let’s discuss creating them instead.  Specifically I mean creating them using the FOR XML keywords in MSSQL.  While this functionality exists in other database systems such as Oracle and DB2, their implementation is different and warrants a separate blog post.

Most of us are familiar with selecting data using a SQL command and retrieving some sort of result set.  With XML being used so frequently for a wide range of applications, it is not uncommon for a programmer to want to build an XML message out of data stored in a database somewhere.  Instead of using SQL queries and looping over result sets, it is possible in MSSQL to use the FOR XML declaration to actually return that data as pre-formatted XML. Continue reading

Teach Camel to work with your data

Camels can be stubborn and angry animals if you don’t take care of them. Lucky for you the EXTOL development team has figured out how to tame them. And we even taught them how to work with data!

Everywhere we look today we can see patterns. They’re in your shirt or tie. You witness traffic patterns (big or small) on your way to work. There are even patterns of integration – Enterprise Integration Patterns (EIP). These patterns allow you to define standard ways of dealing with messaging systems. Examples of these patterns include content-based routing and wiretapping.  Continue reading

SQL and XML

In my previous blog post I talked about the SQL standard.  It is tempting to visualize a standard as a list of rules nailed to a wall.  However things in this industry have a habit of becoming a moving target.   Continue reading