SharePoint to Database

Export SharePoint lists data to database

An application for Windows to export and replicate SharePoint list data to a Microsoft database format (Access or SQL Server, Azure) for reporting or archival purpose.

Available for a fully functional 30 days trial.

Product Summary

  • Works with WSS, MOSS, SharePoint 2010, 2013, 2016, 2019 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.
  • Special MSI installer available for enterprise wide deployment (upon request)
THE PROBLEM

No relational database like reporting in SharePoint

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.

THE SOLUTION

SharePoint to Database Export tool

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. It is with this requirement in mind, that we have designed Database Exporter for SharePoint, 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.

how it works

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 technique, 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 checkbox 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 fields, 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.

0
With over 2000+ customers across 50 countries including fortune 500 companies, government and non-profit agencies, freelance consultants, educational institutions and universities, etc.

What people are saying?

We found your product to be an excellent way to streamline the e-mail and Sharepoint solutions together into one system that will provide faster and more efficient support to our stakeholders as well as leverage existing technologies already in place. It has also allowed us to reduce the management load of our server technician by removing an existing server that handles current helpdesk software saving on hardware costs and simplfying our server environment. Your products most certainly have an indirect impact on student success by making the IT professionals that support IT operations at the college more efficient and effective. Thank you.
Andy Anderson
Jefferson Community and Technical College (KCTCS), Kentucky