For as long as I can remember, if you needed a transactional and scalable data store, then you would buy a database such as SQL Server and implement your data store on top of that platform. There were already databases fully featured enough and reliable enough that they would likely meet your needs,...
If you are receiving messages which contain potentially sensitive data, for example credit card details or bank identifier codes, then you may not want to allow these to enter BizTalk unencrypted as there will be plain-text copies of the data in the message box database. On the other hand, you don't...
The most important performance factor in a BizTalk environment is the SAN and the way it is configured. I’ve tuned a few enterprise BizTalk systems and in most cases the ultimate (and usually unsolvable by this time) bottleneck has been the disk write queue length on the database disk volume(s). Using...
On a recent project I needed to download some messages into BizTalk 2004 from an FTP site. The smaller files seemed to work fine, but larger files were failing, being left on the FTP server, and being reattempted periodically in an effectively infinite loop. If you have any issues with the FTP adapter...