BizTalk Static Oracle Adapter Sample

  • Article

The Microsoft BizTalk Server 2004 Adapter for oracle uses ADO.NET. The idea is developing an easy to use efficient adapter that connects modern SOA based applications to Oracle databases, the adapter supports Oracle version 8.0i and later. Goals: Developing an adapter capable of - Transmitting messages to Oracle database - Receiving messages from Oracle database - Dynamic Schema Generation - Executing Oracle o Functions o Stored Procedures o Statements. - handling the extreme differences between Oracle data types and CLR data types.

Very cool stuff developed in the land of the Sphinx and recently posted to gotdotnet. Big thanks to Khaled M. Hnidk of Link.NET.