Keep up with latest product news
Fix bug when generating SAML token using IBSP.CONN.SAML.BO.SAMLcos Business Operation
colorFormula
now taken from data properties and can define formula in a css way to calculate color of polygon:
hsl((255-x)/255 * 120, 100%, 50%)
rgb(0, x, 0)
x
- relative data value from 0(minimum value) to 255(maximum value)hsl(193 + x/255 * (235 - 193), 100%, 50%)
Added telegram bot transport.
Sending emails corrected.
More info in description.
New article
Visual Trace and the freedom of choice
New environment to test the app
Demo enabled
Fix deploy for ZPM
12.1 released on 2021-07-13
Improvements
Database Profile Enable database profiles in DbVisualizer Free
Filtering/Filter Sets
The objects filtering grid should allow re-arranging rows with DnD and new move actions in the right-click menu
General
Add new startup dialog for DbVisualizer Free users
Add new Help->Welcome screen to guide new (and current) users
Provide a demo database with DbVisualizer
Grid Component
Support multi line selection and move rows with DnD and actions in grid columns chooser dialog and also in database objects filter panel
OS Support Windows
Native window decorations and embedded menu bar in Windows 10
OS Support: Windows
Theme: FlatLaf
Add setting to control the embedded toolbar in Windows 10+
OS Support: Windows
Theme: FlatLaf
Tool Properties
Allow setting application font (in addition to the existing grid and editor fonts)
SQL Formatter
Separate format settings for SELECT and DECODE
Scripts
Add capability to mount any directory in the Scripts tab
See the discussion here
Theme
Remove the optional theme selector dialog at startup and the "Ask at Startup" checkbox in the Appearance tool property pane
Theme: FlatLaf
Improve visibility of tab label in dark them using custom background color
Compare
Support compare for explain output in text format
DB Support: Azure SQL
Add support for MFA (ActiveDirectoryInteractive) authentication
Bugs Fixed
DB Support: PostgreSQL
RULE objects are not shown for Tables in PostgreSQL
Compare
Compare grid ignores differences
DB Support: MySQL
Data tab
Data changed in a SQL commander is not visible in the Data Tab
DB Support: PostgreSQL
DDL Generator
Some data views are unavailable when in evaluation mode
Data tab
The visibility of the Data tab filter pane is not preserved at restart
Database Profile: View
DataView could not be created for viewer='xxx'!
DB Support: MySQL
The default useSSL=false driver property is converted by driver to useSSL=true if not explicitly set to false as a parameter at connect
DB Support: Oracle
Stopping an execution in Oracle closes the connection
DB Support: Oracle
Database Objects Tree
When cancelling a database query in a DataView grid, connection may close
DB Support: Redshift
Upgrade the Redshift driver to version 2.0.0.7
Export
Export in XLSX to an existing read-only file doesn't show any error
"The workbook already contains a sheet named X" error when export in Excel format
Export/Import User Settings
Trying to import an invalid file such as Excel in File->Import User Settings results in an error
OS Support: Windows
IllegalStateException: Stopwatch already started
SQL Commander
Reload in the result set tab and then stop while fetching results, yields in no partial result set being displayed
SQL Formatter
Formatting function in SQL editor will alter SQL statements making them incorrect
Cell Viewer/Editor
DEVENV
Java 11
OS Support: Windows
Cursor problem in Cell Editor
DB Support: Exasol
DB Support: Vertica
Query Builder
Autojoin fails to join on FK/PK in Exasol and Vertica
Export
Some files created with "Save as Default" in the export object features are not handled in export/import settings
Query Builder
The elements to JOIN cannot be identified error
Connection Setup
Message when Ping Server is not supported needs to be improved
Connection Setup
DB Support: Greenplum
DB Support: PostgreSQL
DB Support: Redshift
DB Support: Yellowbrick
.pgpass file is not properly reading escaped tokens
Unclear error message when unable to read .pgpass
DB Support: Oracle
Change Password for Oracle is broken since clicking it doesn't show the field for New Password
DB Support: PostgreSQL
Search path is not set when running Explain plan
Importing to new table with "drop existing table" enabled, fails if there is no existing table
DB Support: Snowflake
DDL Generator
View definition is not visible
Import
Selecting data type BLOB/CLOB in import table data prevents it from being changed
Some settings are not loaded from import settings file
SQL Commander
Error opening right-click menu in new SQL Commander tab
SSH
SSH config file parsing is case sensitive
Made improvements and additions in Kano MDM modules.
From the new functionality, the following should be highlighted:
added demo production, flow for monitoring production, and dashboard for it
tooltipProperty
(#222)postMessage
: // hide map controls
iframe.postMessage({ type: 'map.applyStyle', selector: '.ol-control', style: 'display', value:'none' });