topic Re: Office 365 Email integration with Qlik SaaS in Integration, Extension & APIs

Office 365 Email integration with Qlik SaaS

DruClausner — Fri, 09 Sep 2022 19:17:03 GMT

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.

Re: Office 365 Email integration with Qlik SaaS

Sebastian_Linser — Fri, 09 Sep 2022 19:19:10 GMT

@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-dns-ip.htm

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

Best regards

Sebastian

Re: Office 365 Email integration

DruClausner — Thu, 24 Mar 2022 19:28:48 GMT

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.

Re: Office 365 Email integration with Qlik SaaS

Spartan27215 — Wed, 14 Dec 2022 19:19:11 GMT

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.

Re: Office 365 Email integration with Qlik SaaS

Dave_Channon — Thu, 15 Dec 2022 13:54:42 GMT

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-alerts-and/idc-p/1922933