I need to call a stored procedure in Oracle from an orchestration. I am running BizTalk 2006 (not R2). Which way is best? Are there others?
- BizTalk Adapters for Enterprise Applications
- BizTalk LOB Adapters
Thanks in advance.
views:
78answers:
1
+4
A:
There is an Oracle Adapter from the code project:
http://www.codeproject.com/KB/biztalk/BizTalk%5FOracle%5Fadapter.aspx
There is also a good blog post on it here:
http://seroter.wordpress.com/2007/03/12/a-walk-through-the-biztalk-2006-oracle-adapter/
Shiraz Bhaiji
2009-10-07 14:54:57
Interesting. We're trying to stay on the supported portions of the MS Platform, hence the reference to the two MS provided options. What would drive you to the CodeProject's adapter versus the ones I mentioned in the original post?
ChrisLoris
2009-10-08 13:39:35
Generally we also stay on the MS platform, but you asked for an alternative. Main reason for using Open Source vs. MS, is that with MS if you are stuck then you are stuck. If you use Open Source you have the "possibility" of going into the code and fixing it.
Shiraz Bhaiji
2009-10-08 14:05:09