Skip to content

Enterprise Edition

dbeaver-devops edited this page Dec 4, 2024 · 26 revisions

Table of contents

Overview

DBeaver Enterprise Edition is ideal for users who need a powerful set of tools for complex data environments. This edition goes beyond simple database tasks, enhancing data visualization, query development, security features, and administrative tasks. It is a vital tool for professionals looking to improve their productivity and manage data more effectively.

Note: The DBeaver Enterprise Edition is designed for individual use only.

Enterprise Edition features

The Enterprise Edition provides specialized tools and features that cater to the needs of businesses:

  • Data visualization

    • Data filtering and sorting: Provides tools to filter and sort data directly within the database interface. Learn more.
    • Color coding and highlighting: Simplifies data analysis by color-coding and highlighting table rows and fields based on conditions. Learn more.
    • Functional panels: Enhance data manipulation by offering additional space in the Data Editor for managing complex data types, accessible via tabs in a dedicated panel. Learn more.
    • Tableau integration: Facilitates integration with Tableau for advanced data visualization and analysis. Learn more.
  • Query development

    • SQL Editor: Provides code completion for easier writing, auto-formatting, spelling checks, and support for variables. Learn more.
    • Execution plan visualization: Provides detailed visualizations of SQL execution plans. Learn more.
    • Additional tools for query creation:
      • Visual Query Builder (VQB): Provides a graphical interface to construct SQL queries without writing code. Learn more.
      • AI assistant: Integrates an AI assistant and AI Chat to offer guidance and automation within the SQL Editor. Learn more.
    • SQL debugger: Offers an SQL debugger specifically designed for PostgreSQL, aiding in query development and troubleshooting. Learn more
  • Administrative tasks

    • Reverse engineering (ERD): Provides capabilities for reverse engineering databases into entity-relationship diagrams. Learn more.
    • Forward engineering:
      • Metadata editor: Enables the management and editing of database metadata.
      • Edit mode for ER-Diagrams: Offers functionalities for editing entity-relationship diagrams to aid in database design. Learn more.
    • Administrative tools:
      • Backup and Restore: Offers functionalities for backing up and restoring databases, ensuring data safety. Learn more.
      • Analyze and vacuum: Tools for optimizing database performance by analyzing and vacuuming database objects.
    • Permission and user management: Manages database permissions and user accounts.
    • Schema comparison: Provides tools for comparing database schemas either within the same database or across different databases. Learn more.
    • Data comparison: Offers tools for comparing data across databases or within different parts of the same database. Learn more.
    • Mock data generator: Provides tools for generating mock data, useful for testing and development purposes. Learn more.
  • Data migration

    • Export and Import from files: Supports data export and import in up to 10 different file formats. Learn more.
    • Direct transfer between databases: Provides tools for efficient data migration directly between different databases or systems. Learn more.
  • Security

    • Database authentication: Implements database authentication mechanisms to secure access.
    • Master and Project Password:
      • Master password: Enables the use of a master password to enhance security across the DBeaver. Learn more.
      • Project password: Facilitates the use of project-specific password to secure projects. Learn more.
  • Automation

    • Task manager: A tool for managing and monitoring database tasks, enhancing productivity and organization. Learn more.
    • Task scheduler: Allows for scheduling database tasks, automating routine operations. Learn more.
    • Git integration: Supports integration with Git for version control, and change tracking. Learn more.

Subscription model

The DBeaver Enterprise Edition is offered as an annual subscription, which should be renewed to continue receiving updates and support.

Discover more about the DBeaver Enterprise Edition and subscribe.

Integrated database drivers

The Enterprise Edition has a comprehensive set of JDBC drivers, offering connectivity to various databases without needing separate downloads and configurations. Additionally, a versatile ODBC driver is supported for broader database compatibility.

For additional details on utilizing the ODBC driver, please consult the ODBC-JDBC driver article.

Supported databases

The Enterprise Edition provides support for a wide range of databases. Below are tables listing the databases available and specifying whether the Enterprise Edition offers enhanced features compared to the Community Edition.

* Enhanced features may include additional metadata capabilities, such as the ability to manage and interact with specific database objects unique to certain systems. For instance, managing Datashares in Redshift or handling Sequences in Netezza. These features also cover various advanced authentication methods, and numerous other functionalities designed to improve security and data management.

Relational databases
Database name Enhanced features* compared to the Community Edition
Altibase -
Apache Arrow Not available in Community Edition
Apache Calcite Avatica
Apache Kylin -
Azure Databricks
Azure SQL Server
Babelfish via TDS (beta)
CUBRID
Cache -
ClickHouse -
ClickHouse (Legacy)
CloudSQL - MySQL Not available in Community Edition
CloudSQL - PostgreSQL Not available in Community Edition
CloudSQL - SQL Server Not available in Community Edition
CockroachDB -
CrateDB -
CrateDB (Legacy) -
Dameng -
Data Virtuality -
Db2 for IBM i
Db2 for LUW -
Db2 for z/OS
Denodo 8 -
Derby Embedded -
Derby Server -
Dremio -
DuckDB -
EDB
Exasol
Firebird
Fujitsu Enterprise Postgres Not available in Community Edition
GaussDB -
Google AlloyDB Not available in Community Edition
Google Cloud Spanner
Greenplum
H2 Embedded
H2 Embedded V.2 -
H2 Server
H2GIS Embedded -
H2GIS Server -
HANA
HSQL Embedded -
HSQL Server -
Informix
Ingres -
InterSystems IRIS -
JDBCX -
Jennifer -
Kognitio -
MS Access (UCanAccess) -
MariaDB
Materialize -
MaxDB -
Mimer SQL -
MonetDB -
MySQL
MySQL 5 (Legacy)
NDB Cluster -
NetSuite Not available in Community Edition
Netezza
NuoDB -
ODBC Not available in Community Edition
OceanBase -
Ocient -
OmniSci (formerly MapD) -
OpenEdge -
OpenSearch
Oracle
Pervasive SQL -
PostgreSQL
PrestoDB -
PrestoSQL -
Raima Not available in Community Edition
Redshift
RisingWave -
SAP ASE jConnect -
SQL Server
SQL Server (Old driver, jTDS)
SQLite
SQLite Crypt Not available in Community Edition
SQream DB -
Salesforce Not available in Community Edition
Salesforce Data Cloud -
SingleStore
Snowflake
StarRocks -
Sybase jConnect
Sybase jTDS
Teradata
TiDB -
Trino -
Vertica
Virtuoso -
Yellowbrick -
YugabyteDB -
Non-Relational databases
Database name Enhanced features* compared to the Community Edition
Apache Drill
Apache Hive
Apache Ignite -
Apache Kyuubi -
Apache Phoenix -
Apache Spark -
Athena
Cassandra Not available in Community Edition
Cloudera Impala -
CosmosDB (Cassandra) Not available in Community Edition
CosmosDB (MongoDB) Not available in Community Edition
CouchDB Not available in Community Edition
Couchbase Not available in Community Edition
Couchbase 5+ Not available in Community Edition
CSV +
DBF -
DocumentDB Not available in Community Edition
DynamoDB Not available in Community Edition
Elasticsearch
Firestore Not available in Community Edition
Gemfire XD -
Google BigQuery
Google Cloud Bigtable Not available in Community Edition
InfluxDB Not available in Community Edition
InfluxDB 2 Not available in Community Edition
InfluxDB 3 Not available in Community Edition
Keyspaces Not available in Community Edition
Machbase -
MongoDB Not available in Community Edition
Neo4j
Neptune Not available in Community Edition
Open Distro Elasticsearch
OrientDB -
Parquet Not available in Community Edition
Redis Not available in Community Edition
ScyllaDB Not available in Community Edition
SnappyData -
Solr -
TDengine
TDengine Cloud
TimescaleDB -
Timestream Not available in Community Edition
XLSX Not available in Community Edition
Yugabyte CQL Not available in Community Edition

DBeaver Desktop Documentation

General User Guide

Database Management

DBeaver PRO

Databases support

Customizing DBeaver

Troubleshooting

Admin Guide

License management

Tutorials

Development

Clone this wiki locally