InterSystems Open Exchange Applications March 2022 Digest

Fix SendSynch and Async

v1.0.3

Fix BusinessHost for adaptors

v1.1.0

Python messages now have to be dataclass Better serialization between Python messages and Objectscript ones Various Small fixes Support of Business Process

added proxy mode

Added export / import for generated JSON object to to/from file

v0.1.1

fixed typo

v0.1.2

added show method for display of the file on demo facility

• Added export/import to file
• added file viewer for Online Demo

New Features
Added support for Elasticsearch Added basic support for MongoDB and BSON data viewer Added support for Presto Added support for Trino Driver Manager - Improved the driver management to support download drivers from Maven, version selection, and more Added an installer for Apple Silicon, M1 SQL Commander/SQL Editor - A new feature to search across all open commander windows

Improvements
Connection Setup -Allow copying the actual database URL from the link Connection Setup/Driver Manager - Add possibilities to set overridden driver properties centrally Driver properties with pre-defined list of values should be promoted in a drop-down Connection Setup SSH - Add support for ssh-agent with SSH Tunnel DB Support: Exasol - Add "certificate Fingerprint" for Exasol connections DB Support: Google BigQuery - Add driver entry for Google BigQuery DB Support: Greenplum - Add "Rename Schema" in PostgreSQL DB Support: H2 - Add "Rename Schema" in PostgreSQL DB Support: Netezza - Add "Rename Schema" in PostgreSQL DB Support: PostgreSQL - Add "Rename Schema" in PostgreSQL DB Support: Redshift - Add "Rename Schema" in PostgreSQL DB Support: Snowflake - Add "Rename Schema" in PostgreSQL DB Support: Yellowbrick - Add "Rename Schema" in PostgreSQL DB Support: Oracle - Copying a scheduler job can only be created in connection user's schema DB Support: PostgreSQL - Add "CASCADE" to Truncate DB Support: SingleStore - Create driver entry and database type for SingleStore DB Support: Snowflake - Improve support for authenticator=externalbrowser Database Objects Tree - Give the option (or by default) to color visited table names Driver Manager - Dynamic OS specific libs should be loaded from driver jar files rather than setting java.library.path Filtering/Filter Sets - The Database Objects Filters editor should show and allow editing the label1 attribute for DataNodes Grid Component - Add a "Reset Grid" action to remove any current quick filters, column filters, sorting, and selection Installation/Update Installation - Should be possible to change the location of included user.vmoptions referenced in dbvis.vmoptions Installation/Update Installation Web - Remove the UNIX installers, replaced by Linux installers Performance/Stability - Increase the default value for -Xmx from 768m to 2048m SQL Commander - Reload of file should preserve current selection, scrolling, and caret position SSH - Support openssh config behavior to handle append, prepend and removal of algorithms Scripts - Open multiple script files at once Bugs Fixed
Driver Manager - Unknown driver properties sent to database

Adds Info.cls class for version Info

Fails more gracefully if there's nothing to monitor for coverage