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.

Browse by Tags

Tagged Content List
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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, and the BizTalk...
  • Blog Post: 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...
  • Blog Post: 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. ...
  • Blog Post: 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...
  • Blog Post: 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 the second one threw an OutOfMemory exception...
  • Blog Post: 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 value being stored in a DATS column (other than...
  • Blog Post: 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...
Page 1 of 1 (9 items)