Team Edition Release Notes

24.3

December 9, 2024
General:
  • The new DBeaver Database Tunnel allows you to use the local Desktop client to securely connect to databases located on an isolated network with the Team Edition server.
  • Added detailed logging of GraphQL queries in the server logs, including all provided variables, for improved debugging and monitoring.
  • Resolved critical vulnerabilities related to unauthorized access and event notification processing.
Server administration:
  • Updated user storage mechanism: New user logins are now stored in lowercase to prevent duplicate entries (e.g., “ADMIN” and “admin”). Note: This update does not affect previously created user logins.
  • Added an ability to change a user password even if the user is disabled in a system.
  • Added the ability to synchronize the Team Edition user role with the custom role claim via logging/provisioning for all OpenID’s, Google and Microsoft Entra ID providers.
  • A new setting in Global Preferences was added to restrict data import in Web UI for non-admin users.
Configuration:
  • The ability to generate SSL certificates in the Domain Manager was disabled in earlier Team Edition versions before 24.3. Starting with version 24.3, this functionality is available again.
  • Added support for different global AWS regions: you can choose one global region for your product (Standard, Government and China).
  • Asia Pacific (Malaysia) and Canada West (Calgary) were added to the AWS regions list.
  • The management of custom and auto-generated certificates was enhanced: you can add and delete them at any time in the Domain Manager.
  • The administrator can specify the JWT provider’s role header and attribute, as well as the AWS role claim attribute.
  • A custom user group attribute can be specified for the OpenId provider during team creation to fetch a user’s team membership.
  • Enabled customization of the name attribute to include user ID for the OpenId provider.
  • Environment variables configuration was improved: you can configure more variables on the initial stage of the Docker setup.
Query manager:
  • Added the ability to automatically purge the Query Manager history after a certain period to control the size of the Query Manager database.
Data transfer:
  • Export in Parquet format was added.
  • JSON values can now be exported as embedded JSON.
Databases and drivers:
  • New drivers for working with files as databases – these drivers allow you to open files in the Data Editor, execute complex SQL queries, and work with files in cloud storage (AWS, Google Cloud). Currently, the drivers operate in read-only mode:
    • CSV Pro driver 
    • XLSX driver
  • LibSQL/Turso JDBC driver was added to all products. This is an open-source driver. For more details, refer to the driver repository.
  • New database drivers were added: 
    • DolphinDB driver
    • GBase 8s driver
  • Apache Drill, CouchDB, and DB2i driver were updated.

 

Team Edition Web

General:
  • Refreshed design for the User and Teams, Driver Management, and Identity Providers tabs in the Administration panel.
  • Added the ability to terminate a selected session in the Session Manager.
  • The connection Info tab is now hidden for non-admin users.
  • Keyboard navigation was enhanced. You can use the arrow keys to move through navigator tree elements and the tab key to switch between editors’ tabs.
  • Chinese localization was improved.
Query manager:
  • The filters section was redesigned. Now, it is more compact and precise.
  • Schema and catalog filters were added.
Data Editor:
  • Rows with focused cells are specially marked to make it easier to locate a position in large tables.
  • A new type of chart was added: the Line chart.
  • The ability to build charts based on float numbers was added.
  • The functionality to change sample count, row count, or aggregate column functions was added to сharts.

 

Team Edition Desktop

Administration:
  • The option to save and edit database credentials is now available for managers in the connection context menu.
SQL Editor:
  • Highlighting and validation were significantly enhanced, including the following: synonym highlighting and validation were introduced, and the pseudo-column highlighting was improved. Additionally, the query validation style was updated, and the number of issues displayed for each script query was reduced to improve the interface readability.
  • SQL console saving was redesigned (it now asks for confirmation).
  • Added an ability to select a part of SQL query between brackets using ‘Ctrl+Shift+]’ hotkey to improve script editing.
  • Added ‘Cmd+Enter’ shortcut on macOS for script execution in addition to ‘Ctrl+Enter’ due to the conflict with new system hotkeys in Sequoia.
Data Editor: 
  • JSON and XML text presentation was redesigned: edit controls were moved to the left, word wrap was added to the editor, and find/replace visualization issues were fixed.
  • Presentation and editing of composite data types were significantly improved.
Data Compare: 
  • Comparison tables with composite keys consisting of two or more columns became available.
  • Several performance improvements and bug fixes were made.
Data transfer:
  • Added an option “Delete export file if export fails” allowing to delete incomplete files created during the failed exports.
Connectivity: 
  • Added display of AWS SSO code during authorization.
General: 
  • The desktop application can now run again on Windows Server 2016, Windows Server 2012, Windows 8, and later versions.
  • Bottom toolbar layout in the object editor was unified for all tabs.
Databases and drivers:
  • Parquet driver added. This driver allows you to work with parquet files as a database. 
  • Apache Hive: added support for Hive 4.
  • Google BigQuery:
    • Composite data presentation was improved.
    • Procedures handling is now supported in SQL editor, including LOOPS, IFs, BEGIN END, and CASE.
  • Db2 z/OS: DDL generation for creating tables was added.
  • Teradata: 
    • Navigator now displays only the databases accessible to the user.
    • Fixed issues with multi-row inserts during data import, incorrect display of the PERIOD data type, and improved handling of maximum rows.
  • Added many improvements for Altibase, Azure SQL, Apache Hive, ClickHouse, CosmosDB, CouchDB, CUBRID, Db2 z/OS, DuckDB, MySQL, Oracle, PostgreSQL, Salesforce Data Cloud, SAP HANA, Snowflake, Trino, and Virtuoso.
Localization: 
  • Arabic localization was added.
  • Brazilian Portuguese localization was updated.

24.2

September 9, 2024
  • General
    • When administrators create, edit, or delete drivers, the changes are immediately applied in web and desktop UIs.
    •  
  • Databases and drivers: 
    • Huawei GaussDB: driver was added;
    • SQL Server, Cassandra, YugabyteCQL, Redshift, ClickHouse, Informix, HANA, Firebird, Apache Arrow, Apache Drill, and H2 drivers have been updated.
    •  
  • AI: Added new AI models: gpt-4o, gpt-4-turbo, gpt-4o-mini. Removed deprecated AI model: gpt-3.5-turbo-16K.

Team Edition web

  • Administration:
    • Added the ability to configure a custom domain and custom SSL certificate;
    • Added the ability to delete existing product domains for the current license;
    • Session Manager was added for different databases: you can easily track your current sessions in a database;
    • Redesigned administration navigation panel – now it is more compact and clear;
    • Added the ability to change the default commit mode for each connection separately.
  • Authentication:
    • Improved LDAP authentication: added the ability to filter users via service account parameters and ability to specify custom unique user identifiers;
    • The ability to specify more additional headers was added for JWT;
    • Added the “Session token” field to AWS temporary credentials;
    • Supported AWS GovCloud regions in the Cloud Explorer.
  • Databases and drivers: 
    • The result details panel was added to the Data Editor for BigQuery: now you can see statistics about the bytes billed, total bytes processed, etc.;
    • Added the “Keep alive” setting for Db2 LUW and IMB i, Apache Kyuubi, Clickhouse, Firebird, and Trino.
  • The option to save and edit database credentials is now always available in the connection context menu for non-admin users.
  • French language support was added.
  • All major CVEs in third-party libraries were resolved.

Team Edition desktop

  • General
    • Administrators can import projects from Desktop DBeaver products to Team Edition;
    • Administrators can now test connections when configuring database access for teams;
    • Developers can’t grant database access to all users anymore;
    • Users see a notification and need to relog into the application when administrators change their Team Edition role;
    • Users are logged out from the application when administrators delete their accounts from the system;
    • Added presentation of structural data types in table Properties;
    • Ability to disable all metadata queries. This can be useful for improving performance or reducing the number of queries to expensive databases;
    • Added import of configured connections from MySQL Workbench and other third-party database management tools;
    • Icons in Database Navigator and Data Editor were redesigned;
    • Italian and French localization was updated.
  • SQL Editor:
    • Added problem markers with semantic errors and warning descriptions. You can click on the problem description in the tooltip to find out what is wrong with the query;
    • Added highlighting, validation, and Outline viewer support for DDL statements: CREATE, DROP, and ALTER;
    • The database connection will be automatically closed when all related SQL editors are closed;
    • Auto-save in SQL Editor editor is enabled by default.
  • Data Editor: 
    • Indicators of the table status were added to the upper left corner of the grid.  When you hover the indicator, you can see a tooltip with detailed information about unique keys and the ability to edit this table;
    • Keyboard shortcut Ctrl+Shift+Alt+C allows you to use the advanced copy option with the latest settings without opening a popup window each time.
  • Data transfer: Users can email large task result files by splitting them into multiple parts in zip format.
  • Data Compare: 
    • Added an ability to compare results of custom SQL queries;
    • Big tables comparison performance was significantly improved.
  • Task management: Added new password option “Automation (console)”, especially for running scheduled tasks.
  • Connectivity: It is now possible to use custom SSM Documents to connect to AWS databases.
  • Databases and drivers:
    • Google BigQuery:
      • Legacy SQL dialect is supported;
      • Predefined monitoring dashboards were added to the Windows application.
    • Cassandra: Driver version was upgraded and added support for VECTOR data types.
    • Redshift:
      • Connection stability was significantly improved;
      • Role, User, and Group presentation was fixed.
    • Db2 z/OS: Native table DDL generation was added.
    • Added many improvements for Altibase, BigQuery, GaussDB, Cassandra, Clickhouse, CloudSQL – PostgreSQL, Couchbase, CUBRID, DuckDB, InterSystems IRIS, MariaDB, Neo4j, Ocient, Redis, Redshift, Salesforce, SAP IQ, SAP Hana, Snowflake, SQLite, SQL Server, Teradata, and Vertica.
    • Driver updates: Apache Drill, Apache Arrow, ClickHouse, Cassandra, Firebird, Informix, InterSystems IRIS, Redshift, SAP Hana, SQL Server, Yugabyte CQL, and H2 Server.

24.1

June 11, 2024
Main updates:
  • Now administrators have an easy way to create a server domain for the web application in the Easy config or Administration part;
  • Users can view the query history of their team if they have the Supervisor permission from the administrator.
Administration part:
  • Default user preferences can be configured in the web client for both UIs:
    • The Data Viewer: default fetch size;
    • The SQL Assist feature:
      • Use long object names (always use schema/catalog);
      • Insert table aliases;
  • The link to download the relevant version of the Team Edition desktop is now available in the Desktop client tab.
AI: Added support for custom Llama-based AI models. Databases and drivers: 
  • Neo4j driver support was significantly enhanced. The structured data can be presented in JSON or text format. Users can execute queries using Cypher query language;
  • DuckDB, Oracle, SQLite, Clickhouse, and Trino drivers have been updated.
General:
  • Changes in user preferences in the web application are now applied to the web and desktop UIs;
  • Users can skip checking an untrusted server certificate and run the desktop client;
  • Different driver vulnerabilities that could affect the Team Edition security were fixed.

Team Edition web

User authorization:
  • Added LDAP authentication;
  • Added the ability to assume AWS session with SAML without proxy user;
  • Implemented JWKS authentication support.
Data viewer and SQL editor: Added support for manual and automatic modes for committing changes to the database. Data transfer: Added the ability to import data to the database from CSV, XML, and XLSX  files. Accessibility: All popup dialogs became available for screen readers, including JAWS, to improve the experience for users with disabilities.

Team Edition desktop

Dashboards: 
  • Users can create custom web-based charts and add them to Dashboards;
  • Dashboard user interface was redesigned. Added the ability to drag and drop charts, add and edit them in one click using toolbar buttons, and customize the dashboard view.
Task management:
  • The new panel can be opened in the desktop application to view scheduled tasks from all projects;
  • Users can receive email notifications depending on the result of task execution and the presence of attachments;
  • Running tasks can be automatically canceled after the specified timeout.
Data Compare:
  • Comparison performance significantly increased. Users can now compare tables with millions of rows;
  • Users can export comparison results to HTML;
  • The user interface on the Key configuration and Column mapping tabs was improved.
SQL Editor:
  • Added the ability to use smart mode for statement delimiter in SQL scripts;
  • Supported Highlighting, validation, and outline for INSERT, UPDATE, and DELETE statements.
Databases and drivers:
  • BigQuery support was enhanced:
    • Added clustered table presentation;
    • Bytes processed/billed and other statistics can be presented in a new panel in the data viewer.
Localization
  • Romanian localization was added;
  • French localization was improved.
Detailed Team Edition 24.1 release notes.

24.0

March 12, 2024
Main updates:
  • Administrators can configure different database access for every team in one connection;
  • Administrators and developers can grant database access to all users;
  • Server configuration dialog was added to the desktop client.
Identity providers:
  • AWS authentication now supports external role configuration.
Administration:
  • Git configuration test button was added;
  • AWS Secrets Manager integration was added for database credentials storage.
AI assistant:
  • Added support for Google Gemini LLM;
  • Updated the list of available OpenAI models.
New drivers:
  • Firestore;
  • RisingWave.
Driver management: Added many improvements for BigQuery, ClickHouse, Dameng, DB2, DynamoDB, EDB, Firebird, Google Bigtable, Google Cloud SQL, Greenplum, Microsoft Access, MariaDB, MySQL, MongoDB, Oracle, PostgreSQL, Redis, Redshift, Salesforce, ScyllaDB, Snowflake, SQLite, SQL Server, Sybase, TDengine, and Teradata. Access Management:
  • Added the ability to automatically map Active Directory roles to specific Team Edition roles during user import;
  • Administrators can include themselves in any teams.
  Detailed Team Edition 24.0 release notes.

23.3

December 12, 2023
  • 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)
    •  
Detailed Team Edition 23.3 release notes.

23.2

September 12, 2023
  • Authentication. You can use new authentication providers — NTLM, Okta, AWS OpenId –  to log in to web and desktop applications, making the following types of authorization available: AWS SAML, AWS OpenId, AzureAD, Google, NTLM, Okta OpenId, OpenId, SAML.
  • User provisioning. You can import users from your AzureAD and Okta business accounts.
  • Integration with the Git version control system was implemented. User can keep project scripts, diagrams, datasets, connection configurations, bookmarks, and other data in a Git repository.
  • Task scheduling has been significantly improved: tasks run on the server, and the user can retrieve export result files in the desktop application.
  • Synchronization work better, and users receive notifications in the desktop application, when creating or deleting projects and connection folders. Configuration changes are also synchronized.
  • New drivers
    • Azure Cosmos DB
    • AWS Timestream (added to Cloud Explorer)
    • Amazon Neptune
    • Crate DB for Postgres
    • Kafka (available in Ultimate Edition)
    • Materialize (only in desktop)
    • Salesforce (JDBC driver created by DBeaver team)
    • TDengine 
  • Security: SQLite driver version was updated due to the found vulnerability CVE-2023-3269.
  • Localization
    • Traditional Chinese, Chinese Simplified, German, and Portuguese translations are improved;
    • Users can select Portuguese as the default language during installation.
     

    DBeaver Team Edition desktop

  • Tableau integration: you can connect to Tableau to edit Tableau custom queries in the desktop interface.
  • Connectivity
    • Now you can connect to a database using Kubernetes proxy. To configure it, click the ‘Network configuration‘ button in the connection dialog.
    • ODBC driver became more stable. It supports any database with the available ODBC driver,  the most popular once being Amazon Redshift, BigQuery, DB2, DB2 for IBMi, MariaDB, MySQL, Oracle, PostgreSQL, Snowflake, SQLite, and SQL Server.
  • Data Editor
    • Spatial data presentation is enhanced: you can copy coordinates, viewport bounds, and selection. You can also view PostGIS data and labels on the map.
    • Users can see chart presentations for non-numeric values, for example, for salary or grades.
  • Accessibility
    • Connection dialog now supports screen readers.
    • JAWS and Narrator support was improved for Data Editor and vertical tabs.
    • High contrast theme support was significantly improved. You can choose a high contrast theme in your OS, and the DBeaver high contrast theme is enabled.
  • Security
    • Certificate management was added: you can find CA certificates used for SSL access in the Trust store section in Preferences or import your own certificate.
    • Project and user password security was improved.
    • We have improved the security of storing user settings.
  • Databases
    • Google BigQuery: DDL for storage procedure is available.
    • Greenplum 7.0 is now supported.
    • Oracle:  XML presentation is supported.
    • PostgreSQL: Debugger was improved: we fixed many significant bugs and enhanced the performance.
    • Vertica: Stored procedures are supported, you can view and execute them. Execution plan is available, including JSON queries. 
     

    DBeaver Team Edition web

  • Performance: Pagination has been added to the Navigation tree and metadata viewer, allowing users to work with a larger number of database items;
  • Navigation tree: Filters for the Navigation tree allow hiding and showing schemas within the interface;
  • Access Management: The ability to unlink SSO credentials from user has been implemented;
  • Authentification: The SSL option is available for establishing connections in MySQL, PostgreSQL, Clickhouse, Mongo, Cassandra;
  • Connections: Connections can be pre-configured into the workspace in the Global Configuration JSON file and then displayed in the interface;
  • Data Editor
    • The ability to rearrange columns in the Data Editor has been added;
    • The ability to use custom functions in the Grouping panel has been added;
  • SQL Editor: Users can simultaneously edit resources, allowing them to work together;
  • Driver management: Custom settings have been added to the interface for the following dialogue connections: SQLite, DB2, SQL Server, MySQL, Oracle and PostgreSQL;
  • Security
    • Password autofill functionality has been removed;
    • The ‘eye‘ icon for password fields has been removed – the passwords entered into fields will not be displayed in the interface;
Detailed Team Edition 23.2 release notes.

23.1

June 14, 2023
  • User administration:
  • Team Edition Desktop became available for users with the Manager role.
  • Project management:
    • Notifications on getting access to a new project were added;
    • Synchronization and notifications of created/deleted projects were added;
    • Script and folder synchronization was improved in the desktop application.
  • Access Management:
    • The license grants access based on the current number of users, accommodating any decrease in the user count.
  • Authentification:
    • Azure Cloud service is officially supported in CloudBeaver Enterprise. Now databases from different clouds, AWS, GCP, and Azure, are accessible through Cloud Explorer simultaneously;  
    • We have resolved the window freezing issue during anonymous access;
    • The error with authentication for SAML/OpenID providers with enabled GCP services has been fixed;
    • The synchronization between assignment roles in SAML users and groups in CloudBeaver has been implemented.
  • Driver administration:
    • Modification of driver settings is now available via an additional administration tab called Driver Management;
    • The new option to add custom database drivers in the Administration menu is available.
  • Datasets:
    • Improvements have been made to the datasets UI in the Team Edition Web; 
    • Users can now save query results as a dataset and copy an existing dataset in the desktop application;
    • The ability to edit datasets was added in Team Edition Web.
  • Query manager:
    • Displaying the Projeсt or the connection has been added to the query;
    • Ability to sort by Project in Query Manager.
  • General improvements:
    • The issue with freezing the desktop application on the startup after creating ER diagram was fixed;
    • Tips of the day were revised.
Detailed Team Edition 23.1 release notes.

23.0

March 13, 2023
  • General improvements:
    • The installation screen on macOS was changed;
    • The “Workbench has not been created” error was fixed;
    • Incorrect behavior pressing on the Cancel button at the first start was fixed;
    • The issue with ​​deadlock when having an open ERD diagram during startup was fixed.
  • Connections:
    • Proxy database connections through the server were added;
    • Reusing auth SSO tokens in order to work with Cloud Explorer and connect to cloud databases was added;
    • The logout on refresh token expired error was fixed.
  • Datasets: 
    • A new concept of dataset file type was created.
    • Support files with multiple queries, diagrams, bookmarks, and dashboards;
    • Filtering, editing, exporting, and loading of datasets;
    • Datasets visualization: grid, chart, text, JSON;
    • Join multiple datasets;
    • The search of datasets.
  • Project management:
    • Storing datasets in Shared Projects;
    • Publishing of datasets to shared projects on demand;
    • Private folders in shared projects;
    • Async project loading was fixed;
    • Subscribe to events for open projects only;
    • Team Edition fails if no projects provided bug was fixed.
  • Task management:
    • Composite, Shell, and Data Compare tasks were added. 
  • User administration:
    • The administration window was improved;
    • New license roles support (Data Manager, Data Editor, Viewer);
    • Permission management was added to Projects;
    • Disabling the ability to open the Cloud Configuration Manager for Editor and Manager roles was implemented.
  • Resource Management: 
    • The issue with synchronizing new folders with the resource cache is solved;
    • A message showing when changes are made to shared connections or scripts was added;
    • The issue with disappearing new folders after the restart was fixed;
    • Browse folders in the SQL Script Manager.

22.3

December 13, 2022
  • General improvements:
    • Validate server API version in desktop clients was added
    • Visual remote invocation progress was added 
    • The refresh function for connections and resources was added
    • Administrator and Development roles with preconfigured permissions were added
    • The display of license information in DBeaver UI was added
    • Asynchronous web requests execution was added 
  • Administration
    • The option to edit shared projects by admin was added 
    • The option to create projects by admin was added 
  • Resource Manager
    • Read-only projects support was added
    • Shared credentials support was added 
    • Tasks configuration stored in the Resource Manager 
    • Custom driver jars stored in the Resource Manager  
    • Drivers configuration is stored in the Resource Manager
    • The global configurations storage was added