Release Notes (2.12)
This page describes the major changes in version 2.12, including bug fixes that may affect how you work.
Managed Queries Improvements
The capabilities of Managed Queries have expanded in 2.12. Users using managed queries can now:
-
Permanently delete and recover both managed queries and managed query groups.
-
Make SELECT, UPDATE, INSERT, and DELETE statements.
Additionally, built in capabilities have expanded to include:
-
Validation before managed queries are run or saved to ensure users have the required privileges for the table referenced.
MySQL Support
Users can now import MySQL tables as schema definitions, load data from MySQL sources, and promote data back to MySQL.
SQL Editor Improvements
The SQL Editor now supports running additional SQL statement types beyond SELECT. Standard SQL and application privileges continue to apply.
Users can execute multiple SQL statements in a single run, separated by semicolons. For example, CREATE TABLE operations require the %CREATE_TABLE privilege.
Snapshots
Editing Snapshot Column Metadata
Users can now edit snapshot column metadata after parsing a snapshot SQL statement. Editable fields include column name, datatype, precision, scale, and maximum length. Changing a datatype triggers schema evolution, resulting in a new snapshot table.
Snapshot Tags in Promotion Activities
Promotion activity SQL now supports a new placeholder format for snapshots: {Snapshot.(SnapshotName)}. At runtime, this is replaced with the latest snapshot table name.
Renaming a snapshot automatically updates all referencing promotion activities, except for those in draft. Deleting a snapshot will disable or remove referencing activities depending on whether the deletion is logical or permanent. Recovering a snapshot allows users to re-enable previously disabled activities.
Salesforce Support for External Promotion
Users can now configure Salesforce as a promotion target, enabling recipes to push curated data from InterSystems Data Studio into Salesforce tables.
This enhancement allows Salesforce to be used alongside existing external promotion targets and follows the same promotion workflow and configuration process.