O'Reilly logo

Getting Started with BizTalk Services by Karthik Bharathy, Jon Fancey

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Lookups

Another usage of message properties is with transformation. Here, a common requirement is transcoding, where one value needs to be replaced with or mapped to another value. Code tables can be used for this purpose, and we can use the lookup capabilities of BizTalk Services to do this and then feed the values into a transform to replace the value in the message.

Some preparation is needed to set things up. If you recall, when you provision a new Windows Azure BizTalk Services instance, you can choose to create a new SQL Azure database to hold the various tables needed by the service. We can also create a table in this database to hold the transcoding data for the lookups. To create a table and add data to it, run the following script against ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required