Extracting data from SharePoint 2019 in SSIS using SAML Authentication

tobz 161 Reputation points
2022-04-25T14:30:43.777+00:00

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
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,714 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
9,628 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,453 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Yi Lu_MSFT 17,456 Reputation points
    2022-04-27T02:37:05.217+00:00

    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