Editing: BizTalk Server Adapter Pack 2010: WCF OracleDb Adapter

Title
<html> <body> [toc]<br> <h1><a name="Introduction"></a>Introduction</h1> The <a href="http://www.microsoft.com/biztalk/en/us/adapter-pack.aspx" target="_blank"> BizTalk Adapter Pack 2010</a> 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. <p><span style="text-decoration:underline"><strong>Note:</strong></span> According to Microsoft website adapter supports Oracle 9i (9.2.0.2), 10g (10.1.0.2.0 & 10.2.0.1.0), but <a href="http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=1325" target="_blank"> documentation</a> mentions Oracle 11g R1.<br> <br> 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.</p> <h1><a name="Blogs_TechNet_Wiki"></a>Blogs</h1> The following blog post provides you more background information on WCF-SQL Adapter, how to install it, use it, and so on:<br> <ul> <li><a href="http://soa-thoughts.blogspot.com/2011/04/table-operation-on-oracle-11g-xe-with.html" target="_blank">Table Operation on Oracle 11g XE with OracleDbBinding</a> </li></ul> <h1><a name="Code_Samples"></a>Code Samples</h1> Through MSDN Code Gallery and download center you can find a number of code samples:<br> <ul> <li><a href="http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=4675" target="_blank">BizTalk Adapter Pack 2010: Oracle Database Adapter Samples</a> </li><li><a href="http://code.msdn.microsoft.com/Sample-Table-Operations-on-ec64d9b8" target="_blank">Table Operations on Oracle 11g XE with OracleDbBinding</a> </li></ul> <h1><a name="See_Also"></a>See Also</h1> <p>Another important place to find a huge amount of BizTalk related articles is the TechNet Wiki itself. The best entry point is <a href="http://social.technet.microsoft.com/wiki/contents/articles/2240.biztalk-server-resources-on-the-technet-wiki.aspx" target="_blank"> BizTalk Server Resources on the TechNet Wiki.<br> </a><br> Read suggested related topics:</p> <ul> <li><a href="http://social.technet.microsoft.com/wiki/contents/articles/biztalk-server-adapter-pack-2010.aspx" target="_blank">BizTalk Server Adapter Pack 2010</a> </li><li><a href="http://msdn.microsoft.com/en-us/library/dd788173.aspx" target="_blank">Microsoft BizTalk Adapter for Oracle Database Help </a></li></ul> <h1><a name="Other_languages"></a>Other languages</h1> <p>This article is also available in the following languages</p> <ul> <li><a href="http://social.technet.microsoft.com/wiki/contents/articles/8613.biztalk-server-adapter-pack-2010-wcf-oracledb-adapter-nb-no.aspx" target="_blank">Norwegian: BizTalk Server Adapter Pack 2010: WCF OracleDb Adapter (nb-NO)</a> </li></ul> </body> </html>
Comment
Tags
Please add 4 and 7 and type the answer here:

Products

Resources

Solutions

Updates

Trials

Related Sites

Training

Certifications

Other resources

Support options

More support

Not an IT pro?