Extracting data from SharePoint 2019 in SSIS using SAML Authentication

tobz 161 Reputation points

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.


SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
9,800 questions
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
7,073 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,080 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Yi Lu_MSFT 17,271 Reputation points

    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.

    0 comments No comments