Biztalk as a Data Loading Tool

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Biztalk as a Data Loading Tool

Viewing 2 reply threads
  • Author
    Posts
    • February 23, 2007 at 6:45 AM #17775
      community-content

        I am about to work on a solution in BizTalk Server 2006 which will
        call a couple of Oracle stored procedure in a seqence in an
        Orchestration, Each of the Oracle Stored procedure will fetch records
        (Thousands or may be Millions) from multiple databases and will insert
        those records in another Oracle databases.

        Its my understanding
        that the since the fetching of records (from source databases) and
        insertion of records (in target databaes) Logic is written in Oracle
        procedures and BizTalk will only be calling those stored procedures
        there will be NO RESOURCE CONSUMPTION AT THE BIZTALK END i.e. there
        will be no messages or tracking data stored in Message box database,
        since EACH RECORD FETCHED AND INSERTED WILL NOT PASS THROUGH BIZTALK,
        only BizTalk Orchestration will Synchronously wait for the time the
        procedures are executed WITH MINIMAL RESOURCE consumption and control
        will return back to Orchestration once the stored procedures are
        executed.

        I would ask for Confirmation of this Understanding from BizTalk Experts here.  

         

         

         

         

         

      • February 23, 2007 at 9:57 AM #17780
        community-content

          By your description it seems to me like a misuse of Biztalk.

          Couldn't this work be done all in Oracle?

          I would first justify why you need to leave the Oracle environment.

          -wa 

           

           

          • February 23, 2007 at 8:59 PM #17783
            community-content

              Firstly thanks a lot for your reply.

              We are integrating a
              number of Legacy Applications using the BizTalk Server 2006, as the
              part of this Integration, an application (ASP.NET with Oracle Database
              ) is Integrating with another Application (an Oracle Database). The
              first application needs to fetch data from the second application for
              its data requirements. Currently there is an Oracle job which runs on
              the second application (Oracle database) which inserts records in the
              Oracle database of the first application using an Oracle Stored
              Procedure described earlier. Obviously, currently this is a Point to
              Point Integration.

              Now we want to remove this Point to Point
              Integration using a seemless Middleware (SOA) architecture and want
              this Intergation to be done using the BizTalk Server. It means BizTalk
              would now do this data fetching and insertion rather than the current
              Oracle job.

              I hope this description would have clarified the requirement.

               

               

               

          • February 26, 2007 at 2:03 AM #17788
            community-content

              What is realy the purpose of using Biztalk here? Is it only to keep the sequence of calling the stored procedures? The problem you are trying to solve could possibly be best solved with the SQL Server's Integration services instead of Biztak.

              Cheers,

              Joshua

              e-mail:  [email protected] 

               

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