Team Edition 23.2

September 12, 2023
Changes since 23.1:
  • 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.
  • Administration
    • New Settings panel displays the product configuration settings such as Minimum fetch size, Maximum fetch size, and Default fetch size from the Data Editor;
    • ‘Connection Management‘ tab has been renamed to ‘Connection Templates‘ – now only connection templates are displayed;
    • License removal is available through the interface.;
    • Query manager: add filter by anonymous users;
    • Query History for Anonymous Users has been added.
  • Task scheduling was significantly improved: user can get 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.
  • Notifications:
    • Notification management was improved: now you can choose in Preferences when you need a notification and if you need a sound for it
    • Notifications in Dark theme became readable
    • ‘Tip of the day‘ was updated, and now shows OS-specific shortcuts properly.
  • SQL Editor:
    • User can configure the options on the toolbar by pressing the gear button in the editor
    • Spelling errors and other annotations work in console mode
    • Spelling works with URLs and non-letters at word boundaries
    • Auto-proposals now respect the option ‘Empty line is a query delimiter‘
    • Auto-proposals calculation performance was significantly improved in some cases
  • AI: New GPT 3.5 Turbo 16К model was added
  • 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.
    • Dictionary viewer panel UI was redesigned
    • Folding in the XML presentation was fixed
    • Users can see chart presentations for non-numeric values, for example, for salary or grades
    • Filters/orderings/colors reset UI was significantly improved
    • Grouping panel icons were improved
    • Many minor UI improvements were made
  • Data transfer: 
    • Import of multiple sheets from an XLSX was implemented
    • Issue with exporting a table without data when using bulk loading was fixed
    • Table information for tasks with broken connections was fixed
    • Lazy initialization of configuration pages was implemented
    • Issue with the duplicated file selector dialog was fixed
    • Export in XML format was fixed (the doctype section is now not optional)
    • Issue with long filenames on Windows was fixed
    • Previous export settings loading was fixed
    • Import settings handling was improved 
  • Database tasks: users can now see that the task is still running (we have added ‘In Progress‘ status)
  • Accessibility
    • Connection dialog now supports screen readers
    • Cell value reading was improved
    • Ctrl+Shift/Alt+PageDn: vertical tabs switch
    • Ctrl+ALT+6: SQL editor and results tab switch
    • Ctrl+Shift+Enter now opens ER diagram entities
    • Ctrl+Shift+N: new connection dialog open
    • 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.
    • SQLite driver version was updated due to the vulnerability CVE-2023-3269.
  • 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.
  • Access Management
    • The ability to unlink SSO credentials from user has been implemented;
    • Reverse Proxy authentication includes the option to provide users’ First name and Last name;
    • The label for proxy user has been added.
  • 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.
  • Navigation tree
    • Filters for the Navigation tree allow hiding and showing schemas within the interface;
    • The search request considers file names and excludes the .sql file extension.
  • 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;
    • We have improved the UX in the search bar – users can delete a query or request by clicking on the cross icon;
    • We have improved functionality by adding support for displaying tables with nested arrays of objects;
    • The ability to compress files during export allows for faster download speeds, particularly for larger files.
  • Driver management
    • Custom settings have been added to the interface for the following dialogue connections: SQLite, DB2, SQL Server, MySQL, Oracle and PostgreSQL;
    • Unable to upload\select multiple files for Driver Management;
    • BigQuery issues were fixed;
    • Trino driver has been updated;
    • Timestream issues have been fixed;
    • The private key authentication type for Snowflake has been added;
    • New field can be set for DocumentDB.
  • Visual Query Builder
    • Users have the ability to use custom aliases in the Visual Query Builder
    • Users can highlight foreign key columns in the Visual Query Builder by clicking on the join link.
  • 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.