We do use BizTalk to connect up to a third party ordering system. I would probably classify this as a useful, yet beginner approach to using the vast capabilities BizTalk seems to offer. By this, I mean we only use a fraction of the functionality. It goes something like this:
- An orchestration polls a third party IBM message queue.
- This queue holds order information (in xml format) that we eventually need to import into our Microsoft SQL Server Database.
- Once the xml is received from the queue we run a xslt translation to get the xml into a format that our system understands.
- With the translated xml we end up calling a stored procedure which does the the actual "importing" of the order.
The solution ended up working fairly well and has been in production for a few years now. It's one of those things that just works.
One thing I would note is that while developing this we tried to use the Mapper tool to help us with the translation part of things. Our translation was quite complicated and the tool itself was super tedious to use. Since we were comfortable with xslt we ended up writing our own and not using the graphical Mapper tool. It seems that the Mapper tool would be very useful for simple translations, but anything over a handful of elements starts to become a maintenance nightmare (IMHO).