从SP 2013中提取数据的最佳方式 [英] Best way to extract data from SP 2013

问题描述

大家好，

我们有SharePoint Services 3.0和SQL-SERVER 2005，我们正在使用SSIS提取SP数据以上传到Oracle数据库，数据仓库。

现在，我们计划将SharePoint升级到2013年，可能还有SQL 2012.根据我们的SharePoint管理员，我们无法使用SSIS从SharePoint 2013中提取数据（许可协议或其他）。

请告诉我从SharePoint 2013获取数据的最佳方法是什么？之前有人可能会问过同样的问题，我很抱歉再次重复这个问题。我在论坛中进行了搜索，但
返回的线程太多了。

谢谢

解决方案

使用SharePoint API，无论是服务器端对象模型，REST API等，都是实现从另一个系统中拉出SharePoint数据的最佳方法。 BR />

Hi All,

We have SharePoint Services 3.0 with SQL-SERVER 2005, and we are using SSIS to extract SP data to upload to Oracle database, data warehouse.

Now, we have plan to upgrade SharePoint to 2013 and probably SQL 2012. According to our SharePoint admin, we can’t use SSIS to pull data from SharePoint 2013 (license agreement or whatever).

Would please tell me what is the best way to get data out from SharePoint 2013? Someone probably asked the same question before and I apologize to repeat the question again. I did a search in the forum, but too many threads returned.

thanks

解决方案

Using a SharePoint API, be it Server Side Object Model, REST API, etc. is the best way to accomplish pulling data out of SharePoint for another system.

这篇关于从SP 2013中提取数据的最佳方式的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！