使用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)

Identity Client Runtime Library (IDCRL) could not look up the realm information for a federated sign-in. (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 服务文档位置网址应类似于 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.

谢谢 Sharath

Thank you Sharath

使用OData源从SSIS连接到SharePoint

相关推荐