Shahar Ron

Using BizTalk to send files to an FTP server via a proxy

A client had the need to use BizTalk to send files to an FTP server via a proxy server. There is no place to specify a proxy in the FTP send adapter configuration and there is nothing about how to do it in the BizTalk documentation nor my search on the web come out with any info on that. After playing with different configuration variations it was found that the following setup will work: In the 'Server' field put the IP of the proxy server In the 'User Name' put EndTargetServerIP...

Automatic generation of BizTalk DB restore SQL

When backing up the BizTalk databases you need to use BizTalk backup job for that since creating a regular maintenance task is not enough. The reason is that the BizTalk mechanism ensures that all the DBs BizTalk needs are backed up in a way that can be later restored to a synchronized point, this is done by entering a transaction marker to all the DBs before the backup. This marker will appear in their log. When performing the restore action, all the DBs should be restored up to that marker. The...

Automatic DLL unloading in BizTalk interferes with data caching

In BizTalk we often cache data in memory to improve performance, for example conversion tables or configuration data. Cached data is usually kept in static variables. When a DLL is released from memory, all of his static members are released as well. When we write our application, DLLs are not unloaded until the application is shutdown, unless we specify this explicitly. BizTalk implements an internal logic of unloading DLLs from its memory. By default it unloads DLLs that have not been active for...