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.
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
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.
In the area of new functionality development, the following innovations should be noted:
System Upgrade. Moved to IRIS version 2023.1.3 , ensuring higher stability, performance, and compatibility with the latest technologies.
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.
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:
Flexible Password Settings. Updated the settings for creating custom passwords, providing more options for customising them and improving user-friendliness.
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.
Simplified Directory Management: All properties are now placed on a separate tab when creating a directory, making the configuration process more user-friendly.
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.