Integrate Mule ESB with Microsoft Office365 SharePoint August 31, 2015
by Sanjeet Pandey
ESB , Mule ESB , SOA
No Comment
Overview MuleSoft provides the most widely used integration platform to connect any application, data service or an API, across the cloud and onpremise continuum. Microsoft Office365 SharePoint is a cloudbased Content management infrastructure that is accessible to the user programmatically via a MuleSoft ‘Microsoft Service Bus’ connector. SharePoint Online is a cloudbased service that helps organisations share and collaborate with colleagues, partners, and customers. With SharePoint Online, we can access internal sites, documents, and other information from anywhere—at the office, at home, or from a mobile device. The Microsoft SharePoint Mule connector allows developers to access any amount of data, at any time and from anywhere on the web. With connectivity to the Microsoft SharePoint API, users can interface SharePoint to perform CRUD operations on documents and use data with other SharePoint services. Applications can also be built for which internet storage is required – all from within MuleSoft Anypoint Platform. Instant access to the Microsoft SharePoint API enables businesses to create seamless integration between SharePoint and other databases, CMS applications such as Drupal, and CRM applications such as Salesforce.
Prerequisites 1. Microsoft Office365 SharePoint Account 2. Microsoft Office365 SharePoint Host , User Name and Password 3. Mule Anypoint Microsoft SharePoint 2013 Connector
Microsoft Office365 SharePoint Account To complete this sample, we need an MS Office365 SharePoint account. We can sign
up for a free trial.
Add and Manage Users SharePoint Online has a fullfeatured framework for adding and managing user identities and establishing granular administrative models. We should choose the first option for adding new users in the Users section of the Admin Overview page.
Mule Anypoint Microsoft SharePoint Connector SharePoint is a web application platform for content and document management, intranet portals, collaboration, extranets, websites, and enterprise search. Mule SharePoint connector enables integrating with SharePoint and provides following methods – CRUD for Documents CRUD for Document Library CRUD for Users Configure Mule Anypoint Microsoft SharePoint connector with the following settings – Configuration:(MS SharePoint connector configured using the config element) This element must be placed out of flow and at the root of the Mule application. We
can create as many configurations deemed necessary as long as each carries its own name. Connection Pool: SharePoint connector offers automatic connection management via the use of a connection pool. This pool will act a storage mechanism for all the connections that are inuse by the user of this connector. Prior to the execution of a processor, the connector will attempt to lookup for an already established connection and if one doesn’t exist, it will create one. This lookup mechanism is done in the connection pool via the use of connection variables declared as keys. Reconnection Strategy:Reconnection Strategies specify on how a connector behaves when the connection fails. We can control the attempts by Mule to reconnect using several criteria – Type of exception Number and frequency of reconnection attempts Notifications generated With a reconnection strategy, the behaviour of a failed connection can be controlled in a much better way by configuring it, for example, to reattempt the connection only once every 15 minutes, and to give up after 30 attempts. An automatic notification can be sent to the IT administrator whenever this reconnection strategy goes into effect. A strategy can also be defined which attempts to reconnect only during business hours. Such a setting can prove useful if the server is frequently shut down for maintenance.
Mule ESB – The best way to Integrate Microsoft SharePoint The below Mule application is used to create folder under Microsoft Office365 SharePoint using Mule Anypoint Microsoft SharePoint connector.
Steps to be followed for integrating ‘Microsoft Office365 SharePoint’ with MuleSoft Applications: 1. Install the Microsoft SharePoint Connector in Anypoint Studio (3.5 and above)http://repository.mulesoft.org/connectors/releases/3.5 2. Create a new Anypoint Studio Project and Flow. 3. Before using the Microsoft SharePoint Connector in the Mule Flows, create a global element for ‘Microsoft_SharePoint_2013__Online_Connection’ configuration which can be reused in all other flows across the Mule project – wherever the objects are created & deleted to and from Microsoft SharePoint. 4. Configure the ‘Microsoft SharePoint’ connector by providing the following information for the global element User Name Password Site Url 5. Use HTTP inbound endpoint to hit the service and to crteate folder in the Microsoft Office365 SharePoint. 6. Configure the Microsoft SharePoint endpoint by providing the following to create folder in the SharePoint document library – Link to the ‘global Connector Configuration’ Operation name
Running the Application We are now ready to run the project! First, let us test run the application from Studio: 1. Rightclick on the application in the Package Explorer pane. 2. Select Run As > Mule Application: 3. Start a browser and go to http://localhost:8081/createFolder 4. The success response should be returned in case of successfully creation of folder under SharePoint document library. Folder creation under MS SharePoint –
Benefits
No pointtopoint integration required Seamless integration running in the background Quick data synchronization between Microsoft SharePoint with an onpremise and cloud (Office365) based applications Facilitate applications with Microsoft SharePoint capacities for large volume data storage Store applications data and can be rolled back during disaster recovery Bidirectional data communication between applications and Microsoft SharePoint Highly scalable, it secures a solution for backing up and archiving your critical data Send event notifications when objects are uploaded to Microsoft SharePoint Access any amount of data, at any time, from anywhere on the web Author: Mr. Sanjeet Pandey is a Masters of Computer Application (MCA) graduate having 5+ years of experience as a Technical Specialist with WHISHWORKS. He has varied experience in ESB’s like Mule, JCaps. Sanjeet loves dreaming up new ideas, movies & music, photography & travelling and developing web projects. To know more about Sanjeet log on to www.sanjeetpandey.com