Team Edition 23.3

December 12, 2023
Changes since 23.2:

General updates:

Cloud Storage Services are officially supported. You can enable Amazon S3 and Google Cloud in the admin panel, and then open scripts, download files, upload files, and copy them by drag-n-drop. Task results can also be saved in the enabled cloud storage. Microsoft Azure cloud storage is available in the desktop application.

Multi-server license support – you can use a single list of users for different servers.

AI enhancements: AI assistance is available in both web and desktop interfaces. You can set Azure OpenAI as an alternative AI configuration.

Authentication
  • Active Directory Federation Services authentication method was added.
  • Amazon Cognito OpenID authentication provider was added.
  • The ability to synchronize with Okta groups was added.
  • The ability to configure multiple AWS IAM authentication providers was added.
Administration and Access Management
  • Easy configuration has been added, allowing users to set the administrator’s login and password, as well as configure other settings during the initial launch.
  • Added the ability to set local credentials for SSO users.
  • Administrators have gained the ability to permanently delete users and their data.
  • Google provider has been added to the user provisioning.
Security
  • Unauthorized access vulnerability was fixed.
  • Large number of CVEs in third-party dependencies have been resolved.
New drivers:
  • ScyllaDB
  • AlloyDB
  • Dameng
  • Cosmos DB (Cassandra)

DBeaver Team Edition desktop

Authentication
  • Federated authentication is supported.
  • Cloud service accounts are supported for scheduled tasks execution. It is supported for AWS, Google Cloud, and Azure.
  • Amazon Cognito OpenID authentication provider was added.
  • Administration
  • Project properties are now stored on the server.
Cloud Explorer
  • You can connect to Google Bigtable and Cosmos DB (Cassandra) via Cloud Explorer.
  • SSH tunnel configuration was added — SSH tunnel is automatically assigned to a cloud database when you add it to the Database Navigator from Cloud Explorer.
Data Editor
  • Multiple query results can be displayed vertically
  • `Go to column` action (Ctrl+Shift+G) allows you to find a specific column.
SQL Editor
  • Auto-completion proposes all aliases present in the query for tables with joins.
  • AI Chat is a new way to use artificial intelligence to build SQL queries: you post a phrase in a human language in the chat, receive a working SQL query, and modify it with AI until you get a perfect result.
ER Diagrams
  • New diagram notations are available: Crows Foot and Bachman
  • Experimental feature: you can enable Orthogonal routing that shows not only relationships between tables but also relationships between specific columns.
Data transfer
  • When transferring data from one table to another, you can choose how new tables and column names are transformed by using Mapping Rules.
  • Excel (XLSX) export supports columns auto-fit: you can customize column widths in DBeaver, export the data to Excel, and the output columns will be the same width as the original columns.
Schema compare:  
  • The results of change tree migration can be exported to a text file.
  • Schema compare task scheduling was fixed.
Databases
  • Added many improvements for Clickhouse, Google Spanner, DB2, Databricks, Greenplum, Exasol, Firebird, Infux, Materialized, MongoDB, MySQL, OceanBase, OpenEdge, Oracle, PostgreSQL, Redshift, SQLite, SQL Server, Snowflake, Teradata, and Trino.
Localization: Brazilian Portuguese and Chinese Simplified translations were enhanced.  

DBeaver Team Edition web

  • An AI assistant in the SQL editor has been added for convenient query writing;
  • All embedded drivers are disabled by default. Administrators can re-enable them in the Server configuration.
AI assistant:
  • Added support for Azure OpenAI and OpenAI LLMs;
  • Added ability to translate native language query to SQL query statement with AI assistant in the SQL Editor.
Cloud Storage Services:
  • Work with Amazon S3 and Google Cloud storage;
  • Upload new files to the bucket from your local machine;
  • Download files to your local machine;
  • Delete and rename files;
  • Read, edit, rename, and delete scripts;
  • Drag-and-drop files between buckets and different file systems.
Administration:
  • Added up-to-date instructions to the Version Update section.
Authorization:
  • The SSL option is available for establishing connections to SQL Server and Redis.
SQL Editor:
  • The Output tab has been added, which includes warnings, info and notices generated by the database when executing user queries;
  • Support for using custom delimiters has been added in MySQL;
  • Fixed an issue in the SQL editor where it was impossible to switch the active schema when working with Oracle databases;
  • Added ability to select shared connections for private scripts;
  • Private connections can be chosen for shared scripts, but this change won’t be saved to the script file.
Data Editor:
  • Scrollbars have been made system theme-independent;
  • Added the ability to edit binary values in a table;
  • Added the ability to count the total number of entries in the table.
Connections:
  • The ‘Save credentials’ checkbox has been removed from a template creating form as credentials are not stored in templates.
New drivers:
  • Influx 3 supported.
  • The custom options in the connection dialog for some drivers have been updated to provide the possibility of setting up the additional connection parameters:
  • Azure Databricks
  • Teradata; 
  • Timestream; 
  • YugabyteDB; 
  • Athena; 
  • Google BigQuery;
  • Exasol;
  • HANA;
  • Oceanbase; 
  • Snowflake; 
  • Google Cloud Spanner; 
  • TiDB;
  • Vertica.
Upgraded bundles in drivers for security improvements:
  • AWS Keyspaces;
  • BigTable;
  • Couchbase;
  • Redshift;
  • ClickHouse;
  • TDengine;
  • Apache Drill;
  • Apache Calcite Avatica;
  • Apache Arrow.
  • Many minor bug fixes, enhancements, and improvements have been made.