Data transfer email - bobbyiliev/dbeaver GitHub Wiki

Note: The following feature is only available in Enterprise and Ultimate editions.

DBeaver offers a way to send data exported via Data Transfer by email.

First, you'll need to add an SMTP profile to send the email. Go to Window ⇒ Preferences ⇒ General ⇒ Mail and create a new profile.

Parameters Host and Port may depend on the mail service you use. Use the latter if the service offers SSL and TLS ports. 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.

Please take a look at the troubleshooting section for more information on resolving common authorization problems.

When at least one profile is present, you can set up email sending. Create a regular export task, go to the Output page, and make sure the Send results by email option is enabled. By pressing the Configure label near it, you can specify several recipients and the subject for your mail:

You also have control over the specifics of what you receive, as follows:

• Omit Empty Results: Enable this option to prevent emails from being sent when no results are displayed.
• Report Task Failure: Enable this option to receive an email alert whenever a task fails.
• Bypass Server Certificate Verification: This option can be used when working with self-signed certificates and you wish to bypass the standard certificate validation process.

That's it. After completing the task, 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 confident that you have entered valid credentials, then try creating an app password.
  Read more at https://support.google.com/accounts/answer/185833
• 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 the antivirus would block DBeaver from sending an email.