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
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.
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.
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
Thanks Gianni.
What about the certificates - Any idea if default certificates work or would need some Custom Certificates?
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
Thanks Gayathri. I checked the link
I was going through the below link for OAC SMTP set up
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?
The above link is not working. Can you please update with new link.
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
It's working. Thanks.
Where AI meets business outcomes Oracle AI World brings the Oracle community together to explore how AI and other technology innovations are driving real business outcomes across industries. Discover what’s new through: Mainstage keynotes to hear the latest directly from Oracle leadership Product demonstrations Customer…
What am I doing wrong here? There is only one selection in the Target Canvas??
In BIP. I was able to group tables. Is this possible in OAC
I creates a parameter "Role Name" and then I put the Role name field in the filter and made a bind to the parameter, When I add the value in the parameter, it works. When I delete it from the parameter it give me <empty> How do I get rid of the <empty>
Hi, all, I have been struggling with connecting to Teradata in OBIEE Admin tool. I can't import Metadata to the RPD that exists. I am not sure about if it is due to my config of ODBC Teradata is incorrect or anything else? Please find the following errors as attached: Many thanks for your help!
Hi Team, Has anyone upgrade OAS system from the 2024 to 2026 version? if yes, could you please share the resposne files. Regards, Chand
