Goal
In this document, we will learn how to set up the email reporter for the Denodo Testing Tool (DTT). In addition to the basic configuration of the DTT, some email servers may need extra configuration to allow sending email reports in an automated way. We will see how to configure this when using Gmail.
Setting the email reporter option in the Denodo Testing Tool
- Download the Denodo Testing Tool from the Denodo Connects section of Denodo’s Support Site and unzip the distribution.
- Edit the <DTT_HOME>/conf/configuration.properties configuration file and uncomment the following lines entering the correct values for the properties:
# --------------------------- # Example Email Test Reporter # --------------------------- reporter.email=com.denodo.connect.testing.reporter.EmailTestReporter reporter.email.password=<email_account_password> reporter.email.username=<email_account_username> reporter.email.serverHost=<email_smtp_host> reporter.email.serverPort=587 reporter.email.serverProtocol=smtp reporter.email.smtpAuth=true reporter.email.smtpQuitwait=false # Recipients can be separated by spaces or commas reporter.email.recipient=<email_recipients_list> # Available values are: 'full' (all test results reported), 'summary' # (only summary with OK/FAILED tests) and 'failed' (email sent only if # there have been failed tests). reporter.email.messageDetailLevel=full |
Setting up a Gmail account
When using a Gmail account to send the reports the account has to be configured following the steps below. These configuration settings are needed to enable the sending of emails from any application external to Gmail using SMTP.
- Log in to the Gmail account.
- Click on the Settings option on the top right corner of the Gmail screen.
- From the settings section go to the Accounts tab and click on the Google Account Settings.
- From the Google Account Settings page click on the Security option
- After clicking on the '>' button, you will find the option as “Allow less secure apps” on a new page. Set this option to ON.
Once these changes in the configuration are made the reports will be sent to the recipients configured in the configuration file of the DTT.
If you do no want to enable this option and you have 2-step Verification turned on follow these steps:
- Go to Settings > Accounts > Google Account Settings
- From the Google Account Settings landing page go to Security > Signing in to Google > App passwords.
- Under App passwords, enter Denodo Testing Tool as App name enter the following information and click CREATE.
- Copy the password that has been generated.
- In your Denodo Testing Tool configuration use this password.
... reporter.email.password=<app_password> reporter.email.username=<email_address> reporter.email.serverHost=smtp.gmail.com reporter.email.serverPort=587 ... |
Depending on the mail server used similar changes may need to be made to the security configuration to allow access to the Denodo Testing Tool.
The information provided in the Denodo Knowledge Base is intended to assist our users in advanced uses of Denodo. Please note that the results from the application of processes and configurations detailed in these documents may vary depending on your specific environment. Use them at your own discretion.
For an official guide of supported features, please refer to the User Manuals. For questions on critical systems or complex environments we recommend you to contact your Denodo Customer Success Manager.