WCF LOB Adapter SDK and BizTalk Adapter Pack

A few people from the BizTalk Adapter Pack and the WCF LOB Adapter SDK are going to be attending the SOA-BP conference at Redmond (Oct 29th - Nov 2nd). If you have any questions, feel free to contact us there. At present, I have no idea where exactly...

You need your SAP Service Marketplace username and password. Visit http://service.sap.com/ Under the "SAP Support Portal", there is a link titled "Software Download". Click on it. In the page that opens up, the left pane is a tree / hierarchical...

SAP has the data types DATS and TIMS, which mean Date and Time respectively. DATS means YYYYMMDD, and TIMS means HHMMSS, with no timezone information being stored anywhere. However, the adapter, working with SOAP messages, accepts date/time values having...

The Biztalk Adapter pack beta2 (mentioned in the post below) contains three adapters - one for Siebel, one for mySAP and one for Oracle DB. If you are already using the Biztalk adapters that shipped with Biztalk 2006 and Biztalk 2006 R2 and would like...

The WCF based adapters that ship in the Biztalk Adapter Pack are WCF bindings. The svcutil tool can be used to get metadata for a LOB method using these bindings. The scheme in the URI determines which adapter binding is loaded by svcutil. However when...

The SAP Adapter supports SAP SNC Authentication. For this, you need to have the SNC libraries present. You can download them by following the steps outlined below: Log in to SAP Service Marketplace . Under the SAP Support Portal section, click...

Since the WCF based SAP Adapter is ... well, WCF based, all data flowing in and out of the adapter is encapsulated within a SOAP message. Which means there are those pesky xml tags all over the place. If you want to receive an Idoc from SAP, you can receive...

The following is a list of key feature differences between the BizTalk Oracle adapter and the WCF-based Oracle DB adapter in the BizTalk Adapter Pack. 1. LOB access : While the BizTalk Oracle adapter uses an ODBC driver to connect to Oracle DB, the...

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...

The Adapter queries the SAP system for metadata for RFCs, and spews out a wsdl. The parameters for the RFC (as exposed in the wsdl) will appear in the following order - they will first be sorted into 4 groups, "Changing, Export, Import, Tables" (C, E...

Assume as part of your business process, you obtain an IDOC from somewhere, in a flat-file format, as below, which you wand to send to SAP using the SAP adapter with the least amount of effort .. EDI_DC40 8000000000001064985620 E2EDK01005 800000000000106498500000100000001...

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...

A number of customers have come back to us saying that error messages pop up when attempting to browse metadata in Visual Studio (the message being something to the tune of - "the binding could not be loaded"). Most of the time, it is due to the proper...

I ran the following query a couple of days back: SELECT LRAWFIELD FROM Z_TEST_TABLE Z_TEST_TABLE is a table defined in my test SAP instance, and LRAWFIELD is a column of type LRAW and length 256. I was writing a unit test, and expected it to pass...

Attached is a sample SQL Adapter built on the ASDK. This adapter (being a sample), is rather simple: (a) Only stored procedure execution is supported. (b) For obtaining metadata about the result set returned by the stored procedure, the stored procedure...

OracleDB adapter supports streaming of data for both inbound (wrt adapter) and outbound messages where it is possible to do so. Streaming can be at record level (in case of Insert operation), xml node level or xml node value level. For inbound messages...

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...

iebel adapter uses Siebel COM control to connect to Siebel backend. Since Siebel COM control objects work only in STA mode, Siebel adapter creates dedicated thread for each connection being opened to server. Sometimes this thread hangs around if Siebel...

If you have used the WCF SAP Adapter prior to Beta2, and then switched to the Beta2 version, one major difference is visible during the Metadata Browse and Search experience - The BAPI node is no longer visible! No, the adapter has not stopped supporting...

The EnableBizTalkLayeredChannel property affects both, the outbound (SendPort) and inbound (ReceiveLocation) scenarios. In this post, I'll explain the inbound (ReceiveLocation) scenario. If this property is set to true, then, when an IDOC is received...

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...

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...