The goal of this blog is to explore Microsoft technologies around ERP and help people see the value and potential of the Microsoft Dynamics platform.
Office 365 offers a compelling and comprehensive set of offerings ranging from email via Exchange, to Lync to SharePoint Online in the Cloud.
This blog post explores some simple ways for you to think about leveraging both SharePoint Online with on premise solution in a “hybrid” model in your organization today.
As we consider using technologies in the Cloud, like Office 365, we also need to think about how they might impact or be impacted by on premise solutions. And seek ways in which they might be logically linked.
I found a nice demo of expense management in Excel 2010 in SharePoint Online and this got me thinking maybe Excel can be part of my on premise solution. Here is the demo http://office.microsoft.com/en-us/office365-sharepoint-online-enterprise-help/video-record-approve-and-manage-employee-expenses-VA102586196.aspx?CTT=5&origin=HA102604631 shows a simple demo/solution in SharePoint Online.
This is a cool demo for sure but it also got me thinking… didn’t we forget something in this demo? Like when/how do we pay the employee for the expense report?
Of course, Dynamics ERP manages AP invoices and pays employee expenses. I want to enable my expense report in the cloud to find its way to my on premise Dynamics ERP.
But how can we get from the online version of SharePoint in Office 365 to my on premise ERP solution? SharePoint Online works in what we call a “sandbox”. This means that there are some limits to the links that can happen in the cloud and calling an on premise web service is not easily supported.
Thus my challenge, leverage Office 365 for its cloud power and find a method to action something on premise.
I solved this dilemma using two simple techniques to “bridge” between SharePoint Online and my Dynamics ERP on premise.
The demo of the above scenarios can be viewed here. http://tinyurl.com/7bdnpnq
As you see with both of these demos, there can be powerful "hybrid" solutions in the cloud with SharePoint Online that can connect to on premise solutions like Dynamics ERP.
In one my next posts, I will cover the technical aspects/details of this demo. Stay tuned for more details.