Re: Extract data Oracle and insert Informix in BizTalk

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

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.