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)
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.