Dbeaver Apt

01-05-2021
 |  [RAND-100] - Comments



How to install DBeaver on Ubuntu OS

For ease of access and work with databases, it's always good to have the GUI. Working with a large number of databases sometimes requires us to use GUI solutions. In scenarios with a focus on the underlying cause, any GUI is welcome. Today, we will run through the process of how to install DBeaver on Ubuntu OS.

Sudo apt-add-repository ppa:webupd8team/java sudo apt update sudo apt install oracle-java8-installer Attention: Other JDKs, like OpenJDK 7 and 8, didn't work for me! Ubuntu 20.04 LTS on Windows allows you to use Ubuntu Terminal and run Ubuntu command line utilities including bash, ssh, git, apt and many more. Please note that Windows 10 S does not support running this app. To launch, use 'ubuntu2004' on the command-line prompt (cmd.exe), or click on the Ubuntu tile in the Start Menu.

DBeaver is the database management tool and if you are installing it on a remote Ubuntu OS server, make sure you have the RDP service installed first and ready to work on it! Otherwise, just continue from here.

Pre-requirements

Before we can install DBeaver on Ubuntu OS let's make sure that we have at least one of the database engines installed. This is a list of DBeaver supported database engines:

  • MySQL
  • PostgreSQL
  • MariaDB
  • SQLite
  • Oracle
  • DB2
  • SQL Server
  • Sybase
  • MS Access
  • Teradata
  • Firebird
  • Derby

We are going to use the MariaDB server as it's already installed on our test server. If you don't have it, follow these steps to install MariaDB on the Ubuntu OS server and set up the MariaDB server for work to be done on it.

Ok, let's install unavoidable JAVA support:

App

Now that we have hit it off with JAVA, let's add a repository required for DBeaver packages:

Install DBeaver now:

That's about it. Now, let's fire it up and see how it works with previously installed MariaDB on this box:

To connect to our MariaDB database server we need to create a new database connection like this:

Connection process require us to select which database engine we are using. In this case, we'll select MariaDB:

And now the connection details. These are the details we used in the process of setting up the MariaDB server:

If we didn't mess up anything the next window should be:

That's it! The database GUI is installed and we can now proceed to actual work šŸ˜.

Related Articles:
How to install MariaDB on Ubuntu OS
How to install Remote Desktop Service on the Ubuntu OS

Free and open source database management software for administration of all popular databases. Supports cloud data-sources and enterprise security standards.

DBeaver

Overview

Use DBeaver to create and manage databases across a wide range of database management systems. This open source database management software works with most of the popular DBMSs including MySQL and MariaDB. Developers can use DBeaver on any database that has a JDBC or ODBC driver. It even works with databases that donā€™t have a standard xDBC driver including Mongo DB, Redis, and WMI.

DBeaver is a free DBMS tool. Which can be used for developers, SQL programmers, database administrators and analysts. It is a multi platform tool. So it works on Windows, Linux, Mac, and Solaris. This free DBMS software solution works with the following databases:

  • MySQL
  • PostgreSQL
  • MariaDB
  • SQLite
  • Oracle
  • DB2
  • SQL Server
  • Sybase
  • Microsoft Access
  • Teradata
  • Firebird
  • Derby

System Requirements

DBeaver requires Java (JRE) 1.8+ to run.

  • Windows and MacOS installers have built-in JRE component
  • But you have to install JRE on Linux manually

Features

DBeaver is a user-friendly GUI based database management tool that comes with great features. Hereā€™s a list of some important features:

  • SQL editor: Organize all your scripts in folders. Reassign database connections for particular scripts.
  • Data viewer and editor: You can sort, filter, display images. It also allows to import data and export data.
  • Metadata browser: View and edit existing tables, views and columns. As well as indexes, procedures and triggers.
  • Data transfer: You can import and export tables/databases. It supports various formats including CSV, XML, XLS and XLSX.
  • Data and metadata search: Search by text from all chosen tables/views.
  • ER diagrams: Automatically generate ER diagrams for a database/schema. Then export the diagram in a desired format.
  • Database structure comparing: It also allows to compare objects structure.

Installation

Dbeaver

Here are the complete installation instruction for Ubuntu. Update system using following commands

Update system using following commands

Then add Java repository

Now install Java11

Check version

Apt

After that, add the DBeaver repository to your Ubuntu 18.04 instance. So first, download and add the GPG key for DBeaver

Then add the DBeaver repository

Dbeaver Apt

Finally install DBeaver CE

Check dbeaver version

Dbeaver Altibase

DBeaver is now installed. Access it from Unity dash. Open DBeaver workbench as follows:

Dbeaver Active Directory Redshift

Explore

Dbeaver Apache Drill

To learn about other open source database management software and phpMyAdmin alternatives, please check following pages: