BizTalk Adapter Pack team has released a CTP. This is  the 5th CTP and the first one available publicly to everyone to try.  The specific enhancements in this CTP  are mostly to the OracleDB adapter(included in the BAPv1) to which we added features like support for polling stored procedures and composite operations. In addition we have addressed some feedback we got from the other adapters .


To re-iterate here is the complete list of features BAPv2 is adding . The downloads are available internally at http://adapters and on the connect site


BizTalk Adapter Pack V2 – Themes


New Adapters

%u00b7           Oracle EBS Adapter

%u00d8  Browse and search metadata for each Oracle application

%u00d8  Support Interface tables, Interface views

%u00d8  Support for PL/SQL APIs

%u00d8  Concurrent Programs, Request Sets

%u00d8  Support for polling tables, Stored Procedures

%u00d8  Notification support

%u00d8  App context initialization

%u00d8  Supports REF cursors, User Defined Types, LOB types, RECORD types

%u00d8  Support for PL/SQL Tables, boolean data types

%u00d8  Support for MLS EBS installations

%u00d8  Microsoft Office SharePoint Server Integration

%u00d8  Versions supported – ODP.NET (available only on 32bit), Oracle EBS 11.5.9, 11.5.10 and 12

%u00b7           SQL Server Adapter

%u00d8  Insert/Update/Delete/Select operations on tables and views

%u00d8  Invoke (SQL and CLR) Stored procedures, scalar valued functions , table value functions

%u00d8  Supports execution of generic T-SQL statements, via the ExecuteReader(), ExecuteNonQuery() and ExecuteScalar() operations

%u00d8  Configurable polling – polling statement, polling interval, receive multiple result sets

%u00d8  Support for x86 and x64  platforms

%u00d8  Support for new data types in SQL2005 and SQL2008 (notably FILESTREAM, varbinary (max))

%u00d8  Support for UDTs

%u00d8  Ability to pass table value parameters

%u00d8  Composite operations – invoke operations on multiple tables and call any number of stored procedures in the same transaction

%u00d8  SQL query notifications

%u00d8  Ability to directly call stored procedures which used the ’for xml’ style supported by the BizTalk 2006 SQL adapter to ease backward compatibility

%u00d8  Versions supported – SQL 2000, SQL 2005, SQL 2008


Enhancements to the existing V1 Adapter Pack


  • Include hot fixes built since the V1 Adapter Pack released

  • Support new Microsoft Platform releases – BTS 2009, VS 2008, Windows Server 2008

  • Oracle DB Adapter:

%u00d8  Polling support for tables, Stored procedures

%u00d8  UDTs, PL/SQL tables  (from Beta onwards)

  • SAP Adapter:

%u00d8  Support for Table Types

%u00d8  Customization of adapter behavior when “special” values obtained for DATS/TIMS/NUMC

%u00d8  SAP ADO Provider Enhancements:

o   Support for SSRS

o   Support for SAP Queries

o   Ability to specify the result set to give to SSIS when executing BAPIs

  • Siebel Adapter:

%u00d8  MVG operations (associate, dissociate, query) in design time enabled

%u00d8  Bounded pick list fields supported per recommended approach

%u00d8  Context specific custom messages generated for exceptions