OBIEE 12c and Office 365 SMTP

User_2YY88

Currently we have OBIEE 12.2.1.4 version installed and patched till April 2021. (12.2.1.4.0 (Build BIPS-20201002204602 64-bit)

We are trying to update Mail settings to use office 365 smtp where TLS is enabled. What ever settings we try we are unable to integrate them? Anybody faced smiliar issue and able to resolve the issue?

[Deleted User]

Thanks that a precise version

But as I asked the other guy: WHAT is going wrong? What do the log files say?

User_2YY88

Thanks Christian for response.

Below is the error: [nQSError: 75025] Handshake failed when connecting to SMTP server using SSL. [[

And our settings are as below:

SMTP Server: smto.office365.com

Port: 587

Email address and User Name are same and we are providing password.

Connection Security - STARTTLS

User_2YY88

SMTP Server: smtp.office365.com

Gianni Ceresa

Can you test your settings by using them somewhere else (another program/tool)?

Does the SMTP server have a public recognized SSL certificate?

I didn't check right now on an OBIEE (I don't have a 12c running), but I believe it was also possible to set all the details (the CA etc.).

SSL is always a lot of "fun", because it isn't as simple as it should be.

User_2YY88

Oracle provided this link

https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=319174085900432&parent=SrDetailText&sourceId=3-28993507531&id=2681560.1&_afrWindowMode=0&_adf.ctrl-state=pd8p6vg56_613

SMTPServer: smtp.office365.com

Port: 587

Display name of sender: your choice (e.g. Oracle Analytics Agent)

Email Address of Sender: office365-email-address@outlook.com

Username: office365-email-address@outlook.com

Password: office365-account-password

Number of retries upon failure: 0

Maximum recipients: 0

Connection Security: STARTTLS

Specify CA certificate source: select 'file'

CA certificate file: [path]/certificate_bundle.cer <=== example from the certificate generated in the first step

SSL certificate verification depth: 9

SSL cipher list: <empty>

User_2YY88

Our system is already on SSL, (Our certs are Self certs in DEV/Test and Wild Card certs in Prod).

Do i need to download certs from Microsoft and add them in my JKS file on server? Or Just add the new cert in a folder and add that location in Mail settings?

User_2YY88

https://community.oracle.com/tech/apps-infra/discussion/comment/16830126#Comment_16830126

Yes Gianni, they are working for different applications.

I will find out about the SMTP server

Mohammed Tausif Khaleel

HI User_2YY88,

Were you able to resolve this issue as even im facing similar issue when trying do a test connection in BIP console under administration section. How did you configure your certificates.

Any input from anyone is appreciated

Im trying to setup the smtp connectivity between OBIEE11g with SMTP server hosted on AWS Simple Email service (SES).

below is the settings at the bip admin console level:

Below is setting at the fusion middleware control level:

User_D5ZV4

Hi

I have the same problem with smtp.office365.com. Someone get to solved this problem?

Sumanth V -Oracle

@User_D5ZV4 - We would request to create a new discussion with the details of the issue. This is a very old thread and issues are sometimes unique. Also, newer threads usually get better responses.Thank you.