Gravity Data


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

  • Cloud
  • 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
SharePoint Setup Guide

More Connectors To Explore

Any other questions? Get in touch

Get help and updates with
our Slack community

Hi there! We have a thriving Slack community
centralized around data integration. It’s the easiest
way to get help from the community.