WCF LOB Adapter SDK and BizTalk Adapter Pack

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

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

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

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

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

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

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

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

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