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 and Oracle WCF Bindings / Adapters which can be used with BizTalk Server 2006 R2. The Windows Communication Foundation (WCF) Line Of Business (LOB) Adapter SDK.

Syndication

Other Blogs Related to BizTalk Adapter Pack

Browse by Tags

All Tags » SAP ADO   (RSS)
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

Filed under: ,

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

Filed under: , , , ,

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

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: ,

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

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