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:
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. Users can then add, read, update and delete external data from SharePoint list.
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.
Changes made in SharePoint list can be written back to external data sources, keeping data consistent.
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 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.
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.
CENTRALIZED CONTROL PANEL
Access and manage all Data Connector jobs from one central location without entering each site or list individually to configure settings.
SUPPORTS ALL LIST TYPES
Import data from external data sources to any SharePoint lists, such as Contacts, Task, custom lists and more.
Create powerful charts, quickly and easily. Formidably improve data analysis and decision making.
Roll up pertinent list items from multiple lists across a SharePoint site collection into a single, auto-updating data view.