Microsoft Deprecating of Basic authentication in Exchange Online Affecting OData Connector Microsoft Online Services Authentication Type

Question

Hello,

Microsoft is Disabling Basic Authentication against Exchange Online services starting October 1st (see following links). We are using Odata connector with Microsoft Online Services Authentication type to load data from SharepointOnline to SQL Server. Anyone know if the deprecation of Basic Authentication is going to affect how I use the OData connector with the Microsoft Online Services Authentication type? Is that considered Modern Authentication or how is that different than Basic authentication? Please advise.

Thank you

https://learn.microsoft.com/en-us/exchange/clients-and-mobile-in-exchange-online/disable-basic-authentication-in-exchange-online?source=recommendations
https://learn.microsoft.com/en-us/exchange/clients-and-mobile-in-exchange-online/deprecation-of-basic-authentication-exchange-online

Answer 1

Hi @Michael Jiang ,

As per my knowledge, the deprecation of Basic Authentication will not affect the OData connector with the Microsoft Online Services Authentication type.

Basic authentication is also known as HTTP authentication. HTTP provides a general framework for access control and authentication. To connect to SharePoint Online, you need to use Microsoft Online Services Authentication.

Reference: Connection Manager Authentication.

----------

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.