All data exchanges use SOAP messages with Microsoft's BizTalk 2004 as the message broker.
Data from Oracle and SQL Server are extracted using REF CURSORS and formatted into XML messages by the Web service, which is written using a .NET environment.
Dig Deeper on Oracle SOA
Related Q&A from Harish Harbham
SOA and Integration expert Harish Harbham explains how to transfer data from Oracle to MS SQL Server. Continue Reading
Oracle expert Harish Harbham explains how Oracle Streams can be used for replication. Continue Reading
Expert Harish Harbham answers the question, "How do you convert SQL Server 2005 database into 0racle 10g?" Continue Reading