Need to import external data to SharePoint list and export Sharepoint list to SQL, Orcale, or MySQL?
there are three methods that one can use to import external data sources to SharePoint lists:
1. The first method provided by Microsoft.But it is aware that there is
no OLEDB provider for SharePoint, or at least there was no easy way
prior to SharePoint 2007. But if you use SharePoint 2010 or higher you
have an option to use PowerPivot for SharePoint.Another restriction is
that data sources are limited.
2. The second is to develope code. This method requires IT departments
to write programs or code that is then utilized in SharePoint to import
external date. Surely, it need take time to develop and test the code.if
the code is too long or complicated it can quickly become unusable,
unstable, full of bugs, etc;
3. The third one: using Data Connector by SharePoint Boost. This
sharepoint web part provides provides a convenient and secure way to
access external data completely within SharePoint such as sharepoint list to sql
Including sharepoint sql server connection, SharePoint Data Connector
also support data connection among sharepoint and other systems, such
as, Oracle Database and My SQL, etc. 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.