Tableau Server and Office 365 SMTP Config with TLS

Advertisements

Configuring TLS with SMTP on Tableau Server requires configuration via CLI

Via JSON import

I usually export the existing settings to backup before I make changes. You can also copy the basic portion out of the export and adjust for import. After importing and apply changes, you can test the settings by running the tsm email test-smtp-connection command.

[robert@tableau-linux-server ~]$ tsm settings export -f ~/tableau-settings-export.json

[robert@tableau-linux-server ~]$ cat ~/tableau_email_office365.json
{
"configKeys": {
"svcmonitor.notification.smtp.server": "smtp.office365.com",
"svcmonitor.notification.smtp.send_account": "email_account@mytechdocs-office365-account.com",
"svcmonitor.notification.smtp.port": 587,
"svcmonitor.notification.smtp.password": "MyTechDocs1sGreat!",
"svcmonitor.notification.smtp.ssl_enabled": true,
"svcmonitor.notification.smtp.from_address": "email_account@mytechdocs-office365-account.com",
"svcmonitor.notification.smtp.target_addresses": "robert@mytechdocs.com",
"svcmonitor.notification.smtp.canonical_url": "https://tableau-linux-server.mytechdocs.com"
    }
}

[robert@tableau-linux-server ~]$ tsm settings import -f ~/tableau_email_office365.json

[robert@tableau-linux-server ~]$ tsm pending-changes apply

[robert@tableau-linux-server ~]$ tsm email test-smtp-connection

Via TSM CONFIGURATION

Making this change via TSM settings is pretty similar to the above, but using TSM commands instead. I would still recommend exporting the existing settings as a backup.

[robert@tableau-linux-server ~]$ tsm settings export -f ~/tableau-settings-export.json

[robert@tableau-linux-server ~]$ tsm configuration set -k svcmonitor.notification.smtp.servers -v smtp.office365.com
[robert@tableau-linux-server ~]$ tsm configuration set -k svcmonitor.notification.smtp.send_account -v email_account@mytechdocs-office365-account.com
[robert@tableau-linux-server ~]$ tsm configuration set -k svcmonitor.notification.smtp.port -v 587
[robert@tableau-linux-server ~]$ tsm configuration set -k svcmonitor.notification.smtp.password -v MyTechDocs1sGreat!
[robert@tableau-linux-server ~]$ tsm configuration set -k svcmonitor.notification.smtp.ssl_enabled-v true
[robert@tableau-linux-server ~]$ tsm configuration set -k svcmonitor.notification.smtp.from_address -v email_account@mytechdocs-office365-account.com
[robert@tableau-linux-server ~]$ tsm configuration set -k svcmonitor.notification.smtp.target_addresses -v robert@mytechdocs.com
[robert@tableau-linux-server ~]$ tsm configuration set -k svcmonitor.notification.smtp.canonical_url -v https://tableau-linux-server.mytechdocs.com
[robert@tableau-linux-server ~]$ tsm configuration set -k svcmonitor.notification.smtp.password -v MyTechDocs1sGreat!

tsm pending-changes apply

tsm email test-smtp-connection
Advertisements

Add a Comment

Your email address will not be published. Required fields are marked *