Using the WCF SQL Adapter to submit messages to SSB queues from BizTalk

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 Service Broker (SSB) queue.   Scenario   1.       An XML message is dropped to a file share 2.       This XML message is made available to the WCF SQL Adapter by using…

1

Introducing the Migration Tool for Microsoft BizTalk Adapters for Enterprise Applications

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 with BizTalk Adapter Pack 2.0. Before we start talking about the tool and the adapter projects…


Why does the OracleEBS adapter say “Could not retrieve User ID, Responsibility ID, and Application ID”?

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 readability): Event Type: WarningEvent Source: BizTalk Server 2009… Description:The adapter failed to transmit message going to send port “<your_send_port_name>”…

0

Using Oracle Database or Oracle EBS adapter for Oracle AQ (Advanced Queuing)

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 typeCREATE TYPE AQ_MESSAGE_TYPE AS OBJECT (ID VARCHAR2(30), INFO VARCHAR2(200)); Step…

1

WCF Siebel Adapter – Query fails because of misconfigured fields

  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 to use GetMultipleFieldValues to retrieve values for a bunch of fields…

0

BizTalk Adapter Pack 2.0 is now available

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 R2 users can get the Biztalk Adapter Pack if they have Software Assurance for Biztalk. Others will…

6

Connection failure when using the WCF Siebel Adapter

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 to the connection string passed to Siebel, is incorrect   In…

2

Things to consider when writing WCF LOB Adapters for consumption through BizTalk

  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 you should consider them when designing/configuring the adapter. Processing…

0

Connect to WCF LOB Adapter hosted as WCF service using ClientCredentials

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 MOSS to the adapter using custom HTTP headers.   If instead you want to consume this service…

1