| Product Features | Database DevOps | New Features- Data Sources: Added support for ShardingProxy, MaxCompute, Redshift, TDSQL PostgreSQL (including Oracle mode), HaishanDB, YashanDB MySQL, and OpenSearch, extending Database DevOps coverage.
- Structure Design and Release: Supports generating change scripts from Gitee file-version diffs, then creating a new task or adding the scripts to an existing task if required. Added a script task type to support cross-environment release chaining for CI/CD orchestration in strictly isolated environments.
- Role Management: Added child-role management, enabling business teams to manage their own permissions, and supports creating similar roles.
Feature Enhancements- Data Sources: ES data sources can now be connected without a username or password.
- Structure Design and Release: Optimized configuration to support permission controls for strict change mode, same-database changes, and node promotion.
- Permissions: SQL Console, SQL Tasks, Data Export, and Data Import can hide databases, schemas, and tables for which the user has no permission. The permission-application entry remains visible, and the behavior can be switched at tenant level.
- Data Import: Added support for openGauss, GaussDB, ClickHouse, Doris, DWS, Greenplum, AnalyticDB PostgreSQL, StarRocks, SelectDB, GBase8s, and Klustron through DevOpsMatrix integration.
- Data Export: Added support for StarRocks, SelectDB, GBase8s, and Klustron.
- Data Export: Supports selecting SQL syntax types for export if required, including
select, create temp table, insert, and into select, for temporary-table export scenarios. - SQL Tasks (OnlineDDL): OnlineDDL task details now display binlog production and consumption positions, production and consumption rates, and estimated network bandwidth.
- Approval Processes: External approvals support multiple applications of the same type. Hovering over a built-in approval process displays custom approval-node names. Version upgrades support flexible multi-factor approval-process configuration. Extended external approval fields support database-group scenarios.
- SQL Console: SQL Server supports keyword searches across object types and adds visual editing for non-table objects.
- SQL Console: Result-set export supports CSV with UTF-8 with BOM encoding on Windows.
- SQL Console: When generating table-creation statements and functions for PostgreSQL (including AnalyticDB PostgreSQL and Greenplum), adds related authorization and compression-parameter statements and improves partition-table display information.
- SQL Console: Supports querying Oracle XML objects.
- SQL Console: Optimized result-set row copying so copied content automatically fills Excel cells when pasted.
- SQL Development Policies: Added a policy for special DML/DDL table names and optimized NoSQL command categorization for faster configuration.
- Sensitive Data Protection: Data masking and sensitive-data scanning now support GaussDB, openGauss, Dameng, Kingbase for Oracle, Kingbase for PostgreSQL, and RedShift.
- Sensitive Data Protection: Only users with Sensitive Data Management permission can manage the sensitive-data page.
- Sensitive Data Protection: Added an exact column-name matching algorithm for sensitive-data identification.
- Sensitive Data Protection: Improved data-masking algorithms; non-MySQL data sources now support various partial-masking algorithms.
- Slow Query Analysis: Added support for OceanBase MySQL, OceanBase Oracle, Dameng (centralized), TDSQL PostgreSQL, TDSQL Oracle, PolarDB Oracle, PolarDB-X, and VastBase.
- Slow Query Analysis: Added support for Oracle RAC slow-query collection.
- MongoDB: Further enhanced the MongoDB parser to identify and intercept high-risk commands.
- Audit Logs: SQL audit logs now record AK information from OpenAPI calls.
- AccessKey Management: Administrators can control whether an account may use AKs. After AK use is enabled, users can create and manage their own AKs; multiple AKs are supported.
- Email Configuration: AWS SES can be used for email notifications.
Bug Fixes- Slow Query Analysis: Fixed slow-query filtering issues for PostgreSQL and Oracle.
- User Management: Dedicated Cluster SSO user information now displays the username together with the login name.
|
| Product Features | AI AGENT | Feature Enhancements- NineData Skill: Added Data Export and Data Import to the existing SQL execution and SQL ticket capabilities. Agents using NineData Skill can import and export data under data security controls.
- Model Configuration: Optimized NineData large-model configuration and added model-configuration testing to quickly verify configuration accuracy.
- ER Diagrams: Expanded NineData ER diagram support to PostgreSQL, Oracle, and SQL Server.
- ChatDBA: Added support for content export to share content within organizations.
- ChatDBA Performance Diagnosis: Supports TiDB, OceanBase MySQL, OceanBase Oracle, Dameng, TDSQL, GaussDB, PolarDB Oracle, VastBase, MariaDB, and Percona.
- ChatDBA Performance Diagnosis: Supports integrating collected slow-SQL data for slow-SQL analysis and optimization.
|
| Product Features | Data Replication & Comparison | New Features- Data Replication: Added support for 131 data replication paths. For details, see NineData Community Edition Data Replication.
- Data Comparison: Added support for 131 data comparison paths.
- Vastbase G100 MySQL: Data Replication and Data Comparison support Vastbase G100 MySQL as both a source and a target database.
- Vastbase G100 PostgreSQL: Data Replication and Data Comparison support Vastbase G100 PostgreSQL as both a source and a target database.
- Vastbase G100 Oracle: Data Replication and Data Comparison support Vastbase G100 Oracle as both a source and a target database.
- OLTP > Kafka: Enhanced data synchronization to integrate with Schema Registry and stream historical and incremental data to the target Kafka in Avro message format.
- Incremental Sync Position Management: Added support for displaying sync positions by multiple timestamps and SCN values, updating read and write positions, and restarting tasks for specific operations and maintenance scenarios.
- Data Replication OpenAPI: Supports creating and managing data comparison tasks together when creating or modifying data replication tasks.
Feature Enhancements- Oracle Data Synchronization: Added batch-by-table and dependency-conflict detection synchronization modes to meet the write-performance needs of different business models.
- Distributed Database Replication: Added aggregation of performance metrics at the parent-task level by pre-aggregating data from all child tasks, improving performance-query efficiency.
- OLTP > Kingbase Oracle: Optimized incremental replication performance, doubling performance for large transactions.
|