Office 365 Email integration with Qlik SaaS

[DruClausner]

Hi,

Has anyone been successful with setting up an Office 365 email with Qlik cloud?  All my settings are correct, however we use SPF to secure our email and I don't know what the Qlik web server IP address(s) are.  I opened a support ticket but it was closed by support less than an hour later. 

[Sebastian_Linser · Accepted solution]

@DruClausner Below article contains the IP address list which needs to be whitelisted. 

https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Introduction/qlik-cloud-...

Note that your TenantName.region.qlikcloud.com is dynamic and should therefore be implemented with the DNS name.

Best regards

Sebastian

[DruClausner · Accepted solution]

Thank you, this worked for my SPF record.  

For anyone else coming here about O365 emails, if you have MFA enabled on the email account, you must use an App Password to authenticate with Qlik's service.

[Spartan27215 · Accepted solution]

I have yet to be able to get it to work with my Tenant. Was trying to get it to work in the automation as an email for reports but have not been successful. I explicitly setup a connector in my O365 Exchange server and used the list of IP's as enabled IP's to send mail through connector. But it did not work. Perhaps some instructions on how you got it to work.

[DaveChannon · Accepted solution]

Hey @Spartan27215 - are you using basic auth via O365?

If so this is unlikely to work as Microsoft are blocking that auth method, but we have an ideation post on this topic, and I'd encourage you to read Jeff's reply on the thread: https://community.qlik.com/t5/Suggest-an-Idea/Implement-advanced-SMTP-authentication-options-for-ale...