Updated module for new ipm

SQL DATA LENS now FREE for using with free databases like the IRIS Community Edition!

The licensing system has been completely revised to make it easier for users to enjoy the benefits of SQL Data Lens .
The former “Home Edition” has been replaced by a new Free Edition, with all previous restrictions —
such as localhost-only access or limits on the number of connections — completely removed.

The Free Edition now supports any database connections to the free, community, or developer editions.
For example: Intersystems IRIS Community Edition, Microsoft SQL Server Developer Edition – SQL Data Lens also provides free, persistent access to free database systems including DuckDB, PostgreSQL, Trino, H2, Apache Derby, and SQLite.

ENH : TableViewer : More details for Intersystems IRIS per Table in Grid available, e.g. LAST_COMPILED, OWNER
ENH : TableViewer : Refresh table view after tune table for entire namespace
ENH : TableViewer : The repeated calculation of the table size added up with each run, so that the value was only correct on the first run.
ENH : SQLite driver upgraded sqlite-jdbc-3.49.1.0.jar
ENH : MariaDB driver upgraded to mariadb-java-client-3.5.3.jar
ENH : MySQL driver removed
ENH : DuckDb upgraded to 1.2.2.0
FIXED: “Nullpointer: Name cannot be null!” happend while opening the SQL Editor on some connections

Initial Release

Add Dependency in ZPM Module

Include java files

Added the ability to export excel workbook to CSV file.

Initial Release

Initial Release

Initial Release

Initial Release

Escape CR LF in Export to CSV

Export to CSV

Allow long text in Merchant column

Initial Release

[2.11.0] - 2025-04-23

Added

• Pull event handler that does an IPM uninstall and load to handle deletes (#631)
• Partial support for production decomposition with the new interoperability editors
• Added Lock Branch setting to prevent switching branches for a protected namespace (#709)
• Tooltips on branch operations in Git UI (#725)

Fixed

• Changing system mode (environment name) in settings persists after instance restart (#655)
• Popping from stash is more responsive (#687, #747)
• Favorites links for Git pages now works on recent IRIS versions (#734)
• IDE editing of decomposed productions now properly handles adds and deletes (#643)
• Fixed error running Import All when Git settings file does not exist (#713)

New an improved SQL scripting features. With just a click, it can generate comprehensive integrity checks for Tables, Views, and Stored Procedures—saving time and helping you stay ahead of hidden data quality issues.

Updated to InterSystems IRIS Version 2025.1.0.223

ENH : Some small improvements, like Execute Toolbar button now with text
ENH : Testing connections are now limited to show only 5 namespaces to prevent the UI from getting to big
ENH : Many internal libs upgraded (like POI 5.3.1)
ENH : TableViewer : Table sources (DDL) is improved and handle IRIS default entries for AUTO_INCREMENT columns correctly
ENH : Data Pumper : New feature to copy data from one table to another table, also between different databases and namespaces
ENH : SQL Editor : Improved error handling for values that do not match metadata
ENH : General : A new toggle button on the main toolbar to configure handling for read errors globally

Vector Search with InterSystems IRIS 2025.1

New namespace added: DATATYPE_SAMPLE

This sample database is designed to analyze error scenarios in which column values do not conform to the data types and constraints defined in the metadata. The goal is to understand and evaluate the behavior of the database and associated drivers (JDBC, ODBC, .NET) in such cases.

When tables are created and modified exclusively via SQL, inconsistencies between data and metadata should be practically impossible. Even when accessing the database through object layer, proper validation is expected to enforce metadata compliance.

However, inconsistencies like those demonstrated here can occur when applications used direct Global Access, potentially bypassing built-in protections such as type checks or constraint enforcement. This is especially relevant in legacy systems.

Initial Release

Youtube video https://youtu.be/bTv2GUdlHJo

WorkList use case added

Updated swagger version

In the area of new functionality development, the following innovations should be noted:

1. System Upgrade. Moved to IRIS version 2023.1.3 , ensuring higher stability, performance, and compatibility with the latest technologies.
2. Optimization of Internal Queries. With version 2023.1.3, the approach to installing the CSP-gateway and web server has been revised. In response to these changes, the internal queries of Kano MDM have been optimized, ensuring seamless adaptation to the new architecture and maintaining stable, reliable performance on the updated platform.
3. Improved security configuration. Implemented advanced security settings to provide a new level of data protection.

The following modifications and additions have been implemented in the Kano MDM modules:

1. Flexible Password Settings. Updated the settings for creating custom passwords, providing more options for customising them and improving user-friendliness.
2. Expanded Capabilities of the Constructor:
   • Added the ability to display the created field of the ‘Directory’ type as a separate form.
   • Directory fields have been moved to a dedicated tab, improving visual clarity and user experience.
   • Columns of the directory grid are also moved to a new tab,providing a cleaner and more intuitive data view.
3. Simplified Directory Management: All properties are now placed on a separate tab when creating a directory, making the configuration process more user-friendly.
4. Deleting a group of fields. The functionality for deleting field groups through page-by-page selection has been improved. Now it is possible to navigate between pages and continue selecting fields for deletion — all selected elements remain marked until the operation is complete.

Implementing the latest versions and technology updates has been an important step in improving the system. All changes are aimed at increasing performance, usability and security, considering modern technology standards and requirements. Each update ensures that Kano MDM is up-to-date, adaptable to new challenges and user needs, and aligned with high standards of efficiency and security.

• Fix bad return type for impl class generated methods

• remove unused requirements.txt file

[1.0.0] - 2025-04-07

Added

• Support for connecting to InterSystems IRIS instances to generate class diagrams directly from server
• New command for generating InterSystems class diagrams
• Integration with IRIS REST API for fetching class information
• Ability to browse class details in the IRIS Management Portal by clicking on diagram elements
• Support for navigating to class, method, and property definitions in IRIS Documatic

Changed

• Improved error handling and feedback for connection issues
• Enhanced SVG rendering and interaction capabilities
• Optimized diagram generation process
• Updated UI for better user experience

Fixed

• Correct URL format for opening classes in IRIS Documatic
• Fixed clicking on class elements in SVG diagrams
• Resolved issues with diagram rendering in different environments

Removed

• Test IRIS connection command and related functionality

Added Vector Search Agent (RAG functionality)

Enhanced MCP Server functionality.
Added Start and Stop production functionality.