How to configure TIBCO Spotfire Automation Services to run "Send Email" task using Office365 as SMTP server

How to configure TIBCO Spotfire Automation Services to run "Send Email" task using Office365 as SMTP server

book

Article ID: KB0079769

calendar_today

Updated On:

Products Versions
Spotfire Automation Services 7.5 and higher

Description

This article describes the steps to configure the TIBCO Spotfire Automation Services configuration file to run the "Send Email" task using Office365 as the SMTP server.

Issue/Introduction

How to configure TIBCO Spotfire Automation Services to run "Send Email" task using Office365 as SMTP server

Resolution

  1. On the computer running Spotfire Server, open a command line as an administrator and change the directory to the location of the config.bat file (config.sh on Linux). The default location is <server installation dir>/tomcat/bin.
  2. On the command line, export the service configuration that you want to modify from Spotfire Server by using the export-service-config command. Specify the service's capability and the deployment area, and optionally the configuration name.
    config export-service-config --capability=AUTOMATION_SERVICES --deployment-area=Production
  3. Open the configuration "Spotfire.Dxp.Worker.Automation.config" and search for following section and make the following changes port=587 and useTls=true, enter username and password. After the changes it should resemble something as follows.
    <smtp port="587" useTls="true" timeoutSeconds="100">
          <authentication useWindowsDefaultCredentials="false" username="user@office365.com" password="secretpassword" />
          <certificates useCertificates="false" storeLocation="LocalMachine" storeName="My" serialNumber="" />
        </smtp>
  4. Search for the following in config file and replace "smtp.company.com" with "smtp.office365.com" and "TsasService@company.com" with a from email address which could be yours. In the end it should look as follows.
    <!-- SMTP Host for Email Notification -->
          <add name="Spotfire.Automation.SendMail.SMTPHost" value="smtp.company.com" />
          <!-- From Address for Email Notification -->
          <add name="Spotfire.Automation.SendMail.FromAddress" value="TsasService@company.com" />
    
    	  
    	Example:-
    	
    	  <!-- SMTP Host for Email Notification -->
          <add name="Spotfire.Automation.SendMail.SMTPHost" value="smtp.office365.com" />
          <!-- From Address for Email Notification -->
          <add name="Spotfire.Automation.SendMail.FromAddress" value="user@office365.com" />"
  5. Save the file and import the configuration using the following command:
    config import-service-config --config-name=ServiceConfiguration
  6. Apply the configuration to automation services via Administration UI (Nodes & Services > Automation Services > Edit > Select the new configuration that you just configured) or via command line as below:
    config set-service-config --service-id=value --config-name=ServiceConfiguration​
  7. Open the client and test the job with execute on server.

Additional Information

Doc: TIBCO Spotfire Server and Environment > Manually editing the service configuration files:

Doc: TIBCO Spotfire Automation Services User's Guide > Send Email: 

External Link: Office365 SMTP server details: