SharePoint Data Connector

This program enables data import/export between SharePoint lists and databases.

SharePoint Data Connector helps import and export business data between SharePoint list and external data sources such as MS SQL Server, Oracle, MySQL, etc. The connector helps create a secure access to external data from within SharePoint. External data sources could be Microsoft SQL Server, Oracle Database and My SQL, etc. databases that can send/receive data from/to the SharePoint list structure. This tool provides means to optimize many business data processing situations. You could export SharePoint list and library to any external databases used. The SharePoint default user interface then could be used to add and update data in the external database. This tool also provides opportunities to integrate existing applications with SharePoint. All data required by these applications could be made available through these connectors. Multiple data connectors are available that include Microsoft SQL Server 2000-2008 R2, Oracle Database and My SQL 5.0 Database, etc.

Columns between external data record fields and SharePoint list columns can be mapped to ensure that data is accurately synced. Data connectors can be driven by background timer job or manually from the central control panel. Same control panel allows administrators to manage external data import/export profiles. Administrators can collect logs and track errors through email alerts. The log taking can be scheduled. Email notifications can be turned on or off as desired. Setting up and managing the data exchanges are quite easy through the control panel. This is a very good product. If you are looking for a similar solution, you should try it in your exact workflow.

SharePoint Data Connector
Fast and effectively import and export business data between SharePoint list and external data sources.
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 normalized 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 optimization possibilities.
Integrate Existing Applications with SharePoint
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.
Multiple Connectors Available
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.
Easy and Powerful Column Mapping Capabilities
Map columns between external data record fields and SharePoint list columns to ensure that information is synced accurately.
Background Update
Data Connector works automatically in background by timer job or manually through central control panel.Central Control Panel
Administrators can manage external data import/export profiles from a centralized control panel.
Log and Track Errors
As an administrator, 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.