Dbeaver Supported Databases



How to install DBeaver on CentOS

For ease of access and work with databases, it's always good to have the GUI. Yes, working with a large number of databases sometimes requires us to use GUI solutions. I personally prefer console access to the database. But, 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 CentOS.

Oracle database (Express or Enterprise) is one of the most advanced relational databases. Enterprise-level relational database developed by IBM. Supported drivers are: DB2 for LUW (Linux/Unix/Windows), DB2 for z/OS, DB2 for iSeries / AS400. DBeaver Universal Database Tool Free multi-platform database tool for developers, database administrators, analysts and all people who need to work with databases. Supports all popular databases: MySQL, PostgreSQL, SQLite, Oracle, DB2, SQL Server, Sybase, MS Access, Teradata, Firebird, Apache Hive, Phoenix, Presto, etc. DBeaver is free universal SQL client/database tool for developers and database administrators. It can work with any database server which has JDBC or ODBC driver. It supports pluggable extensions. Features: database schema browser, metadata editor (tables, columns, keys, indexes), SQL statements/scripts execution, SQL highlighting. What is DBeaver? Database management tool that supports SQL editor, mock data generator, visual query builder, metadata browser, data transfer and more. Serge-rider released this on Sep 20, 2020. Preference pages structure was reorganized (in the standalone and plugin versions) - Database navigator: - Filters now support masks escape ( and% characters) - Connection state icons were replaced and adapted to dark themes - SQL Editor: editor tab title now can include active database/schema name.

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

Pre-requirements

Supported

Before we can install DBeaver on CentOS 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 CentOS server.

Now, let's install a must-have requirement, JAVA:

Check if it's installed by running:

Installation

Download the DBeaver package:

Dbeaver Community Supported Databases

Execute the installation:

That's it! Now, find the launcher for DBeaver and hit it:

If you want, DBeaver can create a test database for you to begin exploring it. Otherwise, you can connect it to your own database and continue from there.

Connect to Database

Dbeaver Supported Databases Available

Let's connect the DBeaver to our database now! First, navigate to Database - New Database Connection:

Next, let's select our database engine (in our case MariaDB):

Dbeaver community supported databases

Dbeaver Supported Databases Vs

Almost there! Now, use our database user credentials to connect DBeaver to MariaDB:

That's it, now we can see our local databases served by MariaDB server:

Voila! Now, the real work can begin 😁! Read you later ✌️.

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





Comments are closed.