Windows Server - WCF-Custom with SQL Binding VS WCF-SQL in BizTalk 2009
Asked By Manan
30-Oct-09 10:56 AM
Hi,
I=E2=80=99m doing a POC for my client using BizTalk 2009 (which is great =
=EF=81=8A)
and I need to use the SQL adapter.
BizTalk 2009 now provides the WCF LOB based SQL adapter. But my main
question is, why do we have a separate WCF-SQL adapter and WCF-Custom
(with SQL binding)? Which one to use? Are there any pros and cons of
using each of this? Any input on this will be very helpful.
Also in previous version of SQL adapter (BTS 2006) we need to cluster
the host instance to avoid the race condition and to avoid the receive
location getting disabled? Does the same apply with the new WCF based
adapter as well or now we do not need to cluster the host instance?
Thanks in advance.
BizTalk
(1)
WCF
(1)
FTP
(1)
Fischer
(1)
Joerg
(1)
Adapters
(1)
Cons
(1)
Abf2
(1)
news.microsoft.com replied to Manan
Hi,
The WCF-SQL Adapter ist to be configured as WCF-Custom.
Why did you have to cluster the receive Location in the old SQL adapter?
I would suggest to set the BizTalk Host to run 32 bit in order to avoid
possible pitfalls.
Thanks, regards
Joerg Fischer
Hi,
I???m doing a POC for my client using BizTalk 2009 (which is great ???)
and I need to use the SQL adapter.
BizTalk 2009 now provides the WCF LOB based SQL adapter. But my main
question is, why do we have a separate WCF-SQL adapter and WCF-Custom
(with SQL binding)? Which one to use? Are there any pros and cons of
using each of this? Any input on this will be very helpful.
Also in previous version of SQL adapter (BTS 2006) we need to cluster
the host instance to avoid the race condition and to avoid the receive
location getting disabled? Does the same apply with the new WCF based
adapter as well or now we do not need to cluster the host instance?
Thanks in advance.
Manan replied to news.microsoft.com
-469f-abf2-4e2aaa65ef33@m16g2000yqc.googlegroups.com...
=EF=81=8A)
Hi Joerg,
Thank you very much for your reply.
I agree with you no need to cluster the receive host for SQL. I was
confused with other adapters such as FTP, POP.
We can configure WCF-Custom adapter with sql binding to communicate
with the SQL server but then why do we have separate WCF-SQL adapter.
What is the difference between these two?
Cheers,
Manan
news.microsoft.com replied to Manan
Hi,
Generally speaking I found that, with the WCF-Custom Adapter, there are
many more elements which can be modified. The more specific adapters
sometime do not offer all possibilities, but are easier to configure in the
first place.
Regards
Joerg Fischer
Hi Joerg,
Thank you very much for your reply.
I agree with you no need to cluster the receive host for SQL. I was
confused with other adapters such as FTP, POP.
We can configure WCF-Custom adapter with sql binding to communicate
with the SQL server but then why do we have separate WCF-SQL adapter.
What is the difference between these two?
Cheers,
Manan
Questions about BizTalk Windows Server Hi I am evaluating the use of BizTalk 2009 and are a newbie on this. I am pretty sure it is the way have some questions however that I hope someone can answer: The project requires that the BizTalk server is able to receive messages from multiple outside parties and transform and route the message to other parties based on contents. This I am sure BizTalk can, but please correct me if I am wrong. One of my questions is BizTalk receives messages, but can it also I believe this is possible, but how is it done (WCF, Orchestration) ? Kind regards Roy Nielsen BizTalk Discussions SQL Server (1) BizTalk (1) Oracle (1) WCF (1) FTP (1) Adapters (1) Fischer (1) Joerg (1) Hi, The
WorkFlow in Sharepoint and BizTalk Windows Server Hi All, BizTalk is not only known at it's mapping, variaty files converting, also be known at it even has define and excute business rules. So, why do we have to use biztalk now? Thanks, Wade BizTalk Discussions BizTalk (1) WCF (1) SharePoint (1) WorkFlow (1) WF (1) EDI (1) MQSeries (1) XML (1) Use BizTalk for 1) Fault tolerance / Load Balancing (Using Physical Hosts / Logical Posts) 2) Tracking 3) BAM Workflow Foundation). if I have to : 1) Receive a EDI or FLAT file from a FTP server, or MSMQ or MQSeries Queue, or over a HTTP / WCF (BizTalk R2) / Web Service
BizTalk Adapter (SAP) Windows Server Hello! I am just evaluating the possibilities to develop interfaces to ways (e.g. ERPConnec, www.erpconnect.de or Java Connector. . .). I think that the SAP BizTalk adapter could do the same job or not? I am a little confused and have some questions: - I found two BizTalk adapters, the "Microsoft WCF LOB Adapter for SAP" and there differences between them (or is this just a "renaming Is it necessary to install the BizTalk server at all? Or can i use the adpater "standalone" in Visual Stuido? - And does I asked support and there is a Pricing and Licensing FAQ (http: / / www.microsoft.com / biztalk / en / us / pricing-licensing-faq.aspx): "All Microsoft adapters, including Line of Business (such as SAP, PeopleSoft, or Siebel) and transport (such as FTP or HTTP), are included with a license of BizTalk Server 2006 R2." But i am quite not sure if the adapter itself is free
BizTalk WCF Question Windows Server Hi , I am planning to publish orchestrations as WCF services by using the WCF Service Publishing Wizard. Few questions 1. Can any non-WCF client consume published BizTalk Orchestration WCF Service? I am assuming that answer is “Yes†since any non WCF client can consume WSDL and generate proxy for this. But pls confirm? 2. We have