Enterprise Integration Solutions

88 Part II Message Endpoints

With this simple class, you can pass in the URL and return a string contain-

ing the XML from the database in one smooth operation. The database does not

even have to reside on your own domain!

This is a great way to retrieve Web content across domains and allows you

to expose a database endpoint via HTTP. This technique is also excellent for

cross-platform access.

Summary

This section demonstrated how to set up a SQL Server virtual directory, query it

using a URL and a template, and use XPath to query that same virtual directory.

You also learned how to create a class to retrieve data by using only a URL. This

can be an effective way of exposing a SQL Server database as an endpoint.

SQL Endpoints in Microsoft BizTalk Ser ...