Martijn's blog - E-Commerce, EAI, BizTalk and .NET

2005/06/20

Party Resolution: NorthWind Suppliers table

Using the NorthWind database' Suppliers table for Party Resolution as an example might pose some interesting issues. BizTalk Explorer doesn't let you add Parties containing `~!@#$%^&*()+=[]{}|;'"<>,?

With names in the CompanyName column like Grandma Kelly's Homestead and Heli Süßwaren GmbH & Co. KG it seems to be impossible to simply add those companies as parties for creating a NorthWind order processing example orchestration....

Altering the BizTalkMgmtDb (bts_party and bts_party_alias) seems to do the trick though (not supported ofcourse ;-p). Just inserting a new party into bts_party and setting it's alias in bts_party_alias works like a charm (fully tested with simple party resolution)

2 Comments:

  • Man I like your post and it is so good and I am definetly going to save it. One thing to say the Indepth analysis this article has is trully remarkable.No one goes that extra mile these days? Bravo!! Just one more tip you canget a Translator for your Worldwide Audience !!!

    By Anonymous Gadgets UK, at 9:46 AM  

  • Thanks you. Very good post.Unless they can offer a really compelling reason for users to come back, it will be the next Bebo, MySpace

    By Anonymous 10755GF, at 11:08 PM  

Post a Comment

<< Home