Ultimate Edition
Table of contents
Overview
DBeaver Ultimate Edition is perfect for users who require a powerful set of tools for managing complex data environments and are also seeking enhanced cloud capabilities. This edition builds on the features of the Enterprise Edition by adding specialized tools for cloud database management and Kafka data streams. It offers seamless integration and efficient management of cloud data sources, making it an excellent choice for users who need to extend their data handling into the cloud.
Note: The DBeaver Ultimate Edition is designed for individual use only.
Ultimate Edition features
The Ultimate Edition offering unique capabilities designed for complex, multi-platform data management tasks with a strong emphasis on enhanced cloud integration:
Cloud Explorer: A tool for managing and connecting cloud-hosted databases. Learn more
It offers integration with various cloud services:- Amazon Web Services Learn more
- Google Cloud Platform Learn more
- Microsoft Azure Learn more
Cloud Storage support: Enables file management within cloud environments of Amazon Web Services and Google Cloud Platform. Learn more
Kafka support: Provides integration with Apache Kafka.
Advanced Enterprise features in Ultimate Edition
In addition to its unique features, the Ultimate Edition utilizes all the advanced capabilities from the Enterprise Edition, including:
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 Ultimate Edition is offered as an annual subscription, which should be renewed to continue receiving updates and support.
Discover more about the DBeaver Ultimate Edition and subscribe.
Integrated database drivers
The Ultimate 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.
This edition also includes the Cloud Explorer feature, which provides access to cloud databases such as those on Amazon Web Services (AWS), Google Cloud Platform (GCP), and Microsoft Azure. Cloud Explorer enables centralized authentication and automatic configuration, simplifying the management of cloud database connections.
Cloud Explorer databases
For a list of supported databases, please refer to the related section in the Cloud Explorer guide.
Supported databases
The Ultimate Edition provides support for a wide range of databases. Below are tables listing the databases available and specifying whether the Ultimate 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 | Available through Cloud Explorer |
|---|---|---|
| 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 | Available through Cloud Explorer |
|---|---|---|
| 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 | - |
| Kafka (ksqlDB) | 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 | - |