LDW 2.3.21: Studio MacOS 11 compatibility, external process stdOut/stdErr

The first release in 2021 brings again a number of smaller improvements. Most importantly, for our MacOS users, we updated the Studio to a more recent version of the Eclipse platform which enables compatibility with MacOS 11 Big Sur. If you plan to upgrade to MacOS 11, please open a support request with us to update your Data Virtuality installation before.

We also improved the ability to invoke processes on the server's operating system by calling SYSADMIN.execExternalProcess. In previous versions, this procedure was returning the exit code, but no actual output of the process. Now, the procedure returns stdOut and stdErr:

Please note that the length of stdOut/stdErr captured by Data Virtuality is limited to 100.000 characters for performance reasons. If your process generates large output, please redirect it to a file and create a file data source in Data Virtuality to read it.

Studio

• DVCORE-7192 (Improvement): add ability to copy/move a single view/procedure
• DVCORE-7191 (Improvement): allow disabling "Save SQL files?" prompt when closing an SQL editor tab
• DVCORE-7189 (Improvement): improve several context menu item names
• DVCORE-7185: the Studio is incompatible with MacOS 11 Big Sur
• DVCORE-7202: the "Day of week" cron property is incorrectly mapped in the "Add job schedule" and "Edit schedule" wizards

Connectors

• SQL-324 (New Feature) Freshdesk: add a possibility to download historic tickets data
• DVCORE-7179 (Improvement) Snowflake: add support for encrypting data-at-rest before uploading it to the Azure Blob Storage
• DVCORE-7200 Snowflake: parallel replications fail for Microsoft Azure Blob Storage upload modes if the "containerName" property is set and tables' structures differ
• DVCORE-7159 Salesforce: COUNT with a WHERE ... IN clause returns no value
• DVCORE-6625 PostgreSQL: usage of SQL_TSI_FRAC_SECOND in TIMESTAMPADD function results in error
• DVCORE-7247 PostgreSQL: pushdown for FORMATTIMESTAMP with year set as yyyy resolves wrongly
• DVCORE-7244 Google Analytics: NullPointerException in getV4 procedure when dimensions are NULL
• DVCORE-7218 BigQuery: JOIN queries containing subqueries with a GROUP BY in the FROM clause are not pushed down
• DVCORE-6946 NullPointerException occurs for MSSQL and Azure Data Warehouse tables used for view with UPPER() function
• DVCORE-6285 FLOAT and DOUBLE Infinity and NaN values cannot be replicated to Redshift
• DVCORE-6283 FLOAT and DOUBLE Infinity and NaN values cannot be replicated to MSSQL

Backend

• DVCORE-7173 (Improvement): Add ability to encrypt Java keystore/truststore passwords
• DVCORE-7132 (Improvement) Extend the SYSADMIN.execExternalProcess procedure to return the results of the command sent to stdout and stderr
• DVCORE-7093 Virtual Databases: running an EXPLAIN query in a secondary VDB causes redirection of all further queries to the main VDB
• DVCORE-7236 Virtual Databases: using SYSADMIN.setCurrentDWH procedure in one virtual database resets the Analytical Storage in all others
• DVCORE-5727 Virtual Databases: secondary virtual databases are not initialized on bootstrapping
• DVCORE-7171 Data Virtuality Exporter: purging attempts to delete system user
• DVCORE-7229 SQL job run fails when the job script contains UNPIVOT with double quotes
• DVCORE-7215 Dependent jobs never get triggered again if they were running or disabled once at the moment of triggering
• DVCORE-5174 Job execution gets interrupted on disabling or deletion of the schedule which started it
• DVCORE-3925 CSV export fails if column name with a hyphen is passed as a value of "orderBy" parameter