OAC with OFFICE365 SMTP

Amit Garg-Oracle

Hello,

Wanted to know if latest version of OAC supports OFFICE365 SMTP server. Any pre-requisites, known limitations that we need to be aware of.

Regards,

Amit

Gianni Ceresa

Isn't the Office 365 SMTP requiring an OAuth2 authentication? If it does, then no, not supported so far (not that I did look if the config screen changed, but nothing has been said about this in the list of new features of the March 2023 release).

If your SMTP doesn't use OAuth2 but standard authentication (over SSL), it should just work fine.

Gianni Ceresa

You mean SSL certificates?

My guess is that if they are signed by publicly recognized authorities, it should be good.

A doc says:

In most cases, you don’t need to provide a compatible certificate as most mail servers can use the default certificate, including Office 365.

GayathriAnand-Oracle

Please see the following statement in the microsoft blog:

"We're removing the ability to use Basic authentication in Exchange Online for Exchange ActiveSync (EAS), POP, IMAP, Remote PowerShell, Exchange Web Services (EWS), Offline Address Book (OAB), Autodiscover, Outlook for Windows, and Outlook for Mac.

We're also disabling SMTP AUTH in all tenants in which it's not being used."

Based on above Office365 will no longer accept connections with basic auth, which means it wont accept connections as authenticated account(username password) even if tls protocol is used.

Thanks

Gayathri

Amit Garg-Oracle

Thanks Gianni.

What about the certificates - Any idea if default certificates work or would need some Custom Certificates?

Regards,

GayathriAnand-Oracle

When configuring an SMTP server for Oracle Analytics Cloud, only basic authentication is supported. However Microsoft recently decommissioned basic auth. Please refer to: 

https://docs.microsoft.com/en-us/exchange/clients-and-mobile-in-exchange-online/deprecation-of-basic-authentication-exchange-online

We recommend using Oracle Cloud Infrastructure Email Delivery service. See the guide here:https://docs.oracle.com/en/cloud/paas/analytics-cloud/acabi/example-oracle-cloud-infrastructure-email-delivery-settings.html

Amit Garg-Oracle

Thanks Gayathri. I checked the link

I was going through the below link for OAC SMTP set up

https://docs.oracle.com/en/cloud/paas/analytics-cloud/acabi/set-email-server-deliver-reports.html

I understand with OAuth, 2-factor authentication is not supported in OAC. However, otherwise wouldn't an authenticated account (username and password) along with STARTTLS and a valid office365 email address work?

Gokuleshwar Raju Nannapuraju

The above link is not working. Can you please update with new link.

GayathriAnand-Oracle

Hi

The link for SMTP setup is the same : https://docs.oracle.com/en/cloud/paas/analytics-cloud/acabi/set-email-server-deliver-reports.html#GUID-72A0F365-127F-45DB-902C-45E17376B1EC

Please check and let us know if you are able to access this link

Thanks

Gayathri

Gokuleshwar Raju Nannapuraju

It's working. Thanks.