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.
Agenda Presentation: EPM Integrator connectors and Salesforce CRM Connector. Join us to learn more about the EPM Integrator connectors and Salesforce CRM Connector in Oracle FDI. We will explore the enhanced capabilities of the EPM integrator connectors and how you can load data from EPM modules to FDI to deliver a…
If I only do one with one expression filter, it works, but if I put the 2nd parameter with an expression filter, I get no data found???? Why
I've been trying to add a trend line to my line graph in OAC, and it's driving me bonkers. The graph itself is pretty simple. The X-axis consists of days, one day at a time, that comes from a "load date" on each record. The Y-axis is a count of all the contracts in progress per a given load date. OAC easily constructs a…
Hi! I am looking for audit logging for Analytics objects, such as users creating, modifying, or deleting datasets, dataflows, schedules, etc. The traditional Presentation Services component provides such logging in domains/oas/servers/obips1/logs/auditjson.log, which contains audit information for catalog objects,…
Hello Team, While building a Pivot Table view for my report, 2 out of the 4 metric columns contain completely null values. I'm looking for a way to automatically exclude or hide metric columns whenever they are entirely null or zero. Could you please advise on how to achieve this? Thanks.
I'm trying to index a Local Subject Area so I can use it in my AI Agent, however, I keep receiving the generic error below. Request status(500) : error = {"prefix":"DSS","code":50000,"message":"There was an unexpected error while processing this request. Please try again."}