Replicate and save SharePoint list data to Access, SQL Server, Azure

SharePoint has become the de-facto sharing platform for teams in organizations; storing business and transactional data on lists, document libraries etc. But unlike the ease of reporting and running statistics on relational database, SharePoint on its own does not provide such flexibility when it comes to querying and building reports. Due to this limitation, often, managers might find themselves spending a lot of time and resource in exporting data to spreadsheet and performing manual computation and parsing. Some organizations even use specialized data professionals and a dozen different software packages, just to produce simple reports. Worst, if the report doesn’t have the required information, you will have to start over, wasting precious time.

As there is a time and expense involved in getting answers from SharePoint lists, a lot of business intelligence information often goes unused, due to that fact that, SharePoint is designed to store data, and not to help you analyze it.

Connecting SharePoint to database for seamless export

The AssistMyTeam Database Exporter app for SharePoint is designed to give you a simple and yet powerful tool to let you replicate your SharePoint list data to a relational database for archival or reporting purpose.

In the Database Exporter tool, you can enter the URL of your SharePoint site (e.g.. http://companyweb/) such that it would show up all the available lists in a hierarchical tree from which you can select the particular SharePoint list for replication to relational database. Alternatively, you can also enter the URL of the particular SharePoint list (e.g.. http://companyweb/Lists/Tasks/AllItems.aspx) to directly load the available fields in the grid. With either techniques, you can choose which SharePoint fields to include in the export.

Before you can export a SharePoint list to a relational database, you are required to choose which fields of the list are to be included into the export. You do this by checking the corresponding check-box of the third column ‘Include in Database’. If you want all fields to be included, you can click ‘Select All’ option located at the bottom.

To export the selected SharePoint list with data of chosen field, click ‘Export to Database’. This will pop-up the database option dialog box, where you can choose the database type, name and specify the path and credentials etc.

A snapshot of replicated tables and their corresponding data in MS SQL Server from the SharePoint lists.

Benefits

  • Works with WSS, MOSS, SharePoint 2010, 2013, 2016 and Office 365
  • Support almost all data types used in SharePoint list Choose your own fields for inclusion to the database export
  • Supports export to relational Microsoft databases such as Microsoft Access (MDB)Microsoft SQL Server including Express editions, and Microsoft cloud based Azure SQL
  • No SharePoint list view threshold issues (i.e., limit of 5000 items) .
  • Install on any Windows PC or server, virtual or physical, and does not require any changes to SharePoint. Optimized for Office 365 SharePoint Online.

To get more info about the tool, you can visit – https://www.assistmyteam.com/database-exporter-for-sharePoint/

If you have any questions, please leave a comment below.

Leave a Reply

Your email address will not be published. Required fields are marked *