BoostSolutions

Connect SharePoint to any external data sources

CONNECT TO EXTERNAL DATA SOURCES

Easily import data from a variety of external data sources to a SharePoint list without using code, making it convenient to access and analyze business data on SharePoint. External data sources include:

  • Microsoft SQL Server 2000-2019
  • Oracle Database
  • MySQL 5.0 Database
  • SharePoint 2007/2010/2013/2016/2019/Subscription Edition
    • Automatically sync data by minutes, daily or weekly based on a schedule.

    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.

    Select the operations (add, update and delete) that you want to performance on the data.

    EXTERNAL DATA GOVERNANCE

    End users can securely access data from SharePoint list after connecting to an external data source. Users can then add, read, update and delete external data from SharePoint list.

    Filter data from external data sources by table/view or a SQL clause.

    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.

    Additional features to help you sync data easily:
    two way sync data

    BI-DIRECTIONAL CONNECTION

    Changes made in SharePoint list can be written back to external data sources, keeping data consistent.

    map columns between external data fields and SharePoint list columns

    COLUMN MAPPING CAPABILITY

    Map columns between external data record fields and SharePoint list columns to ensure that information is synced accurately.

    Create a new list when connecting to an external data source.

    CREATE A NEW LIST FROM EXTERNAL DATA

    A new SharePoint list (including column name and column type) can be automatically created when connecting to an external data source for the first time; this can be created and mapped according to your needs.

    Record sync activities

    LOG AND TRACK ERRORS

    Track and record errors by setting a log schedule or by enabling email notification so users are notified whenever an error occurs during background updates.

    A central place to manage all Data Connector jobs.

    CENTRALIZED CONTROL PANEL

    Access and manage all Data Connector jobs from one central location without entering each site or list individually to configure settings.

    Import data from external data source to any SharePoint list.

    SUPPORTS ALL LIST TYPES

    Import data from external data sources to any SharePoint lists, such as Contacts, Task, custom lists and more.

    Related Products

    Excel Import

    Import Excel spreadsheet to any existing SharePoint list and map fields!

    Business Charts

    Create powerful charts, quickly and easily. Formidably improve data analysis and decision making.

    List Collection

    Roll up pertinent list items from multiple lists across a SharePoint site collection into a single, auto-updating data view.

    List Sync 

    Combine different lists into one. Break down large lists into different ones based on conditional criteria.
    Real Time Web Analytics