Resources for IT Professionals >
Forums Home
>
BizTalk Server Forums
>
BizTalk Server General
>
MOSS Integration using BizTalk
MOSS Integration using BizTalk
- Hi,
I am using BizTalk server 2006 R2 to integrate MOSS with SAP. Requirement is to show some SAP data in MOSS UI when user logs onto MOSS. User can also create some action (ex. approve/reject) from MOSS screen which needs to be passed on to SAP. I want to know what is the best way for integration in this scenario?
Communication between BTS and SAP
---------------------------------------------
I am plannig to use sap-wcf adpater for communication between BTS and SAP (call RFCs using these adpaters)
Communication between MOSS and BTS
----------------------------------------------
I can think of two options
- expose bts orchestration as web services / wcf services and MOSS will call these services to get real time data from SAP
- use WSS Adapter - is this suggested for real time integration? (user logging onto MOSS screen should see real time SAP data)
Any suggestions on this would be helpful.
Answers
- I do a lot of BizTalk, InfoPath, SharePoint (BIS) and I think it's awesome. It's actually meant to scale quite a bit and because it's all asynchronous you can get higher throughput and better reliability from such solutions. The main issue is to have the approval happen in a form library and have the action take place in BizTalk (the WCF-SAP calls). Personally even to display data in sharepoint I often use InfoPath forms. They're pretty easy to make, look good, and work well with the SharePoint and BizTalk paradigms.
If I needed to show some live data and promot for approval I would have an InfoPath form that calls a web service exposed by BizTalk (which calls SAP) when the form loads. I would then have the form save and approve / reject in sharepoint. You can also add BAM to the solution to show who approved what and when. This is really good for auditing because the audit is outside of sharepoint (there is no way users can fake it).
If you'd like more info let me know. I admit I didn't understand the documentation too well at first, but once you get it the BIS is great stuff. If you have SharePoint Forms Services you can even make your Forms browser compatible and not need InfoPath on the desktops.
Kind Regards,
-Dan- Marked As Answer bySickOfIT Wednesday, November 04, 2009 7:25 AM
All Replies
- For communication B/W SAP and BTS you can use SAP-WCF adapter.
You can design your process in BizTalk to retreive data from SAP and expose it as a WCF/Web service and MOSS can call this service and display data at real time.
Abdul Rafay http://abdulrafaysbiztalk.wordpress.com/ Please mark this as answer if it helps - I do a lot of BizTalk, InfoPath, SharePoint (BIS) and I think it's awesome. It's actually meant to scale quite a bit and because it's all asynchronous you can get higher throughput and better reliability from such solutions. The main issue is to have the approval happen in a form library and have the action take place in BizTalk (the WCF-SAP calls). Personally even to display data in sharepoint I often use InfoPath forms. They're pretty easy to make, look good, and work well with the SharePoint and BizTalk paradigms.
If I needed to show some live data and promot for approval I would have an InfoPath form that calls a web service exposed by BizTalk (which calls SAP) when the form loads. I would then have the form save and approve / reject in sharepoint. You can also add BAM to the solution to show who approved what and when. This is really good for auditing because the audit is outside of sharepoint (there is no way users can fake it).
If you'd like more info let me know. I admit I didn't understand the documentation too well at first, but once you get it the BIS is great stuff. If you have SharePoint Forms Services you can even make your Forms browser compatible and not need InfoPath on the desktops.
Kind Regards,
-Dan- Marked As Answer bySickOfIT Wednesday, November 04, 2009 7:25 AM
