SharePoint Data Source
Microsoft SharePoint is an online collaborative platform based on the cloud that is used by
businesses for several different reasons. Launched in 2001, it integrates with Microsoft Office, and
businesses use it for a range of different reasons – from building and managing document libraries
to creating intranet sites and managing workflow. It allows documents to be shared, lists to be built,
and collaboration between customers, colleagues, and partners.
According to Microsoft, SharePoint is used by over 200,000 organisations – with a total of over 190
million users. There are several different editions of SharePoint, including:
- SharePoint Standard – the basic version based around central factors such as sites,
communities, content, search, and composites.
- SharePoint Server – a server that is installed on the IT infrastructure of the customer,
providing customisation and other features not available on the standard SharePoint
- SharePoint Enterprise – extra features that are not available on the standard platform,
including search thumbnails, business intelligence integration, PowerPivot, Performance
Point, Microsoft Access services, and search extensions.
- SharePoint Online – Microsoft’s hosted SharePoint service, similar to SharePoint Enterprise
but without the same customisation options.
Microsoft’s SharePoint package can create high amounts of data that your business can use for
analytics and making important business decisions. Gravity Data’s ETL or ELT tool can be used to take
the data that is generated by SharePoint and put it into your data warehouse or storage process.
ETL Your SharePoint
Data (such as lists) is often created by the SharePoint platform. It is important that this data can be
sent to your business’s storage process or data warehouse, and Gravity Data’s Extract, Transform,
Load – or Extract, Load, Transform tool provides a secure, easy, and quick way to do this.
SharePoint Use Cases
SharePoint can be used to create sites and share documents for businesses. Some of its use cases
- Connects users to content, apps, and information
- Store and collaborate on files
- Create and manage lists
- Customise content
- Build intranet sites
- Share news and updates amongst other users
- Manage workflows and forms
Features of SharePoint
SharePoint can improve communication and collaboration for a business. Some of its features
- Customisation through application-to-application, extensions, web-parts, and pages/sites
- Integrates with Microsoft Office with OpenXML
- REST, SOAP, and OData interfaces
- Can be accessed through Microsoft 365 or SharePoint Online
- Integration with PowerApps, Power BI and MS Flow, and SharePoint home page
You can find out more about the Microsoft SharePoint platform here.SharePoint ETL - Try it free
Create SharePoint data pipelines
Why use Gravity to build real-time data pipelines with SharePoint
- Simple: No code set-up of your data pipelines for SharePoint
- Secure: Enterprise security and accreditations to keep your data safe
- Reliable: Gravity’s real-time engine supports high throughput of SharePoint and manages failures elegantly to ensure your data arrives at the destination
- Scalable: High volume with autoscaling to support your real-time data pipelines