Perhaps you have Microsoft Office 365 and you are thinking of purchasing Microsoft Dynamics GP. They are both from Microsoft, but can they be used together? Can a cloud application talk to an on-premise application?
In this post, “
Just as a refesher, Office 365 offers a range of services from to email via Exchange, to Lync to SharePoint Online in the Cloud.
It all started when John saw a simple demo of
He solves this dilemma with two simple techniques to “bridge” between SharePoint Online and his Dynamics ERP on premise. According to his post:
- The first technique is to use Excel both as a tool to complete the expense report in the cloud and as well as a conduit to my intranet. Once I open an Excel workbook from SharePoint Online on my local machine, I now have access to resources behind the firewall, thus providing an easy and secure way to access to local resources like a web service that can link to my on premise Dynamics ERP without all the complexity of the sandbox Silverlight callouts. Basically thru bringing the document and data on premise thru Excel.
- The second technique is to leverage SharePoint Online workflow and email integration. By triggering a SharePoint Online workflow via a task approval event in SharePoint Online I can have workflow send email to an on premise process or folder in a SharePoint on premise server that enables me to action the expense report at a data level where information like Vendor Id, Document Number, Invoice Amount can move from the spreadsheet to/thru a process to a web service that handles the create/post to Dynamics ERP. This technique uses the DIP (Office Document Information Panel) to move values from Excel into SharePoint Online.
Pretty cool stuff John! If you are a New England company looking to integrate Office 365, SharePoint Online with Microsoft Dynamics GP,
By Anya Ciecierski, CAL Business Solutions,