RE: Which Oracle adapter to use?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance



Hi Lars,

The new WCF based adapter is recommended. Some reasons are written in
adapter pack migration tool's release notes:

"The WCF-based adapters shipped with the BizTalk Adapter Pack 2.0 are the
recommended solutions to integrate various LOB systems with BizTalk Server.
The Adapter Pack consists of LOB adapters for SAP, Siebel, Oracle DB,
Oracle EBS, and SQL Server. They are built on the WCF LOB Adapter SDK
framework. However these are not the first adapters to be released by
Microsoft for integration.

The BizTalk Adapters for Enterprise Applications is a suite of adapters
based on the older BizTalk Adapter Framework and was released with BizTalk
2006 and BizTalk 2009. Among others, this suite has adapters for SAP,
Siebel, and Oracle DB systems. BizTalk Server has a native SQL adapter.

With the release of BizTalk 2009, all these adapters are deprecated in
favour of the WCF-based adapters in the Adapter Pack as the latter set has
more features and support more LOB versions. The Adapter Pack is based on a
different technology and is not compatible out-of-the-box with the older
adapters. For example, an application which used the older SAP adapter will
not work directly if you installed the SAP adapter from the Adapter Pack.

The BizTalk Adapter Pack Migration tool aims to help developers get started
with the process of migrating projects using older adapters to use
WCF-based projects. This tool currently supports migrating SAP, Oracle DB,
and SQL adapters. After running the tool you should be able to deploy and
run the new project as-is in most simple projects or fix some aspects as
per the limitations outlined in the documentation. The package above has a
detailed tutorial on how to use the tool. "

BizTalk Adapter Pack Migration Tool
http://www.microsoft.com/downloads/details.aspx?FamilyID=e68b8fd1-5c8a-499a-
8237-4dc23a8342c5&displaylang=en

Thanks.

Sincerely,

WenJun Zhang

Microsoft Online Community Support

Delighting our customers is our #1 priority. We welcome your comments and
suggestions about how we can improve the support we provide to you. Please
feel free to let my manager know what you think of the level of service
provided. You can send feedback directly to my manager at:
msdnmg@xxxxxxxxxxxxxx

==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/en-us/subscriptions/aa948868.aspx#notifications.

MSDN Managed Newsgroup support offering is for non-urgent issues where an
initial response from the community or a Microsoft Support Engineer within
2 business day is acceptable. Please note that each follow up response may
take approximately 2 business days as the support professional working with
you may need further investigation to reach the most efficient resolution.
The offering is not appropriate for situations that require urgent,
real-time or phone-based interactions. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/en-us/subscriptions/aa948874.aspx
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

.



Relevant Pages

  • RE: Which Oracle adapter to use?
    ... Good info. I'll go with the adapter pack then. ... based on the older BizTalk Adapter Framework and was released with BizTalk ... The BizTalk Adapter Pack Migration tool aims to help developers get started ...
    (microsoft.public.biztalk.general)
  • Re: BTS 2004 support secure FTP?
    ... The best would be to find a BizTalk adapter with that functionality or an ... api-component that you could call through your custom-made adapter. ... > support Secure ...
    (microsoft.public.biztalk.general)
  • BizTalk SAP Adapter V2 and the SAP .NET Connector V2
    ... I have been trying to get the SAP adapter to work for the ... and I am using the SAP .NET Connector v2.0. ... BizTalk Adapter v2.0 for mySAP ...
    (microsoft.public.biztalk.general)
  • RE: Biztalk 2006 with WSE 2.0
    ... There will be a Service Pack to the WSE 2.0 adapter to allow it to work on ... I'm trying to use BizTalk Adapter for Web Services Enhancements 2.0 with ... The Visual Studio's Tools/BizTalk WSE Web Services Publishing Wizard ...
    (microsoft.public.biztalk.server)
  • RE: Database lookup issues with FTP adapter used
    ... Also I wonder if you see any errors in application log when using FTP ... There is a bug about FTP adapter which has been fixed in ... Performance may decrease when you use the BizTalk Adapter for ... List of bugs that are fixed in BizTalk Server 2004 Service Pack 1 ...
    (microsoft.public.biztalk.general)