SharePoint Data Connector provides a convenient and secure way to access external data completely within SharePoint. SharePoint Data Connector brings business data from other systems, such as, Microsoft SQL Server, Oracle Database and My SQL, etc. into the SharePoint list structure.
Additionally, this solution allows you to export SharePoint list and library in SharePoint as a set of normalised tables to any external database or you can use SharePoint as the default user interface to update or add to your external data.
This lightweight out-of-the-box solution provides many business data processing optimisation possibilities.
Data Connector can import data to SharePoint list from multiple external data sources or export SharePoint list to external data. It is a perfect solution to integrate existing applications from different systems with SharePoint.
The SharePoint Data Connector supports multiple popular connectors such as, Microsoft SQL Server 2000-2008 R2, Oracle Database and My SQL 5.0 Database, etc. More options will be available in the future.
Map columns between external data record fields and SharePoint list columns to ensure that information is synced accurately.
Data Connector works automatically in the background by timer job or manually through a central control panel.
Administrators can manage external data import/export profiles from a centralised control panel.
As an administrator, you can track and record errors by setting a log schedule or by enabling Email notification, so that you will be notified whenever an error occurred during background updates.