Welcome to MSDN Blogs Sign in | Join | Help

WCF LOB Adapter SDK and BizTalk Adapter Pack

The BizTalk Adapter Pack, comprising of the SAP, Siebel, OracleDB, OracleEBS and SQL WCF Bindings / Adapters which can be used with BizTalk Server 2006 R2 and R3. The Windows Communication Foundation (WCF) Line Of Business (LOB) Adapter SDK.

Syndication

News

CTP4 released (Adapter Pack V2, Adapter SDK V1 SP2) on October 21, 2008

Other Blogs Related to BizTalk Adapter Pack

Browse by Tags

All Tags » SAP ADO   (RSS)
Support for SAP Queries in the SAP ADO.NET Provider
In the BizTalk Adapter Pack V2, we are adding support for execution of SAP Queries. A brief one liner on SAP Queries – you can use the SAP GUI designer to create something similar to a “SQL Query” (similar to how you would do it in Microsoft Access) by Read More...

Posted Thursday, September 25, 2008 9:22 AM by mdoctor | 0 Comments

Filed under:

SAP ADO – Design Time helper tool
Attached to this post is a standalone .NET Windows Form application which can be used to browse artifacts on SAP, and build queries which the SAP ADO.NET provider can understand. The main aim is to reduce the grunt work required when building the queries. Read More...

Posted Wednesday, August 20, 2008 2:44 PM by mdoctor | 0 Comments

Filed under:

Attachment(s): Microsoft.Data.SAPClient.DesignUI.zip

Using the SAP ADO.NET Provider From SSRS 2005
One of the new features which we’re supporting in the BizTalk Adapter Pack V2 is the ability to use the SAP ADO.NET Provider from SSRS. In this post, I’ll briefly outline the steps you need to perform in order to get this to work. Firstly, install CTP3 Read More...

Posted Friday, August 15, 2008 2:48 AM by mdoctor | 0 Comments

Filed under: ,

Attachment(s): SSRSConfigFiles.zip

Using SSIS to read data from any table returned by an RFC/BAPI with SAP ADO
EDIT: In the Adapter Pack V2, this option is supported out-of-the-box (the EXEC syntax in the SAP ADO Provider supports specifying which resultset should be returned as the first one). Please refer to the documentation on the supported syntax for this. Read More...

Posted Monday, December 31, 2007 7:59 AM by manasg | 0 Comments

Filed under: ,

Attachment(s): SAPAdoSource.zip

The EnableSafeTyping Binding Property
In the November CTP of the Adapter Pack V1, a new binding property has been added to the SAPBinding - "EnableSafeTyping" (a boolean) When this property is true, DATS, TIMS and NUMC fields are exposed as Strings, and any value can be passed back and forth Read More...

Posted Saturday, November 24, 2007 5:38 AM by mdoctor | 1 Comments

Filed under: ,

Debugging SAP RFCs when using the SAP Adapter / SAP ADO.NET Provider
The RFC SDK supports the ABAP_DEBUG option, which allows you to break into the RFC ABAP code when invoking an RFC from your application. The SAP Adapter and the SAP ADO.NET Provider also expose this setting. The main advantage of this - consider this Read More...

Posted Monday, October 29, 2007 5:55 PM by mdoctor | 0 Comments

Filed under: ,

OutOfMemory exceptions when using the SAP ADO Provider .. and how to work around them.
I ran the following two queries using the SAP ADO Provider SELECT * FROM Table1 (this table contains 8 million rows in our SAP server) SELECT * FROM Table2 (this table contains 40 thousand rows in our SAP server). The first SELECT query ran fine, but Read More...

Posted Sunday, October 21, 2007 9:43 AM by mdoctor | 0 Comments

Filed under:

SAP DATS column containing the value "a.b.c.d" ??? (Problem when SAP ADO is used ..)
While going through the data stored in one of the tables in SAP, we saw a value "a.b.c.d" stored in a DATS column! How could that be? A DATS column is supposed to store a Date value, right? Well, it seems that SAP does not enforce any validation on the Read More...

Posted Monday, October 15, 2007 7:13 AM by mdoctor | 0 Comments

Filed under:

SAP - can all fields in a table store mixed-case characters?
While investigating a possible bug, I ran the following two queries using the SAP ADO Provider: SELECT NAME1, LAND1, KUNNR from KNA1 where (NAME1 LIKE 'Dan%' AND LAND1 Like 'D%') and SELECT NAME1, LAND1, KUNNR from KNA1 where (NAME1 LIKE 'Dan%' AND LAND1 Read More...

Posted Tuesday, October 09, 2007 3:08 AM by mdoctor | 0 Comments

Filed under: ,

Page view tracker