BizTalk Server Adapter Pack 2010: WCF OracleDb Adapter
Introduction
The BizTalk Adapter Pack 2010 provides connectivity to SAP, Oracle E-Business Suite, Siebel and SQL and Oracle Databases. The Oracle Adapter (i.e. OracleDb Binding) provides access to Oracle Database tables, views, stored procedures, functions, and PL/SQL packages. Timed polling is also provided, allowing applications to periodically look for changes in the database. This adapter/binding is based on ADO.NET.
Note: According to Microsoft website adapter supports Oracle 9i (9.2.0.2), 10g (10.1.0.2.0 & 10.2.0.1.0), but documentation mentions Oracle 11g R1.
This article will provide you the necessary resource links to find information on the BizTalk WCF-OracleDb Adapter, how to work with it and so on.
Blogs
The following blog post provides you more background information on WCF-SQL Adapter, how to install it, use it, and so on:
Code Samples
Through MSDN Code Gallery and download center you can find a number of code samples:
- BizTalk Adapter Pack 2010: Oracle Database Adapter Samples
- Table Operations on Oracle 11g XE with OracleDbBinding
Other languages
This article is also available in the following languages
See Also
Read suggested related topics:
Another important place to find a huge amount of BizTalk related articles is the TechNet Wiki itself. The best entry point is BizTalk Server Resources on the TechNet Wiki.