How to set up an SMTP service to enable the Send Email functionality in Spotfire Data Virtualization (SDV)?

How to set up an SMTP service to enable the Send Email functionality in Spotfire Data Virtualization (SDV)?

book

Article ID: KB0138307

calendar_today

Updated On:

Products Versions
TIBCO Data Virtualization 8.8 and Higher
TIBCO Data Virtualization 8.8 and Higher

Description

To enable email functionality in SDV, an SMTP service must be configured using a supported email provider such as Google/Gmail, Outlook, Yahoo, or any enterprise mail service.

The steps below use Google/Gmail SMTP settings only as an example reference. After configuring the SMTP service on the mail provider side, the corresponding details need to be updated in the Studio configuration panel, followed by testing using the demo procedure.

The details for each step are provided below.

Environment

Windows Server

Resolution

Steps to set up an SMTP service:

  1. Ensure 2-Step Verification is enabled on the Gmail account.

  2. Go to Manage your Google Account → Security 
    image.png

  3. Search for “App passwords."

    image.png

  4. Create a new App. It will generate the password in the Google account. (Copy this password for future use in SDV)

    image.png

  5. In SDV, go to Studio > Administration > Configuration. Under E-Mail --> SMTP configuration details, fill in the required details:
    • Username – The email account used for authentication with the SMTP service.
    • Hostname – It should be smtp.gmail.com, as this is Gmail’s SMTP service used to send emails.
    • Password – The password (or app password) for the email account used for authentication.
    • The From property is set to the same SMTP username given above.

      image.png

  6. In SDV, navigate to /lib/util/SendEMail and run SendEmail to test the configuration.  This will facilitate the use of the SMTP service application we have created to send the system Email. e.g of SendEmail parameters:

    SendEMail(NULL, NULL, 'name@xyz.com',NULL, NULL, 'Hello World', 'TEXT_PLAIN', NULL);

Issue/Introduction

This article summarizes the steps required to set up an SMTP service and configuration on the SDV side to enable the mail functionality.