02-05-2021

Dbeaver Supported Databases



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. 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 is desktop application. If you are looking for a web-based database management system – please check another of our products: CloudBeaver. It is also open-source and free.

How to install DBeaver on CentOS

Support tickets Registered users have access to online support system. Issues reported as tickets are high priority tasks for us and they will be addressed as soon as possible. Feedback form You can use our feedback form for questions and reports. NoSQL / BigData databases. DBeaver Enterprise has special extensions for: MongoDB; Couchbase; Amazon DynamoDB; Google Bigtable; InfluxDB; Apache Cassandra; Redis; Apache Hive; All these databases have SQL interface and you can work with them as with good old relational databases.

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.

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

Dbeaver Supported Databases

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:

Execute the installation: How do you get pdfs onto foxit pdf reader for mac.

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

Dbeaver Supported Databases Free

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 supported databases using

Dbeaver Supported Databases Available

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 ✌️.

Dbeaver Supported Databases Using

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

Dbeaver Community Supported Databases

  • Dark theme support was improved (Windows 10 and GTk)
  • Data viewer:
    • Copy As: format configuration editor was added
    • Extra configuration for filter dialog (performance)
    • Sort by column as fixed (for small fetch sizes)
    • Case-insensitive filters support was added
    • Plaintext view now support top/bottom dividers
    • Data editor was fixed (when column name conflicts with alias name)
    • Duplicate row(s) command was fixed for multiple selected rows
    • Edit sub-menu was returned to the context menu
    • Columns auto-size configuration was added
    • Dictionary viewer was fixed (for read-only connections)
    • Current/selected row highlighting support was added (configurable)
  • Metadata search now supports search in comments
  • GIS/Spatial:
    • Map position preserve after tiles change
    • Support of geometries with Z and M coordinates was added
    • Postgis: DDL for 3D geometry columns was fixed
    • Presto + MySQL geometry type support was added
    • BigQuery now supports spatial data viewer
    • Binary geo json support was improved
    • Geometry export was fixed (SRID parameter)
    • Tiles definition editor was fixed (multi-line definitions + formatting)
  • SQL editor:
    • Auto-completion for objects names with spaces inside was fixed
    • Database objects hyperlinks rendering was fixed
  • SQL Server: MFA (multi-factor authentication) support was added
  • PostgreSQL: array data types read was fixed
  • Oracle: indexes were added to table DDL
  • Vertica: LIMIT clause support was improved
  • Athena: extra AWS regions added to connection dialog
  • Sybase IQ: server version detection was improved
  • SAP ASE: user function loading was fixed
  • Informix: cross-database metadata read was fixed
  • We migrated to Eclipse 2021-03 platform

Dbeaver Supported Databases Vs

Posted in Releases