Installing and using DBeaver for accessing and controlling different databases in one tool

on
dbeaver

Skill - Installing and using DBeaver for accessing and controlling different databases in one tool

Table of Contents

In this post we will try to install and use a free universal database tool called DBeaver

DBeaver_demo

Why use DBeaver?

  • You can manage all popular databases (MySQL, PostgreSQL, SQLite, Oracle, DB2, SQL Server, MS Access, Teradata, Firebird, Apache Hive, Phoenix, Presto, etc) in one single tool. No need to download separate tool for each type of database
  • The community edition of DBeaver is free
  • This is tool is cross-platform, so it can be installed in Windows, Linux, Mac

Install DBeaver

Windows

Ubuntu

sudo add-apt-repository ppa:serge-rider/dbeaver-ce
sudo apt-get update
sudo apt-get install dbeaver-ce

Other Linux Distributions

The DBeaver download page at https://dbeaver.io/download/ has the commands and instructions required to install DBeaver in other environments also like Debian, Mac OS etc

Using DBeaver

dbeaver_new_connection_screen

  • Each type of database connection requires its own plugin
  • If plugin is not present in the computer, DBeaver will prompt to install the plugins via downloading from the internet

Installing DBeaver plugins without internet

Step 1 - Download the database plugin jar files in a computer with internet

  • All the installed database plugins can be found in the folder
    C:\Users\<username>\AppData\Roaming\DBeaverData\drivers\maven\maven-central
  • On the Top Menu bar go to Database -> Driver Manager menu
  • Then select the database you would like to connect and click edit
  • In the pop up window, click Download/Update button. Now all the driver jar files will be downloaded in the computer from the internet
  • After the drivers are downloaded, the folder location of jar file will be displayed on hovering the mouse over the library
  • Go to the database plugins folder and copy all the jar files corresponding to the required database driver and paste in the computer without internet

Step 2 - Installing the jar files in the computer without internet

  • Open Database -> Driver Manager Menu
  • Click “New” button and fill the input fields for the required database driver
  • Click the “Add File” button to import all the jar files required for this database driver
  • Now we have completed the offline installation of a database driver!

The screenshots of the settings of common database drivers can be seen in the images below. You can take a snapshot of the driver settings from the computer that has the required database driver already installed and working.

dbeaver_postgres_driver_settings
dbeaver_mysql_driver_settings
dbeaver_oracle_driver_settings
dbeaver_sqlite_driver_settings

Video

The video for this post can be found here

References

Table of Contents

Location: Mumbai, Maharashtra, India

Comments

Post a Comment