Extract data Oracle and insert Informix in BizTalk

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Extract data Oracle and insert Informix in BizTalk

Viewing 1 reply thread
  • Author
    Posts
    • September 11, 2006 at 4:01 PM #15656
      community-content

         

        Dear recipient: 

        I need in biztalk extract information of database oracle and transform datos and then insert this information in other database informix or SQL Server,  this run automatic  how I do make this with store procedure or sql adapter???  Have an example?

        I beginner in biztalk, now read documentation for know.

        Thanks for your help.

        Regards. 

      • September 13, 2006 at 9:52 PM #15677
        community-content

          Hello.

           

          You need to configure the Oracle Adapter to query Oracle to return your records to BizTalk.  Then, use a map to transform the data into your SQL Schema.  Last, you can use the SQL Adapter to send the data into SQL.

           

          You should be able to find sample of SQL and Oracle Adapter in the SDK.

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