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 11.1.0.6.21 (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