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 graphically selecting the tables you’re interested…


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. The provider supports EXECuting RFCs, SELECTing from a single table, and…


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 of the WCF LOB Adapter SDK V1 SP2,…


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. SSIS source data flow components, by default return only the first result set returned…

5

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 between the client and the SAP Server. For DATS,…

1

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 scenario – you invoke an RFC using the SAP Adapter, pass in…


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 Like ‘d%’) (NOTE – the casing of the last value was modified)….