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

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 invokes adapter to communicate with LOB system. Option 1 covers all…


Why does the Adapter say ‘Action is not understood’ even though I am using the binding file generated by the ‘Consume Adapter Service’ wizard?

Believe me, the adapter is telling the truth! It really doesn’t understand the action it got! To understand what’s going on, read on… When you use the ‘Consume Adapter Service’ wizard to generate LOB schemas in a BizTalk project, you also get a binding file which you can import (using the BizTalk Administration Console) to…

6

"Receiving IDocs from SAP using the SAPBinding requires higher SAP user privilege as compared to the older mySAP Adapter". Really??

Firstly, let me explain the common customer scenario using the old (mySAP 2.0) Adapter (NOTE – points in red and green below highlight the similarities/differences in configuration): The user, at design time, uses a high privilege account (let’s call it account A), to obtain the schemas for an IDoc. These schemas are deployed in a…

0

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

Siebel adapter connection URI

Siebel adapter exposes siebel connection string as URI. Siebel URI syntax is given below: siebel://SiebelGateway[:portno]/?SiebelEnterpriseServer=SiebelEnterpriseServerName&SiebelObjectManager=ObjectManagerToConnect&Language=SiebelLanguageCode&SiebelRepository=CurrentActiveRepository&SiebelServer=servername various components of URI are: SiebelGateway: This variable point to siebel gateway hostname or ip address in case only one siebel server is configured for the gateway. If a gateway manages more than one siebel server, then individual server address must…


32 and 64 bit versions of the BizTalk Adapter Pack

There are two separate installers for the AdapterPack – one for X86, and one for AMD64 (x64). A common scenario I see is – the users are on an x64 machine, and install the 64 bit version of the Adapter Pack. They then create a project in Visual Studio, and use the “Add Adapter Service…

2

WCF Siebel adapter Vs Biztalk Siebel adapter

What are the differences between old Siebel adapter shipped with Biztalk releases and WCF based Siebel adapter? Here is the list: Since new Siebel adapter is developed using WCF LOB Adapter SDK (ASDK), ASDK features like Browse, Search and Resolve are available to end users via metadata search browse tool. While old adapter supports only…