Data Connector - Sync data from multiple external data sources to SharePoint, and vice versa.

Connect to External Data Sources

Import data from a variety of external data sources to a SharePoint list, including:

  • Microsoft SQL Server 2000-2019
  • Oracle Database
  • MySQL 5.0 Database
  • SharePoint 2010/2013/2016/2019
  • Always Keep Data Up-to-Date

    Data Connector works automatically in the background (via timer) and updates changes according to a scheduled plan thus always keeping data updated.

    External Data Governance

    End users can securely access data from SharePoint list after connecting to an external data source, then be able to add, read, update and delete external data from SharePoint list. Even better, any changes made in SharePoint can be written back to external data sources.

    Filter External Data

    Filter data from an external data source by table/view or SQL statement, ensuring that only the desired targeted data is shown.

    Excel Import - Import data from excel spreadsheet to any SharePoint list with column mapping capability.

    Import Excel Data to SharePoint

    Easily import data from Excel spreadsheets to a SharePoint List in just three steps: navigate to a list, upload a spreadsheet and click Import button.

    Auto-Import Spreadsheets by Schedule

    Create and schedule an import job to automatically import spreadsheets into any SharePoint list using Excel spreadsheet stored on a remote file share server, such as FTP or document library (incl. Office 365).

    Map Fields between SharePoint and Excel

    Select and map Excel headers to any SharePoint fields before importing the Excel spreadsheet to SharePoint, ensuring that the right information is quickly and accurately inserted in the right place.

    Create a List from an Excel Spreadsheet

    With SharePoint Excel Import, you can create a new list from an Excel spreadsheet with the field mapping function and even customize column names and column types as per your needs.

    Import Sheets in Succession

    Continuously import sheets from one Excel file into a SharePoint list without any repetitive configuration, the saved import settings accelerate the import process.

    List Sync- Manually or automatically sync items between two or more lists.

    Bidirectional Sync between Two Lists

    Manually or automatically sync data or data changes between two lists. Real-time synchronization happens when documents or items are created, modified, deleted, checked in or approved.

    Sync Specific Items Using Condition

    Filter items to sync based on preset conditions so that only those columns or data that meet the criteria will be synchronized.

    Sync Accurately via Column Mapping

    Build connections between lists using column mapping. This also guarantees an effective and accurate synchronization. You can conveniently add or delete a mapping.

    Aggregate Column Data from Different Lists

    Two or more lists can be connected with a lookup column. This combines relevant column data from different lists so you can work with one aggregated list.

    Sync Efficiently with More Options

    You can sync permissions, attachments with item, even better, users can choose if the items in target or source list should be deleted during synching.

    List Transfer - Copy/move documents or items between to lists or document libraries.

    Bulk Copy/Move Documents or Items

    Bulk copy or move documents, items, folders and pictures between libraries and lists. Users also can easily copy or move files via the virtual clipboard, these hotkeys are supported:

  • Copy: Ctrl-Shift-C
  • Cut: Ctrl-Shift-X (Cut)
  • Paste: Ctrl-Shift-V (Paste)
  • Prevent Data Loss via Column Mapping

    With column mapping, metadata can be transferred safely to a destination library or list and all column types are supported for mapping.

    Preserve Information during transfer

    Permissions, version history, attachments and authors and timestamps can be preserved during the transfer.

    Duplicate Documents or Items

    The duplicate function allows for efficient item or document creation. Just duplicate an existing item or document and change the column values as needed. Even better, you can duplicate items/documents in bulk.

    Control Access to Copy and Move Functions

    For security concerns, you can specify who can use the Copy and Move functions, assign permissions to specific users or block specific users from using these functions.

    Real Time Web Analytics