In BizTalk 2010, the adapter pack is not out of the box component, and you need to install them.
The BizTalk Adapter Pack 2010 provides connectivity to SAP, Oracle E-Business Suite, Siebel and SQL and Oracle Databases. The BizTalk Adapter Pack can be installed in conjunction with, or separately from, BizTalk Server.
The BizTalk Adapter Pack 2010 includes support for new versions of the following line-of-business applications and databases: SAP 7, Oracle EBS 12.1 and SQL Server 2008 R2. The Adapter Pack also provides support for Visual Studio 2010 and .NET Framework 4.
It is included in both the Enterprise and Standard Editions of BizTalk. When you install the adapter pack on x64 environment you have to perform a few steps. These steps were described in earlier versions through installation guides, although for some it was not always clear (i.e. I saw couple of questions on forum about how to install or problems people had). There is documentation to install adapters pack, but now during installation one is guided through the necessary steps.
First re-execute the BizTalk instalation wizzard and select install adapter Pack.
You’ll get this screen :
For a developper, you need to install each item in the complete version.
At the end go to BizTalk administration console -> plateform setting -> adapter.
Right click on it and select « add new adapter » and normaly you’ll obtain this screen :
Name it and press OK, now you can play with newly created adapter (don’t forget to restart host)