question

Tobz avatar image
0 Votes"
Tobz asked YiLu-MSFT answered

Extracting data from SharePoint 2019 in SSIS using SAML Authentication

Hi everyone,

I am trying to pull data from SharePoint 2019 using the OData data source component in SSIS but I keep getting this error:


Test connection failed



The remote server returned an error: (400) Bad Request. (System)


Program Location:

at System.Net.HttpWebRequest.GetResponse()
at Microsoft.SqlServer.IntegrationServices.OData.UI.ODataConnectionManagerForm.TestConnectionMiddle(Object callback)


From my understanding the OData Source does not work well with SAML authentication in SharePoint 2019.

Please I need help on how else I can pull the data in SSIS without paying for a third party tool.

Regards,

sql-server-generaloffice-sharepoint-onlinesql-server-integration-services
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

I am currently looking into this issue and will give you an update as soon as possible.

Thank you for your understanding and support.

0 Votes 0 ·

1 Answer

YiLu-MSFT avatar image
0 Votes"
YiLu-MSFT answered

Hi @Tobz
FBA(SAML authentication) in SharePoint is not supported for SSIS. There is no OOB way to achieve it. You could consider using Windows Authentication instead if possible.


If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.