Home | Products | Support | Subscriptions | About | Contact


PRODUCT OVERVIEW
An application for Windows that makes it very easy and effortless to export and replicate SharePoint list data to a Microsoft database format for reporting or archival purpose.
 
Database Exporter tool for SharePoint enables you to bring the contents of any SharePoint list to an external Microsoft database such as Access, SQL Server or Azure. You can selectively specify which fields to include in the export, and the appropriate data type will be inherited in the relational database.

Highlights:  (Latest version: v1.1 released on 23rd April 2018 - release note)
 

bullet

Works with WSS1, MOSS2, SharePoint 2010, 2013, 2016 and Office 365

bullet

Support almost all data types used in SharePoint list

bullet

Choose your own fields for inclusion to the database export

bullet

Supports export to relational Microsoft databases such as
Microsoft Access (MDB)
Microsoft SQL Server including Express editions, and
Microsoft cloud based Azure SQL

bullet

No SharePoint list view threshold issues (i.e., limit of  5000 items) .

bullet

Install on any Windows PC or server, virtual or physical, and does not require any changes to SharePoint.

bullet

Optimized for Office 365 SharePoint Online.

bullet

Special MSI installer available for enterprise wide deployment (upon request)
 

1Microsoft Windows SharePoint Services
2Microsoft Office SharePoint Server

 

 

Have any questions? Email us: support@assistmyteam.net

 

30 days trial


Download brochures (PDF)

New Page 1
Subscription License is valid for the subscribed term only. Technical assistance and upgrades are free for the subscribed term
Perpetual License is valid life-time. However, technical assistance and free upgrades are bound to the validity of the Support and Maintenance Contract
 

Free license for Academic Institutions (Schools, Colleges and Universities) - Learn More...
50% discount for non-profit, non-academic organizations (e.g., Charitable trusts, hospitals,). Learn More...

 

Purpose of this tool


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. 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 does it work?


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 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.


Similar and related products from AssistMyTeam:
bullet Database Exporter for Microsoft® Outlook®
 
   
Copyright © 2018 AssistMyTeam. All rights reserved.
ENTERPRISE LICENSING | SERVICES | KNOWLEDGE BASE | BLOG | FREE LICENSE | ABOUT
 
 

Works with
   

 

Looking for replicating Outlook emails or appointments to a relational database?

Try
Database Exporter
for Microsoft Outlook

Export your Outlook folder data such as emails, appointments, tasks or contacts to a relational database such as SQL Server, Azure or Access for reporting or archival purpose.

 

 

latest news from
bahrurBlog
OLAP & BI tool to analyze Microsoft SQL Server, Azure and Access database
Over the decade, businesses and organizations had accumulated a sea of data. However gaining insight from all this information has been challenging for most. Companies need to translate data into information to plan for future strategies... (22nd Mar'18)
 
Leverage Outlook for employee timesheet collection, payroll and billing
For many managers, the collection and processing of timesheets can be a slow and labor intensive work. And employees hate to fill out timesheets – a common universal fact which makes supervisors and managers constantly struggle to adopt an effective and accurate time tracking in the organization... (22nd Mar'18)
 
Turn Outlook into a Knowledge Base with Exchange Folders
Technology is driving and transforming business every day, but the ultimate goal is all about maximizing knowledge wealth and enhancing human intelligence. And for any organization, this acquired intelligence is the... (22nd Mar'18)
 

 
Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.