Difference between BizTalk Oracle Adapters
(or)Compare and contrast between different BizTalk Oracle Adapters
(or)
Difference between Microsoft BizTalk Oracle Adapter ,Microsoft BizTalk WCF Adapter and TopXml Adapter for Databases
| Microsoft BizTalk Oracle Adapter |
Microsoft
BizTalk WCF Adapter
|
TopXml
Adapter for Databases
|
BizTalk
Server support version:
BizTalk
Server 2006 |
BizTalk
Server support version:
BizTalk
Server 2006 R2 |
BizTalk
Server support version:
BizTalk
Server 2004/2006 |
Access:
ODBC
driver to connect to DB |
Access:
Oracle
Adapter for .NET (ODP.NET) |
Access:
Oracle
Adapter for .NET (ODP.NET) |
Processing:
Supports
“PollingQuery” and “TableChangedEvent”
|
Processing:
Single
Polling mechanism that provides the following features:
·
Generate strongly typed schema based on a SELECT statement
·
Specify Post-Poll statements to be executed after a polling event
·
Poll and Post-Poll statements executed in a Transaction context
·
Specify Transaction Isolation level
·
Poll, Post-Poll and transaction levels can be specified with
binding properties
|
Processing:
Generation
of BizTalk schemas based on SQL statements, Stored Procedures (in,
out, return parameters), multiple tables
·
Periodic polling of data source
·
Oracle alerts (send and receive) can send asynchronous
notifications based on some events. Uses DBMS_ALERTS oracle
package.
·
Oracle Receiver can be configured to receive alerts and Oracle
Sender can send alerts to data source.
·
Oracle Pipes allow inter-process communications with Oracle
sessions
|
IDE
Integration:
Standard
integration |
IDE
Integration:
Enhanced
integration at design time between BizTalk and Visual Studio that
provide the following features:
·
Standardized GUI for browsing, searching and retrieving LOB
artificats
·
Design-time enhancements for browsing stored procedures, functions
and packages (categorized and hierarchical manner)
|
IDE
Integration:
Redesigned
and developed in C#.NET that provides tight integration with
BizTalk Adapter framework
·
Generate schemas based on stored procedures and also Select,
Insert, Update, Delete and InsertUpdate statements on tables and
views
|
Programming
Interface:
Standard
XML schema messages
|
Programming
Interface:
Exposes
WCF Programming interfaces that provide WCF channel, WCF service
model and web service model
|
Programming
Interface:
Schema
generation capabilities that allow importing database schema from
the underlying data provides into the orchestrations.
·
Uses Enterprise Instrumentation framework for tracing and logging
|
Transactions:
·
Not Supported |
Transactions:
·
Supports WCF mode Transactions for Outbound and Inbound |
Transactions:
Supports
Transactions and Transaction Isolation levels |
Additional
Features:
·
Not Supported
|
Additional
Features:
·
Supports IN, OUT, INOUT REFCURSORS with strongly typed and weakly
typed variants
·
Supports BLOB, CLOB, BFILE types in tables and stored procedures
with streaming capabilities
·
Enhancing on top of ODP.NET, the WCF-based Oracle DB adapter
supports RECORD type parameters in stored procedures/functions
even though these types are not natively supported by ODP.NET
(version 10.2.0.20)
|
Additional
Features:
·
Supports various Data sources such as IBM DB2, SyBase, MySQL etc
·
Extendable Data Providers
|
Support
and Licensing:
·
Depends on licensing agreement with Microsoft
|
Support
and Licensing:
·
Depends on licensing agreement with Microsoft
|
Support
and Licensing:
·
Additional pricing and licensing model
·
Online Support
|
No comments:
Post a Comment