Saturday, February 13, 2010
WCF SQL Adapter - BizTalk Server 2009
WCF SQL Adapter, seems confusing, well terms seems confusing but the adapter is not, The BizTalk Adapter Pack 2.0 now contains fve system and data adapters including
SAP, Siebel, Oracle databases, Oracle applications, and SQL Server.
Till now BizTalk adapter were built using defined BizTalk adapter framework and which based on standard interface and API, now reaching next stage professionals were encouraged by Microsoft to use WCF LOB Adepter SDK. This is new framework which offers evolution of BizTalk conventional armoury, and based of WCF framework.
All adapter in Pack 2.0 built upon WCF LOB meta-data rich components that are surfaced to use WCF bindings, almost similar which you expect from WCF binding. Excellent set of configuration options and flexibility offered by new adapter pack and saving thousands of bucks for connecting premium enterprise application system, e.g. SAP, JDE, other ERP/CRMs etc.
This pack also include SQL Server Adapter, which replace the legacy version of BizTalk as well offer much more flexibility and features. Also it offers significant benefit the previous rage adapter and introduce a range of new capabilities that overdue in realm of database interaction.
Well, I'll try to get some time and elaborate this new excellent chunk of Server 2009.