Re: load data with file to database oracle and SQL Server in biztalk

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › load data with file to database oracle and SQL Server in biztalk › Re: load data with file to database oracle and SQL Server in biztalk

September 8, 2006 at 3:21 PM #15627
community-content

    [quote user="Nar_BTS"]

    This job will do SQL Adater, Comes with BizTalk, u can use Datagram and create a schema. then map from flat file schema to SQL Schema.

    You can workout StoreProcedues or Querys, both workes here.

    BizTalk 2006 got Oracle Adapter too….

    Hope it helps you.

    Nar- 

     

    Dear Nar:

    If I need in biztalk extract information of database oracle and transform datos and then insert this information in other database Informix how do you recomended this for run automatic, with store procedure or sql adapter??? 

    I beginner in biztalk, now read documentation for know.

    Thanks for your help.

    Regards. 

     

    [/quote]