Skip to main content

2024

April

Release Date
Module
Function
Release Details
Related Links
04-18Database DevOpsNew SQL Development RuleAdded rule for configuring the limit of Binlog file size in data tracking tasks. If the Binlog file size exceeds the configured threshold, it will be intercepted during the pre-check phase, and submission of data tracking tasks will not be allowed.Database DevOps Rules Overview
04-18Database DevOpsSQL ReviewNineData SQL Review now supports OceanBase Oracle data sources.SQL Audit
04-18Database DevOpsData TrackingNineData data tracking feature added the rollback SQL download function.Data Tracking
04-18Basic ServicesNew Data Source SupportAdded support for adding OceanBase for MySQL data sources to NineData.Creating Data Sources
04-18Data ReplicationRefresh MetadataDuring the Mapping Configuration phase of creating a replication task, if there are changes in the source and target data sources, you can click the button on the page to re-read the data from the source and target data sources.Data Replication
04-11Data ReplicationPeriodic Full Data ReplicationFull data replication functionality is now supported for individual tasks, automatically executing full replication based on the configured time intervals.Data Replication
04-11Data ReplicationAddition of Replication LinksDozens of replication links have been added, covering mainstream data sources in the market. Please click on the link provided for the supported list.Data Replication
04-11Database DevOpsData TrackingThe NineData data tracking feature is used to track developers' changes or deletions of data or object structures in the database, ensuring data integrity for the business.Data Tracking
04-11Database DevOpsSQL ConsoleWhen managing PostgreSQL data sources in the SQL Console, support has been added to obtain the execution plan of the target SQL statement.SQL Console
04-11Database DevOpsSQL ConsoleWhen managing PostgreSQL data sources in the SQL Console, you can right-click on the target object in the left navigation tree and select to automatically generate the creation script for that object.SQL Console
04-11Database DevOpsSQL ReviewThe NineData SQL review feature now supports PostgreSQL data sources.SQL Review
04-11Database DevOpsSlow Query AnalysisThe NineData slow query analysis feature now supports PostgreSQL data sources.Slow Query Analysis
04-11Basic ServicesAddition of Data Source SupportAdded support for bringing HiDB data sources into NineData.Create Data Source
04-11Basic ServicesAddition of Data Source SupportAdded support for bringing Sybase data sources into NineData.Create Data Source
04-11Basic ServicesAddition of Data Source SupportAdded support for bringing Hive data sources into NineData.Create Data Source
04-11Basic ServicesData Source Entry OptimizationWhen entering Redis clusters via gateway or private network connection, only one link address needs to be filled in. The system will automatically traverse all link addresses of the cluster and add them without the need for manual operation by the user.Create Data Source
04-02Database DevOpsData ExportThe data export feature has been integrated with table-level permission control, allowing users to export only the tables they have permission to in the data export module.Data Export
04-02Database DevOpsSQL ConsoleThe SQL Console feature has been integrated with table-level permission control, allowing users to perform operations such as querying and modifying only on tables they have permission to in the SQL Console module.SQL Console
04-02Basic ServicesNew Architecture Support for Data SourcesAdded support for two deployment architectures of MySQL data sources: disaster recovery and read-write splitting.Create Data Source
04-02Basic ServicesNew Architecture Support for Data SourcesAdded support for two deployment architectures of MongoDB data sources: replica set and sharded cluster. Also added the preference setting for read traffic distribution under replica set architecture (Read Preference).Create Data Source

March

Release Date
Module
Function
Release Details
Related Links
03-27Database DevOpsProduct UpgradeNineData's SQL Development initially focused on providing SQL Console (IDE) functionality. After nearly two years of refinement, the product has added numerous enterprise-level features. As of today, it has served tens of thousands of developers, covering functionalities throughout the lifecycle of database design, development, testing, and changes. In order to better convey the product's value to enterprise-level clients, NineData has officially upgraded SQL Development to Database DevOps starting from March 27th, providing customers with a leading global database DevOps solution.N/A
03-27Basic ServicesAudit LogTwo optimizations have been added to the audit log functionality:
  • If the event object of the operation log is an instance ID, it supports direct clicking for navigation.
  • In SQL execution logs, searching by database name is now supported.
Audit Log
03-27Database DevOpsSQL TaskThe automatic backup feature for SQL tasks now supports PostgreSQL data sources.SQL Task
03-27Database DevOpsData ArchivingData archiving functionality now supports PostgreSQL data sources.Data Archiving
03-27Database DevOpsSensitive Data ManagementSensitive data management functionality now supports configuring sensitive columns for PostgreSQL data sources.Manage Sensitive Data
03-27Database DevOpsTable-Level Permission RequestNineData permission control has added table-level granularity, allowing users to apply for permissions only for individual or multiple tables in the data source without granting larger-grained permissions at the database or data source level.Permission Request and Approval
03-27Database DevOpsDevelopment PipelineThe development pipeline functionality enables multi-environment development process management, facilitating smooth progress in each environment to ensure that all necessary validation, changes, and approvals are completed before code is released to the production environment.Development Pipeline
03-13Database DevOpsAdd sensitive data in views (VIEW)The upgrade of the sensitive column addition function now includes support for adding sensitive columns based on views, in addition to the existing capability of adding sensitive columns based on tables. This update currently applies to MySQL and DB2 data source types.Manage Sensitive Data
03-13Database DevOpsPermanent Free Version of Database DevOps Professional EditionNineData released the permanent free version of Database DevOps Professional Edition on March 13, 2024. This version allows a maximum of 10 data source instances to be added and provides unlimited access to all advanced features of Database DevOps Professional Edition.
Existing free organizations will be automatically upgraded to this version; new registered users and new organizations will directly access this version.
Introduction to Database DevOps Professional Edition

February

Release Date
Module
Function
Release Details
Related Links
02-28Database DevOpsSQL ConsoleAdded a switch in the query result set of relational databases to toggle between row and column modes, allowing users to switch from the default column mode to row mode for displaying the result set.SQL Console (RDBMS)
02-28Basic ServicesNo Specify ApproverAdded a switch in the approval process. When enabled, users no longer need to specify an approver in all processes that require one (such as SQL tasks, permission requests, data archiving, data import/export, SQL audits, etc.). All personnel with approval privileges will receive approval notifications and be able to approve the work order.Approval Process
02-28Basic ServicesAdded Support for New Data SourcesAdded support for Tencent Cloud TDSQL PostgreSQL instances.Create Data Source
02-28Basic ServicesAdded Support for New Data SourcesAdded support for Tencent Cloud TDSQL MySQL instances.Create Data Source
02-22Basic ServicesAutomatically Create Organization for New Registered UsersFor new registered NineData users, the system will automatically create an organization with the same name as the user's username, and upon logging into the console, the user will be automatically switched to that organization.Manage Organization
02-22Data ComparisonData Comparison between MySQL and PostgreSQLAdded support for data comparison between MySQL and PostgreSQL data sources.Data Comparison
02-22Data ReplicationStructure Replication from MySQL to GreenplumAdded structure replication on top of existing replication from MySQL to Greenplum, eliminating the need to manually create table structures on Greenplum.MySQL Replication to Greenplum
02-22Data ReplicationMySQL to PostgreSQL ReplicationAdded support for data replication from MySQL to PostgreSQL, supporting structure, full, and incremental data replication.MySQL Replication to PostgreSQL
02-05Data ReplicationOracle to PostgreSQLData replication from Oracle to PostgreSQL is now supported. It includes support for structural, full, and incremental data replication.Oracle to PostgreSQL Replication
02-05Database DevOpsAdministrator Mode for Task TicketsSQL tasks, import, export, data archiving, SQL audit, and other task tickets support administrator mode. System administrators can directly approve, execute, pause, restart, and perform other operations on these task tickets.N/A
02-05Database DevOpsFull-Featured Database DevOpsFull range of SQL development features now support Baidu Cloud GaiaDB as a data source. This includes SQL Console, SQL tasks, data import, data export, SQL auditing, batch database changes, slow query analysis, DSQL, data archiving, etc.Database DevOps
02-05Basic ServicesAdded Data Source SupportAdded support for Baidu Cloud GaiaDB as a data source.Create Data Source
02-05Basic ServicesConfigure Session TimeoutSystem administrators can now configure the expiration time for user sessions after logging into the console. After expiration, users need to log in to the console again.Manage Organization

January

Release Date
Module
Function
Release Details
Related Links
01-31Basic ServicePermission Application (Redis SQL Task Permissions)Support applying for Redis SQL task permissions.Permission Application and Approval
01-31Database DevOpsSQL Console OptimizationThe SQL Console style has been optimized as follows:
  • Support for quick closing of SQL Console tabs (added shortcut close option in SQL Console tab right-click menu).
  • Added data source collection feature (icon collect) above the left navigation tree).
  • Optimized details of SQL Console icons.
SQL Console (RDBMS)
01-31Data ReplicationStructural ConversionNineData's structural conversion functionality now supports downloading converted SQL scripts, which can be batch executed in the target database.Structural Conversion
01-31Data ReplicationMySQL to StarRocksNineData data replication supports synchronization of structure, full data, and incremental data from MySQL to StarRocks data sources.Replication to StarRocks
01-31Data ReplicationKafka to KafkaKafka to Kafka data replication functionality is now supported.Kafka to Kafka Replication
01-24Data ReplicationStructural TransformationNineData now supports structural transformation between heterogeneous data sources, allowing you to perform table structure conversion operations in the target data source after the transformation is completed.Structural Transformation
01-24Basic ServicesAddition of Data Source SupportAddition of DocumentDB compatibility support. You can now select the MongoDB type when creating a data source and enter the connection address information through the DocumentDB data source.Create Data Source
01-24Database DevOpsData ArchivingNineData supports data archiving functionality. You can archive unused data to another database for backup to free up storage space in the business database and optimize performance. Supports one-time execution and periodic automatic execution.Data Archiving
01-24Database DevOpsSQL ReviewMajor update to SQL review functionality! Supports auditing SQL statements based on slow query logs and full query logs in the database.
In addition, a new incremental audit function has been added, which combines the latest historical SQL review results that have been approved to compare the SQL statements submitted currently, helping you quickly obtain differential results between the two audits.
SQL Review
01-24Database DevOpsData Export (ClickHouse)Data export functionality now supports ClickHouse data sources and can be exported using SQL query statements.Data Export
01-16Database DevOpsOnlineDDL OptimizationAdded the "Mandatory use of NineData OnlineDDL" option, supporting direct and lock-free structural changes to tables through NineData OnlineDDL.Use NineData OnlineDDL for Lock-Free Structural Changes to Tables
01-16Database DevOpsDatabase DevOps Standards UpdateAdded the "" rule to control the execution of NoSQL commands in SQL tasks.Overview of SQL Development Rules
01-16Basic ServicesEncryption for Redis Data SourceWhen adding a Redis data source to NineData, now supports enabling encryption for transmission, further ensuring the security of the accessed data source.Create Data Source
01-10Data ComparisonData Comparison between Oracle and SingleStoreData comparison functionality between Oracle and SingleStore has been supported.Data Comparison
01-10Data ReplicationOracle to MySQLData replication from Oracle to MySQL is now supported, covering structural, full, and incremental data replication.Oracle to MySQL Replication
01-10Data ReplicationOracle to SingleStoreData replication from Oracle to SingleStore is now supported. It allows analyzing data through SingleStore, while Oracle focuses on the workload of transactional operations, distributing server pressure, and maximizing the value of business data.Oracle to SingleStore Replication
01-10Database DevOpsAddition of SQL Development RulesAddition of the "" rule for setting the concurrency of SQL tasks.Overview of SQL Development Rules
01-10Database DevOpsOnlineDMLNineData's SQL tasks support the OnlineDML feature, which automatically splits large-scale data changes into multiple statements for batch execution. This helps avoid table blocking caused by extensive data modifications, preventing disruptions to business operations.Executing Large-scale Data Changes in Batches using NineData OnlineDML
01-10Basic ServicesMonitoring Alerts Support Email ServiceSupport for manually configuring email services. After configuration, the system will use the email server you configured to send alerts and subscription information to recipients.Configure Alert Reception
01-03Data ReplicationMongoDB Replication OptimizationAfter MongoDB replication failure, supports users to repair SQL statement execution from the console, and optimizes the performance of MongoDB pre-checking the existence of target data.MongoDB Replication to MongoDB
01-03Data ReplicationRedis Replication OptimizationDuring the full replication phase of Redis, supports automatic retries in case of network issues, optimizes the logic of saving disconnecting resumption points, and supports users to repair and skip incremental commands in case of Redis cluster replication failure.Redis Replication to Redis
01-03Data ReplicationMySQL Replication OptimizationOptimizes the performance of reading large transactions in MySQL incremental replication, reduces CPU consumption, and decreases latency.MySQL Replication to MySQL
01-03Database DevOpsBatch Database ChangesSupports initiating batch structural and data changes to the target database through SQL tasks, supports automatic SQL review based on SQL development specifications, and also supports multi-level approval in the approval process configuration.Batch Database Changes