Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Need Suggestion on Using BizTalk › Re: Need Suggestion on Using BizTalk
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