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)