Re: Need Suggestion on Using BizTalk

Home Page Forums BizTalk 2004 – BizTalk 2010 Need Suggestion on Using BizTalk Re: Need Suggestion on Using BizTalk

#21437

Tushar,

Well, to be totally honest, I wouldnt use BizTalk in this particular scenario. I say that based on:

A- you need to run the code as a scheduled event. Well, you need other code to trigger BizTalk to wake up and process this data.

B- What will probably happen is that youll be calling these snippets from helper classes that you would either place in an orchestration or a pipeline etc. This isnt utilizing the engines effeciently as you will be dehydrating everything for half a day and just calling them and recieving the results.

C- You seem to be doing batch processes that run in a transaction. This sounds like a perfect scenario for a SQL job. (now im not an Oracle expert, but im sure there is something there like that)So what you will be  doing is licensing SQL as well as BizTalk and not really utilizing BizTalk unless you refactor the code and make it run in a single message-based scenario, where BizTalk would be perfect.

 

Hope that sheds some light on the issue