Hi - can anyone advise on how to connect Microsoft SSIS to sharepoint online in the NHS tenant ? I suspect we need an OAUTH2 connection. Do we need to request an azure App registration from Accenture/ NHS support for this ?
Any help appreciated.
Hi Greg,
This is not our area of expertise - but my understanding is that as NHS SharePoint Online sits behind Entra ID (Azure AD) authentication — and basic auth no longer works — SSIS must authenticate using OAuth2 via an Azure App Registration.
You will need an Azure App Registration and it must be created by the NHS Azure/M365 platform team (Accenture). SSIS will authenticate using Client ID + Client Secret following which SSIS will call SharePoint using either:
• HTTP Client with OAuth2 Token
• a custom connector / script task
• or a third-party SSIS component
Hope the above helps.
Thanks,
NHS England API Platform team
Please note: The API Platform team can only address queries relevant to the NHS England API platform, including security, rate limiting, logging, monitoring and alerting. For any API specific queries, please reach out the relevant API teams.