尝试使用SSIS 2012设置OData连接时出现Forbidden（403）错误 [英] Forbidden (403) error when trying to setup OData connection with SSIS 2012

问题描述

 

我正在尝试设置OData连接以在线从Sharepoint提取Feed。它抛出'远程服务器返回错误：（403）禁止。 （系统）'错误。

'Microsoft Online services Authentification'设置为True。

用户ID： < userlogon> @company .com

Sharepoint网址：  https://xxxx.sharepoint.com/sites/Project/_api/web/lists / ...

<我错过了一些设置吗？能帮忙吗？

谢谢，

Malveka

解决方案

嗨Malveka，

我认为OData组件不支持这个OData实现版本（例如ver 2）或安全通过HTTPS连接。

很多人选择CozyRoc，Kingsway等的第三方连接器。

Hi, 

I am trying to setup OData connection to pull feed from Sharepoint online. It throws 'The remote server returned an error: (403) Forbidden. (System)' error.

'Microsoft Online services Authentification' is set to True.

User ID: <userlogon>@company.com

Sharepoint URL: https://xxxx.sharepoint.com/sites/Project/_api/web/lists/...

am I missing some settings? can you please help?

Thanks,

Malveka

解决方案

Hi Malveka,

I think either the OData component does not support this OData implementation version (e.g. ver 2) or the secure connections over HTTPS.

Many people opt for 3rd party connectors from say CozyRoc, Kingsway, etc.

这篇关于尝试使用SSIS 2012设置OData连接时出现Forbidden（403）错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！