SMTP
The Qlik SMTP connector lets you connect to an SMTP server of your choice and then use it to deliver outgoing emails. This can be used to report errors or send confirmation when a scheduled reload has been completed.
Accessing your SMTP server
Microsoft Outlook/Exchange Online: SMTP basic authentication retirement.
Microsoft is retiring SMTP AUTH Basic Authentication for Exchange Online. By the end of December 2026, basic authentication will be disabled by default for existing tenants. Microsoft will announce a final removal date in the second half of 2027.
If you use SMTP with Outlook or Microsoft Exchange Online, you must migrate to OAuth authentication before your tenant's basic auth is disabled. For details and timelines, see Updated Exchange Online SMTP AUTH Basic Authentication Deprecation Timeline on the Microsoft Exchange Team Blog.
Qlik Sense Desktop and standalone QlikView: No OAuth alternative.
The OAuth-based SMTP connector is available only in Qlik Sense Business, Qlik Sense Enterprise on Windows, and Qlik Cloud. If you are using Qlik Sense Desktop or standalone QlikView with Outlook/Exchange Online SMTP, there is no supported OAuth migration path. You must switch to a non-Microsoft SMTP server or a different email service.
To access your SMTP server, you need to authenticate the connector with your SMTP server details. After you create a new connection and select SMTP as your connector, you need to enter the server address along with your username and password. You also need to choose an appropriate port and an SSL mode for the connection to the server.
Creating a data source connection
Loading data from tables
After you authenticate the connector with your credentials, you can use the following table:
| Table | Description |
|---|---|
| SendEmail | Use this table to send out emails. |
To send out an email using the table, enter the required parameters and click Preview data. By clicking Preview data the table will try to send an email out to the email address you entered in the To and CC parameters. Required parameters are marked with an asterisk (*). The table fields are displayed under the Data preview tab. You can select fields individually by selecting the box beside each field name. Select Insert script after you have made your selection. For more information, see Selecting data from tables.
Checking the status
The table field status informs you whether the email has been sent or not. This does not guarantee that the email was delivered. To check if the email was delivered you need to check the recipient inbox.
There are various reasons why a sent email is not delivered. For example, if the recipient's:
- Email address does not exist.
- Inbox is full.
- Email service has blocked the email.
Troubleshooting
You receive an error message that the connection to the SMTP server failed
Possible cause
The SSL Mode parameter has not been set up correctly.
Proposed action
Choose a different SSL mode. Make sure that you are using an encrypted connection. Unencrypted connections are not supported.
You cannot send out emails
Possible cause Possible causes
There are many possible causes preventing you from sending out emails. For example:
- The From Email address is different and not linked to the authenticated user.
- The mail service has spam protection enabled, preventing multiple email recipients.
Proposed action Proposed actions
Do one of the following:
- Make sure that the email address used in the From Email parameter is linked to the authenticated user. Check the authenticated account settings on your mail server.
- Check that the mail service allows emails to be sent out to multiple recipients.
Limitations
You cannot create and manage connections to this connector in Data manager within an analytics application.