使用 OData 源从 SSIS 连接到 SharePoint

我正在尝试使用 OData 源连接到托管在 Microsoft 云上的 SharePoint.我正在尝试将与项目相关的数据从 SharePoint 列表中提取到 sql 表中,并将其处理到数据仓库中.

I am trying to connect to SharePoint hosted on the Microsoft cloud using the OData source. I am trying to pull the Project related data into the sql table from the SharePoint list and process it into the data warehouse.

当我手动登录 SharePoint 时,它已获得读取数据并导出到 excel 的必要权限.但是当我在 2012 年通过 Odata Source 连接时,我遇到了以下错误.我正在使用 Visual Studio Professional 2015 进行 SSIS 开发.

When I manually login into the SharePoint ,it has got the necessary permissions to read the data and export into excel. But when I connect through the Odata Source in 2012, I encounter the below error. I am using the visual studio Professional 2015 for the SSIS development.

身份客户端运行时库 (IDCRL) 无法查找联合登录的领域信息.(Microsoft.SqlServer.IntegrationServices.ODataConnectionManager)

你们中有人遇到过这个问题吗?

Has any one of you encountered this issue any time?

推荐答案

我能够使用 32 位 OData 源组件将列表数据从 sharepoint 下载到 SQL.诀窍是使用后缀/_vti_bin/listdata.svc".

I was able to download the list data from sharepoint to SQL using the 32 bit OData source component.The trick is to use the suffix "/_vti_bin/listdata.svc".

例如:如果您的列表数据 URL 是:https://sharepoint.com/sales服务文档位置 URL 应如下所示https://sharepoint.com/Sales/_vti_bin/listdata.svc.同时在连接管理器设置中启用 Microsoft Online Services Authentication=True.

For Ex: If your URL for the List data is :https://sharepoint.com/sales the service document location URL should look like https://sharepoint.com/Sales/_vti_bin/listdata.svc. Also Enable the Microsoft Online Services Authentication=True in the Connection manager settings.

谢谢莎拉特

相关文章