Sending results by e-mail
DBeaver offers a way to send data exported via Data Transfer by email.
SMTP profile configuration
First, you will need to add an SMTP profile to send the email from. Go to Window ⇒ Preferences ⇒ General ⇒ Mail and create a new profile.
Parameters Host and Port may depend on the mail service you use. If the service offers both SSL and TLS ports, use the latter one. Gmail, for example, uses host
smtp.gmail.com and port
587. An example of a configured profile:
Then you can use the Test connection button to verify that the host and credentials are valid.
See the troubleshooting section for more information on resolving common authorization problems.
Setting up data transfer
When at least one profile is present, you can actually set up email sending. Create a regular export task, go to the Output page and make sure the Send results by E-Mail option is enabled. By pressing the Configure label near it, you can specify several recipients and the subject for your mail:
That's it. After the task is completed, the specified recipients will receive an email containing the exported file in a specified format during the data transfer.
You may face various problems while setting up a new SMTP profile.
Several common errors when using Gmail and solutions for them are described below:
535-5.7.8 Username and Password not accepted. Check that the username and password are correct. If you are certain that you have entered valid credentials, then try allowing less secure apps.
Read more at https://support.google.com/accounts/answer/6010255
534-5.7.9 Application-specific password required. You have two-factor authorization enabled. You will need to generate a special password for DBeaver to use.
Read more at https://support.google.com/accounts/answer/185833
There were also several cases when antivirus' would block DBeaver from sending an email.