BizTalk Pattern: Translating Reference Data in a Map using Xref

I needed to translate Unit Codes for Purchase Orders going out and Shipping Notices coming in between the codes used by the external partner to the codes used by the client.

After reading BizTalk Pattern: Mapping Reference Data, I decided to give the Xref Reference Data a try

I found another blog Cross Reference Functoids Description and Example in BizTalk Server that went into a bit more detail

And finally the following blog which clarified that I would be best off using the Get Common Value and Get Application Value functoids rather than the Id Cross Referencing as it would allow me to 1) It’s a many-to-one mapping 2) Give better performance as it would be cached.

 

External to Canonical
External to Canonical
Canonical to Internal
Canonical to Internal

Note: There are length limitations to the values you can use for Application, Value and Common Value as they are defined as nvarchar(50), not null in the database.

Related Migrating To Azure – BizTalk Cross Referencing Functoids

Author: Coen (Colin) Dijkgraaf

A Integration Consultant for Datacom in Auckland, New Zealand, working mainly with BizTalk and Azure. You can follow me on Twitter, StackOverflow and WordPress

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Nick's Blog

Biztalk gotcha!

Whatever

FURIOUSLY REASONABLE

A Different Kind of Query

Technology, music, life, and musings

Vierodan IT Space

Spread up technology

BizTalk Server Help book!

Made easy and simple

nethramysooru

Blog on BizTalk Server

https://blog.insyca.com

Unser Blog ist umgezogen:

Blog Of the Serverless Spirit

Stray Notions on All Things Microsoft Azure and BizTalk

Microsoft Azure/BizTalk_Read

Let's learn and share !

Boutaleb Hicham

Biztalk & Azure Integration Architect : Logic Apps, Serverless, Azure Service Bus, BizTalk Server, and Hybrid Integration

Pieter Vandenheede

Stories, tips & tricks for BizTalk Server, Azure, Data Science & Machine Learning

Glenn Colpaert

Blogging with my head in the (Hybrid) Cloud and my feet on premises! Azure / IoT / Integration

BizMunch

BizTalk blog by Knut Urke

Dragon's BizTalk Blog

A blog about BizTalk, and other integration tools.

The Deployment Bunny

OS Deployment, Virtualization, Microsoft based Infrastructure...

Integration Made Easy

Demystify Integration Development

%d bloggers like this: