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.
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.