SOA for Database Professionals with Lucas Jellema April 2, 2009

This seminar explains in a high level overview what the key SOA concepts are. It introduces WebServices and the key XML mechanisms, such as XSD, SOAP, WSDL and a touch of XPath and XSLT. It describes the respective roles of BPEL PM and the Enterprise Service Bus. It will then demonstrate how from PL/SQL programs - and even from SQL queries - SOA Services offered in BPEL or ESB can (and sometime meaningfully should) be leveraged, for example to perform operations across databases or even heterogeneous data stores.

We walk through a case of defining and publishing a service in a hospital that makes patient data available from the database to the SOA environment. All steps from defining the Service to actually publishing it and calling it from a BPEL process are discussed and demonstrated.