The following blog post by Atin nicely explains how to go about doing this http://blogs.msdn.com/biztalkcpr/archive/2009/10/05/inserting-parent-child-records-with-identity-column-using-wcf-sql-adapter-in-one-transaction.aspx

This post is a follow-up to http://blogs.msdn.com/adapters/archive/2008/06/30/using-the-wcf-sql-adapter-to-read-messages-from-ssb-queues-and-submit-them-to-biztalk.aspx and explains how to push a message using the WCF SQL Adapter from BizTalk to a SQL...

For customers currently using the Microsoft BizTalk Adapters for Enterprise Applications (aka the LOB adapters) and willing to migrate their existing projects to the WCF-based LOB adapters, here's a tool that will help you migrate your projects to work...

Sometimes, the Oracle EBS adapter throws this error while invoking artifacts like Concurrent Programs, Interface Tables, Interface Views and a few PL-SQL APIs. The message in the event viewer looks like the following (snipped some portions to improve...

Here is a simple way to get started on Oracle AQ (Advanced Queuing) using the Oracle Database and/or Oracle E-Business Suite adapters. Here is what I did, right from defining my queue - one step at a time. Step 1 - Define the queue payload type CREATE...

Siebel adapter uses the COM interface to invoke calls on Siebel. For business component query, Siebel supports two ways of retrieving the field values for records. One can either use GetFieldValue to retrieve one field at a time or the other option is...

The BizTalk Adapter Pack 2.0 was released to manufacturing and is now generally available . For BizTalk 2009 users (except branch edition), the Adapter Pack 2.0 license comes free and can be downloaded from the volume licensing site. Biztalk 2006...

I have seen quite a few instances where people run into issues while using the WCF Siebel adapter because of a. Siebel Web Client is not installed correctly on the machine b. Or the URI passed to the adapter, that eventually gets transformed...

If you are writing a WCF LOB adapter that can be consumed through BizTalk, you need to be aware of certain issues that can manifest because of the way BizTalk interacts with WCF adapters. Some of these can have performance and scalability impact and hence...

On the website http://msdn.microsoft.com/en-us/library/dd451003.aspx , we have a step by step guide to publish the Siebel adapter as a WCF Service in IIS and then have MOSS consume the data using that service. In this approach, credentials are pass by...

Hi all, We are pleased to announce the release of the Adapter Pack 2.0 Beta.As this is a public beta, customers can also download a 120 day evaluation version here .The features we added are listed below in brief . In addition, we are shipping a free...

As the Beta release for the Adapter pack approaches, here's a list of changes in the Oracle EBS/DB Adapters so that you can prepare for it: · Now support Windows Vista and Windows Server 2008 · B ased on Oracle ODP.Net 11.1.0.7 Both...

BizTalk Adapter Pack team has released a CTP. This is the 5 th CTP and the first one available publicly for everyone to try. The specific enhancements in this CTP are mostly to the OracleDB adapter(included in the BAPv1) to which we added features like...

Consider a scenario where I want to insert data into two tables in a single transaction. The tables have a field that should be populated using the same sequence - one using SEQUENCE.NEXTVAL, and the other using SEQUENCE.CURRVAL, so that both tables get...

Adapter Pack CTP 4 is here and we have added a lot more features based on some feedback we have been getting from various channels. So here is the list of major enhancements SQL adapter Support for “for xml” style procedures used commonly with...

As and when we release newer hotfixes, I will edit this post. Hotfix list for the Microsoft BizTalk Adapter Pack V1 Hotfix/KB Number Component Affected Description 950101 OracleDB An error occurs if you try...

In typical Oracle EBS scenarios, it is a common requirement to insert computed values into a table. For example, one might want to populate the key column using a sequence, or insert something like SYSDATE into a date column. However, if the adapter makes...

The messages sent to Oracle EBS Adapter can take three message context properties (starting CTP4): 1. Application Short Name 2. Responsibility Name 3. Organization Id We introduced these properties so that one can invoke operations on a single port with...

When the Oracle E-Business Suite (EBS) Adapter performs an operation on an Interface Table, Interface View, Concurrent Program, or a Request Set (Coming in the CTP4), it compulsorily sets the application context. To set application context, the adapter...

In this post, I outlined the ways in which stored procedures can be executed using the SQL Adapter. Similar to the methods described there, are very similar methods for polling on the inbound side. (I won’t mention the advantages/limitations/workarounds...

A question which has popped up quite a few times over the last couple of weeks – “For an outbound contract, I see RFC, TRFC, IDOC and BAPI nodes in the UI. However, for an inbound contract, the BAPI node is missing. Why?” Firstly, I’m going to explain...

If you’ve used the SQL Adapter in CTP3 of the BizTalk Adapter Pack V2, you’ll notice that there are two nodes in the Metadata Hierarchy for Stored Procedures – one is named “Procedures”, and the other is named “Strongly-Typed Procedures”. What’s the difference...

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

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

CTP3 is here and we have added a lot more features based on some feedback we have been getting from various channels. So here is the list of major enhancements SQL adapter: 1) Strongly typed polling 2) Strongly typed stored procedures Oracle...