Bridges | Getting Started with BizTalk Services

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 the database:

CREATE TABLE [dbo].[CountryMap](
  [CountryName] [nvarchar](100),
  [ISOCountry] [int] NULL
  CONSTRAINT [PK_CountryName] PRIMARY KEY CLUSTERED
  (
    [CountryName] ASC
  ) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY...

Tech Concepts

Programming languages

Tech Tools

Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.

Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.

50+ new titles added per month and exclusive early access to books as they are being written.

Getting Started with BizTalk Services

Getting Started with BizTalk Services

Overview of this book

Lookups

Confirmation

Buy this book with your credits?

Submit Your Feedback

Create a Free Account To Continue Reading

Sign in to activate your 7-day free access