When to use Orchestration

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › When to use Orchestration

Viewing 2 reply threads
  • Author
    Posts
    • February 3, 2008 at 12:15 AM #18863
      community-content

        I have a situation where i need to grab some data from SQL Server and convert it to a flat file. Flat file will have a header,details and trailer. I would like to know pros and cons of implementing this solution using orchestration. I could implement the solution (without the use of orchestration) using SQL adapter to grab the data and then use a map to convert it to flat file in the send pipeline.

        Also, does it even make sense to do this project with BizTalk. Won’t SSIS package be a better solution?

        Thanks in advance.

      • February 3, 2008 at 11:41 AM #18865
        community-content

          If you can solve this by simple use of an adapter and a pipeline I can’t see why you should use an orchestration. You should only build an orchestration if you need to implement some business-logic in this flow. An orchestration in this example will be unnessary overhead. Thats my opinion. 🙂

           

          • February 4, 2008 at 1:18 PM #18870
            community-content

              Thanks. How about for the sake of error handling. e.g What if you need to send an email message, in case of some problem.

          • February 4, 2008 at 2:15 AM #18866
            community-content

               

              If you requirement is only grab data from SQL and convert it
              into flat file

              1.      
              First SSIS is best batter & economical solution
              according to your need.

              2.      
              I should use map and send pipeline.

          • Author
            Posts
          Viewing 2 reply threads
          • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.