Easy and powerful column mapping capabilities
Map columns between external data record fields and SharePoint list columns to ensure that information is synced accurately.
Filter external data by SQL statement
An SQL query can be created to refine a search and bring back the desired targeted data.
Update data automatically by schedule
Data Connector works automatically in the background (via timer job) and updates changes according to a scheduled plan thus always keeping data up-to-date.
External data governance
End users can securely access data from SharePoint list after connecting to the external data source. Users can then create, read, update and delete external data from SharePoint list.
Create a new list from external data
A new SharePoint list (including the column name and column type) can be automatically created when connecting to an external data source, which can be created and mapped as per your needs.
Centralized control panel
Access and manage all Data Connector jobs from one central location without entering each site or list individually to configure the settings.
Log and track errors
Administrator can track and record errors by setting a log schedule or by enabling email notification so that they will be notified whenever an error occurs during background updates.
Product Features
- Supports connection to multiple external data sources incl. Microsoft SQL Server 2000-2014, Oracle Database and MySQL 5.0 Database, SharePoint 2007/2010/2013/2016/2019
- Map columns between external data record fields and SharePoint list columns
- Filter external data by table or view
- Filter external data by SQL statement
- Update data automatically by customized background update intervals
- Write-back changes from SharePoint list to the external data source
- Automatically create a list from external data
- Centralized management of Data Connector jobs
- Track and record errors by setting a log schedule or by enabling email notification
- Supports Multi-Authentication and SSL enabled sites
- Supports Lookup & People columns
- Supports additional fields related to lookup columns
- All list types are supported
