|
My existing client has several Oracle databases (8i) and a SQL Server 2000 database exchanging data (both ways) with an external supplier who has a SQL Server 2000 database.
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.
|