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)
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)