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-2014
Oracle Database
MySQL 5.0 Database
SharePoint 2010/2013/2016


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.




Product Features


Supports connection to multiple external data sources incl. Microsoft SQL Server 2000-2014, Oracle Database and MySQL 5.0 Database, SharePoint 2010/2013/2016


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 and libraries are supported


Supported Environments


Microsoft SharePoint Foundation 2010


Microsoft SharePoint Server 2010


Microsoft SharePoint Foundation 2013


Microsoft SharePoint Server 2013


Microsoft SharePoint Server 2016


Supported Browsers


Microsoft Internet Explorer 8/9/10


Mozilla Firefox supported


Google Chrome supported


Supported Languages


English, Japanese, German6

Specifications
Compatible with SharePoint 2016, SharePoint 2013, SharePoint 2010
Languages English, German, Japanese
Latest Version 2.12.1028.0
Latest Release Date Oct. 28, 2016

SharePoint Data Connector


Purchase License:


Tags: Data Connector