WCF LOB Adapter SDK and BizTalk Adapter Pack

Using SSIS to read data from any table returned by an RFC/BAPI with SAP ADO

SSIS source data flow components, by default return only the first result set returned by the underlying ADO. When working with BAPIs and RFCs that return multiple tables, the SSIS component would take the first table that it comes across. To demonstrate Read More...

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

Attachment(s): SAPAdoSource.zip

Using WCF Adapters with SQL Server Integration Services(SSIS)

There are two ways the adapters belonging to Adapter Pack can be used by SQL Service Integration Services: 1. Using ADO layer built on top of base adapters. This option is available with SAP and Siebel adapters. 2. Writing custom SSIS task which directly Read More...

Posted Saturday, December 29, 2007 10:26 AM by anilpr@microsoft.com | 0 Comments

Attachment(s): SsisSiebel.zip

The EnableSafeTyping Binding Property

In the November CTP, 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 Read More...

Posted Saturday, November 24, 2007 5:38 AM by mdoctor | 0 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

Positioning the BizTalk Adapter Pack

The adapters constituting the BizTalk Adapter Pack are fundamentally custom WCF binding elements. Built on the WCF LOB Adapter SDK, these adapters are host agnostic i.e. they are not tied to a specific product like BizTalk. However, their predecessors, Read More...

Posted Monday, October 29, 2007 6:08 AM by mahadevanv | 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