Skip to main content

2023

December

Release Date
Module
Feature
Release Details
Related Links
12-27Data ComparisonData Comparison between PostgreSQL and DorisSupports structure and data comparison between PostgreSQL and Doris data sources.Data Comparison
Structure Comparison
12-27Data ReplicationPostgreSQL to DorisSupports data replication from PostgreSQL to Doris, enabling efficient management and analysis of large-scale data.PostgreSQL to Doris Replication
12-27Data ReplicationKafka to MySQLSupports data replication from Kafka to MySQL, enabling real-time data synchronization and persistent storage.Kafka to MySQL Replication
12-27Database DevOpsSQL Tasks (DWS, GaussDB, openGauss)SQL task functionality now supports DWS, GaussDB, and openGauss data sources. You can initiate change requests to these data sources through SQL tasks, supporting immediate or scheduled execution.SQL Tasks
12-27Database DevOpsSQL Console (DWS, GaussDB, openGauss, SingleStore, StarRocks)SQL Console functionality now supports DWS, GaussDB, openGauss, SingleStore, and StarRocks data sources. You can perform CRUD operations on these data sources through the SQL Console.SQL Console
12-27Database DevOpsData Export (DWS, GaussDB, openGauss)Data export functionality now supports DWS, GaussDB, and openGauss data sources. You can export data to files for storage using SQL queries.Data Export
12-27Database DevOpsData Import (DaMeng)Data import functionality now supports DaMeng data sources. You can import SQL, CSV, and EXCEL files containing data into the target database.Data Import
12-27Basic ServicesPermission Request (DWS, GaussDB, openGauss)Supports applying for various permissions for DWS, GaussDB, and openGauss data sources.Permission Application and Approval
12-27Basic ServicesAdded Support for New Data SourcesAdded support for five new data sources: SingleStore, StarRocks, DWS, GaussDB, and openGauss.Create Data Source
12-20Database DevOpsNew SQL Development RulesAdded the "" rule to limit the duration of data export tasks that exceed the preset threshold.SQL Development Rules Overview
12-20Database DevOpsSQL Task Backup for OceanBase OracleThe backup function for SQL tasks now supports OceanBase Oracle data source. It automatically backs up data modification objects of SQL tasks, and the backup can be downloaded locally after completion.SQL Tasks
12-20Database DevOpsData Export (Dameng)Data export functionality now supports Dameng data source. You can export data through SQL queries or directly select databases and tables for export.Data Export
12-20Database DevOpsSQL Tasks (Klustron)SQL task functionality now supports Klustron data source. You can initiate change requests for this data source through SQL tasks, supporting immediate or scheduled execution.SQL Tasks
12-20Database DevOpsSQL Console (Klustron)SQL Console functionality now supports Klustron data source. You can perform CRUD operations on these data sources through the SQL Console.SQL Console
12-20Database DevOpsSQL Console Administrator ModeAdded Administrator Mode. Users with the system administrator role can enable Administrator Mode, where all changes in the SQL Console are not subject to SQL standards and can be executed directly.SQL Console
12-20Database DevOpsSQL Console Session ViewAdded session overview to MySQL's session view feature. It provides statistics on total sessions, active sessions, all accessing users, access source information, and relevant statistics for databases.SQL Console
12-20Basic ServicesAdded Data Source SupportAdded Klustron data source support.Create Data Source
12-13Database DevOpsSQL Console (DAMENG, KingBase)SQL Console functionality now supports DAMENG and KingBase data sources, allowing you to perform CRUD operations on these data sources through the SQL Console.SQL Console
12-13Database DevOpsSQL Task (DAMENG, KingBase)SQL Task functionality now supports DAMENG and KingBase data sources. You can initiate change requests for these data sources through SQL Task, supporting both immediate and scheduled execution.SQL Task
12-13Basic ServicesAddition of Data Source SupportAdded support for KingBase data source.Create Data Source
12-13Basic ServicesAddition of Data Source SupportAdded support for DAMENG data source.Create Data Source
12-06Database DevOpsNon-Table Object ManagementNow, in the SQL console, you can visually create, edit, copy, rename, and delete non-table objects for MySQL data sources, including views, procedures, triggers, events, and functions.Creating Non-Table Objects in MySQL Visually
12-06Database DevOpsSQL Tasks (MongoDB)SQL task functionality now supports MongoDB data sources, allowing you to initiate change requests for MongoDB through SQL tasks, supporting immediate or scheduled execution.SQL Tasks
12-06Basic ServicesData Source Overview PageThe data source page now includes an overview page, providing a clear display of the total number of current data sources, availability, and the number of associated tasks.-

November

Release Date
Module
Function
Release Details
Related Links
11-29Database DevOpsSlow Query AnalysisIn the report detailing slow query details, examples of SQL statements for SQL templates have been added.Slow Query Analysis
11-29Database DevOpsData Import (DB2)The data import feature now supports DB2 data sources, allowing you to import SQL, CSV, and EXCEL files containing data into the target database.Data Import
11-29Database DevOpsData Export (DB2)The data export feature now supports DB2 data sources. You can export data using SQL query statements or by selecting specific tables from the database.Data Export
11-29Database DevOpsMySQL Autocomplete EnhancementSignificantly improved autocomplete functionality for MySQL data sources in the SQL console. Feel free to explore the enhancements.SQL Console
11-22Basic ServicesData Source TagsIntroducing the new Data Source Tags feature for grouping and quickly locating data sources in the Slow Query Analysis functionality.Create Tag
11-22Database DevOpsSlow Query Analysis (Batch Index Recommendations)Newly added support for batch SQL index recommendations, aiding you in efficiently optimizing database performance in scenarios involving a large number of SQL queries.Slow Query Analysis
11-22Database DevOpsSlow Query Analysis (Oracle Support)Slow Query Analysis functionality now supports Oracle data sources, providing users of Oracle databases with more comprehensive and accurate tools for slow query analysis, further enhancing efficiency and quality of database management.Slow Query Analysis
11-22Database DevOpsSlow Query Analysis (Report Download)Introducing the new feature for downloading slow query reports, allowing you to download reports as files for easier sharing and archiving of slow query data.Slow Query Analysis
11-22Database DevOpsSlow Query Analysis (Data Source Favorites)Added support for favoriting data sources in slow query collection, allowing you to conveniently bookmark commonly used or critical data sources for quick identification and monitoring of slow query issues.Slow Query Analysis
11-22Database DevOpsSlow Query Analysis (Top 100 List)Newly added functionality for Top 100 Slow Query Lists, enabling you to quickly identify the queries that most impact system performance.Slow Query Analysis
11-22Database DevOpsSlow Query Analysis (Data Dashboard)Introducing the Data Dashboard feature, designed to provide clearer insights into the trends of slow queries, enabling timely actions to address issues and further enhance system stability and performance.Slow Query Analysis
11-22Database DevOpsSQL ReviewNineData SQL Review is used for security and efficiency reviews of SQL statements before application code is released. It ensures that the released SQL statements comply with standards and recommends appropriate indexes for SQL statements without indexes, improving the efficiency and accuracy of code releases.SQL Review
11-22Data ReplicationNew Link FavoritesIn the data replication task list, you can now bookmark target replication links. Later, you can quickly filter out favorited replication links using the button.Data Replication
11-15Data ReplicationAddition of Replication LinksAddition of structure, full, and incremental replication between Oracle databases.Data Replication Between Oracle Databases
11-01Database DevOpsSlow Query AnalysisNineData's slow query analysis feature is used to locate slow SQL queries and optimize databases, helping developers and database administrators identify abnormal queries that affect database performance and providing optimization recommendations. It mainly includes slow log collection, diagnosis, and optimization.Slow Query Analysis
11-01Database DevOpsSensitive Data ManagementSensitive columns have been configured for DB2 data sources.Configure Sensitive Columns
11-01Database DevOpsExecution PlansExecution plan support is now available for DB2 data sources in the SQL Console.SQL Console (RDBMS)
11-01AIGCChatDBA Knowledge Base ManagementChatDBA supports users in custom database management, allowing users to enter custom terms to influence ChatDBA's responses.Intelligent Question-Answering Bot ChatDBA
11-01Basic ServicesDB2 Permission Request SupportDB2 data sources now support permission control, allowing users to request permissions for DB2 data sources, databases, and sensitive columns through the NineData console.Permission Request and Approval

October

Release Date
Module
Function
Release Details
Related Links
10-25Data ComparisonOptimization of PostgreSQL Data Comparison FunctionalityAdded trigger and stored procedure comparison in the structure comparison scenario between PostgreSQL data sources.Structure Comparison
10-25Data ReplicationKafka Replication to ClickHouseSupported data replication from Kafka to ClickHouse for effective processing and analysis of real-time data.Kafka Replication to ClickHouse
10-25Basic ServicesAddition of Data Source SupportAdded support for Greenplum data sources.Create Data Source
10-18Database DevOpsView Sessions (PostgreSQL, Oracle, OceanBase Oracle)Display information about all active connections on the current PostgreSQL, Oracle, and OceanBase Oracle database servers, as well as the queries being executed by these connections.SQL Tasks (RDBMS)
10-18Database DevOpsData Import (Oracle, OceanBase Oracle)Data import functionality now supports Oracle and OceanBase Oracle data sources, allowing you to import SQL, CSV, and EXCEL files containing data into the target database.Data Import
10-18Database DevOpsDatabase DevOps Guidelines Support for DB2Database DevOps guidelines now support configuring rules for DB2 data sources, with 20 structural rules currently supported for DB2.Database DevOps Policy Overview
10-18Database DevOpsSQL Task (DB2)The SQL task functionality now supports DB2 data sources, allowing you to initiate change requests for DB2 through SQL tasks. It supports immediate or scheduled execution.SQL Tasks (RDBMS)
10-18Basic ServicesUpgraded Data Source Creation PageTo enhance the user experience, NineData's data source creation page has undergone a major overhaul. It consolidates the diverse data source types and major cloud vendor instance types into separate modules, presenting a clean and intuitive creation page for you to smoothly add data sources.Create Data Source
10-11AIGCChatDBA Major Model UpgradeUpgrade of DBCopilot major model, adding knowledge base retrieval for databases to enhance the quality of database-related Q&A.Intelligent Q&A Bot ChatDBA
10-11AIGCChatDBA Questioning Limit in Unlogged StateThe number of questionings in ChatDBA for unregistered or unlogged-in users has been increased from 3 to 10.Intelligent Q&A Bot ChatDBA
10-11Database DevOpsAddition of New Rule in Database DevOps GuidelinesAdded the rule "" to restrict the occurrence of duplicate index names within a single table.SQL Development Rules Overview
10-11Database DevOpsDSQLNineData DSQL now supports querying and aggregating data from various types of data sources to generate global query results.DSQL
10-11Database DevOpsSQL Console (DB2)SQL Console functionality now supports DB2 data sources, allowing for CRUD operations on DB2 data sources via SQL Console.SQL Console
10-11Basic ServicesAddition of Data Source SupportAdded support for DB2 data sources.Create Data Source

September

Release Date
Module
Feature
Release Details
Related Links
09-21Basic ServiceUser Access ManagementAdded a configuration entry for managing user access limits, limiting the total number of queries per day and the total number of rows per day for each user within the organization. Supports global and specific user configurations.Manage Users
09-21Basic ServiceQuick StartProvides 5 sets of beginner-friendly tasks to guide new users through a complete experience of all NineData features from 5 dimensions, helping users who have never used NineData get started quickly.-
09-21Database DevOpsSensitive Data ManagementNow supports configuring sensitive columns for Oracle and OceanBase Oracle data sources.Configure Sensitive Columns
09-21Database DevOpsData Import (SQL Server)Data import functionality now supports SQL Server data sources, allowing import of SQL, CSV, and EXCEL files containing data into the target SQL Server database.Data Import
09-14AIGCChatDBAThe large model DBCopilot V1.0 developed by Nine Chapters is now online. This model has undergone targeted training in the database domain, and it boasts a smaller parameter model compared to GPT models. It is equipped with domestically deployed GPU devices, resulting in faster content generation speed than both GPT 3.5 and GPT 4.0, while maintaining content generation quality on par with GPT 3.5.Intelligent Q&A Robot ChatDBA
09-14Basic ServicesMulti-cloud Private Network Connectivity SupportNineData now supports private network connectivity for Tencent Cloud, Huawei Cloud, AWS, and Baidu Cloud.Create a private network connection
09-14Database DevOpsSQL ConsoleOracle and OceanBase Oracle data sources now support the following features:
  • Conversion of table structures to programming languages.
  • Conversion of table structures to create table statements for other types of databases.
  • Conversion of functions to programming languages.
SQL Console (RDBMS)
09-14Data ReplicationMySQL Replication to Amazon RedshiftFull replication and incremental replication from MySQL to Amazon Redshift are now supported.MySQL Replication to Redshift
09-07Data ComparisonOracle Data Comparison SupportData comparison functionality now supports Oracle to Oracle and Oracle to OceanBase Oracle data source comparisons.Data Comparison
09-07Data ReplicationMySQL Replication EnhancementMySQL to MySQL data replication tasks have overcome the limitation of not being able to replicate from higher versions to lower versions.MySQL Replication to MySQL
09-07Database DevOpsSession View (Redis)Display information on all active connections and the queries they are executing on the current Redis database server.SQL Console (Redis)
09-07Database DevOpsData Export (OceanBase Oracle)Data export functionality now supports OceanBase Oracle data source, allowing data export via SQL query or direct selection of tables.Data Export
09-07Database DevOpsSQL Task (OceanBase Oracle)SQL task functionality now supports OceanBase Oracle data source, allowing the initiation of change requests to OceanBase Oracle via SQL tasks.SQL Task
09-07Database DevOpsSQL Console (OceanBase Oracle)SQL Console functionality now supports OceanBase Oracle data source, allowing CRUD operations on OceanBase Oracle data source via SQL Console.SQL Console
09-07Basic ServicesPermission Request and Approval (OceanBase Oracle)Support for permission requests for SQL Console, SQL task, data export, and more for OceanBase Oracle data source.Permission Request and Approval
09-07Basic ServicesMongoDB Adds Multiple Security RulesMongoDB now supports the following rules:
SQL Development Rules Overview
09-07Basic ServicesNew Data Source SupportAdded support for OceanBase Oracle data source.Create Data Source

August

Release Date
Module
Feature
Release Details
Related Links
08-31ChatDBAChatDBA Beta VersionChatDBA is an intelligent question-and-answer chatbot developed based on AIGC technology. It can engage in interactive conversations, assist in content creation, and answer everyday questions.Intelligent Q&A Chatbot ChatDBA
08-24Basic ServicesRefinement of Sensitive Column PermissionsThe refinement of sensitive column permissions includes two types of permissions: accessing sensitive columns in SQL Console and export ing sensitive columns in data.Permission Application and Approval
08-24Database DevOpsSQL Server Schema ExportThe data export feature now supports schema export for SQL Server data sources.Data Export
08-24Database DevOpsResult Set Editing (Doris, SelectDB)Result set editing is now supported for Doris and SelectDB. It allows editing of result sets for single-table queries with unique key columns in the result.SQL Console (RDBMS)
08-24Database DevOpsView Sessions (SQL Server)Displays information about all active connections on the current database server, including the queries being executed by these connections.SQL Console (RDBMS)
08-24Database DevOpsEstimated Affected RowsThe SQL task configuration page has added an option for configuring estimated affected rows. If the actual execution rows differ from the estimated value, a reminder will be displayed on the page.SQL Task
08-24Database DevOpsEnhanced OnlineDDL FunctionalityBuilding upon the existing NineData OnlineDDL functionality, this enhancement introduces runtime parameter configuration and provides support for viewing the progress of OnlineDDL execution.Perform non-locking structure changes to the table using NineData OnlineDDL
08-17Data ReplicationEnhanced Incremental ReplicationFor data replication in relational databases, you can now choose specific operations to be included or excluded in incremental synchronization. Unchecked operations will be ignored during incremental synchronization.Data Replication
08-17Database DevOpsSQL Task Backup for Oracle, SQL ServerThe backup feature for SQL tasks now supports Oracle and SQL Server data sources. It enables automatic backup of modified objects within SQL tasks, and the backups can be downloaded locally after completion.SQL Tasks
08-17Database DevOpsSession Viewing (MySQL, ClickHouse)Displays information about all active connections on the current database server, along with the queries being executed by these connections.SQL Console (RDBMS)
08-10Basic ServicesData WatermarkNineData data watermark is a technology used to protect the security of console page content. It embeds a watermark containing the information of the currently logged-in user in the console of the current organization, preventing users from taking unauthorized screenshots or printing the current page information.Manage Data Watermark
08-10Database DevOpsData Export Supports Oracle, SQL ServerData export feature now supports Oracle and SQL Server data sources.Data Export
08-08Database DevOpsSQL Console OptimizationSupports the operation on the query result set of the SQL console window, allowing copying of the entire column's contents.SQL Console (RDBMS)
08-03Basic ServicesGateway Disaster RecoveryNineData Gateway now supports disaster recovery, automatically restarting after server reboots or gateway process shutdowns to ensure stable data source connections.Manage Gateway
08-03Basic ServicesPermission Application Supports ClickHouse Data SourceSupports applying for SQL console permissions for ClickHouse data sources.Permission Application and Approval
08-03Data ComparisonData Comparison Support for Doris|SelectDB and Performance OptimizationData comparison functionality is now available for MySQL to Doris and MySQL to SelectDB data sources, along with performance optimization achieving an RPS of 100,000.Data Comparison
08-03Data ComparisonPostgreSQL Data ComparisonNineData data comparison supports data and structure comparison between PostgreSQL data sources.Data Comparison
Structure Comparison
08-03Data ReplicationMongoDB Data ReplicationNineData data replication supports data synchronization between MongoDB data sources.Data Replication Between MongoDB
08-03Data ReplicationPostgreSQL Data ReplicationNineData data replication supports data synchronization between PostgreSQL data sources.Data Replication Between PostgreSQL
08-03Data ReplicationMySQL Replication to SelectDBNineData data replication supports full and incremental data synchronization from MySQL to SelectDB data sources.MySQL Replication to SelectDB
08-03Data ReplicationMySQL Replication to DorisNineData data replication supports full and incremental data synchronization from MySQL to Doris data sources.MySQL Replication to Doris
08-03Database DevOpsSQL ConsoleWhen hovering the mouse over a tab representing a target result set in the query result set below the SQL console, the corresponding SQL statement for that result set will be displayed.SQL Console (RDBMS)
08-03Database DevOpsSQL ConsoleWhen hovering the mouse over a table name, column name, or index name in the left navigation tree of the SQL console, detailed information will be displayed.SQL Console (RDBMS)
08-03Database DevOpsDatabase DevOps Guidelines for PostgreSQL Data SourceSupports Database DevOps guidelines for PostgreSQL data sources.Manage Database DevOps Guidelines

July

Release Date
Module
Feature
Release Details
Related Links
07-27Basic ServicesDatabase DevOps Professional VersionNew addition of Database DevOps Professional version.Introduction to Database DevOps
07-20Basic ServicesNew Data Source SupportNewly added support for Oracle data source.Create Data Source
07-13Data ComparisonData Comparison for MongoDBData comparison functionality is now available for MongoDB data sources.Data Comparison
07-13Basic ServicesMobile ApprovalYou can view approval tasks on mobile devices (phones, tablets, etc.) via NineData's approval links (WeChat, Feishu, SMS, email, etc.). Supports Approve and Reject operations. Mobile approval supports the SQL Task, Data Export, Data Import, and Permission and Application modules.N/A
07-13Database DevOpsSQL Intelligent OptimizationImproved AI for more accurate information on intelligently optimized SQL statements.SQL Console (RDBMS)
07-06Database DevOpsDatabase DevOps for SQL Server Data SourceSupports the following for SQL Server data source:
  • SQL Task: Supports submitting SQL tasks for SQL Server data source.
  • Security Guidelines: Supports 54 security guidelines for SQL Server data source.
SQL Task
Manage Database DevOps Policies

June

Release Date
Module
Feature
Release Details
Related Links
06-29Data ComparisonPerformance Optimization for International RegionsOptimized data comparison performance for international data sources, achieving performance improvements of several tens of times compared to before.Data Comparison
06-29Data ReplicationSupport for Spatial Data TypesReplication tasks between MySQL databases now support replication of spatial data types.Data Replication
06-29Data ReplicationPerformance Optimization for International RegionsOptimized replication performance for data sources in international regions, achieving performance improvements of several tens of times compared to before.Data Replication
06-27Basic ServicesAdded Cloud Vendor SupportAdded support for Alibaba Cloud, Tencent Cloud, and Huawei Cloud MongoDB database instances.Create Data Source
06-27Basic ServicesAdded Deployment Mode Support for RedisSupports Redis data sources in cluster mode.Create Data Source
06-20Basic ServicesPermission Application Support for MongoDB and SQL ServerSupports applying for various permissions for MongoDB and SQL Server data sources.Permission Application and Approval
06-15Data ReplicationSupport for Large MySQL TransactionsNineData's data replication feature now supports parsing and replicating super-large transactions (over 4 GB) in MySQL databases.Data Replication
06-15Database DevOpsEnhanced SQL TaskTwo new features added to SQL tasks:
  • Added rollback SQL entry.
  • Automatically backs up data modified by SQL tasks and allows downloading the backup after completion.
SQL Task
06-15Database DevOpsAdded Rules for SQL Task and WindowsAdded execution time configuration rules for DML, DDL, and DQL, limiting the executable time range of SQL tasks.Managing Database DevOps Policies
06-15Basic ServicesUser SwitchSystem administrators can enable or disable functions for target users using the user switch.Managing Users
06-15Basic ServicesAllow SSO Accounts to be Automatically AddedWhen configuring the SSO login function, enabling this option automatically adds SSO members to NineData without manual operations.Enable SSO Login
06-13Database DevOpsData Export Support for PostgreSQLThe data export feature now supports exporting table data from PostgreSQL to SQL files based on SQL query statements.Data Export
06-13Database DevOpsEnhancements to SQL TasksSQL task functionality has been enhanced with features such as automatic data backup before execution, rollback scenario entry window, task pause, and task restart.SQL Tasks
06-08Database DevOpsMongoDB Support in SQL ConsoleNineData SQL Console now supports managing MongoDB databases.SQL Console
06-08Basic ServicesAddition of MongoDB Data Source SupportAdded support for MongoDB data sources.Create Data Source
06-01Database DevOpsDatabase DevOps Enterprise EditionNineData has released Database DevOps Enterprise Edition, providing a comprehensive set of powerful enterprise-level capabilities, including team collaboration, permission control, audit logs, SSO (Single Sign-On), SQL development standards, approval workflows, and more.Database DevOps

May

Release Date
Module
Feature
Release Details
Related Links
05-25Basic ServicesAdded Cloud Provider SupportAdded support for Baidu Cloud's Cloud Database RDS and Cloud Database SCS for Redis.Create Datasource
05-25Basic ServicesPermission RequestAdded support for requesting permissions for PostgreSQL datasource, database, and schema.Permission Request and Approval
05-25Database DevOpsSQL TaskAdded support for SQL tasks on PostgreSQL, Doris, and SelectDB datasources.SQL Task
05-25Database DevOpsSQL ConsoleNineData SQL Console now supports managing PostgreSQL databases.SQL Console
05-23Basic ServicesNew Data Source SupportAdded support for PostgreSQL data source.Create Data Source
05-18Data ReplicationIncremental Replication Logic EnhancementDuring the incremental replication process from MySQL to ClickHouse, if a DDL change is executed on the source side, the program will automatically check on the target side if there are objects with identical structures. If such objects exist, the change will be automatically ignored, and the subsequent incremental replication tasks will continue.Data Replication
05-11Basic ServicesNew Data Source SupportAdded support for SelectDB data source.Create Data Source
05-11Basic ServicesNew Data Source SupportAdded support for Doris data source.Create Data Source
05-11Basic ServicesRedis Sentinel ModeAdded support for Redis Sentinel Mode deployment architecture when configuring Redis data source.Create Data Source

April

Release Data
Module
Function
Release Details
Related Links
04-27Data ReplicationCompatibility with Lower Version MySQLCompatibility with MySQL versions 5.7 and below, including support for handling unsigned and Binary data types, ensuring data consistency.Data Replication
04-27Database DevOpsSQL Console (Redis)NineData SQL Console now supports managing Redis databases, allowing users to easily view, edit, and manage Redis data, as well as create, delete, and modify Redis databases.SQL Console (Redis)
04-20Data ReplicationBidirectional MySQL ReplicationNineData's data replication feature supports bidirectional synchronization tasks between multiple MySQL data sources, enabling the construction of real-time synchronization chains with three nodes or more.Data Replication Between Multiple Data Sources
04-20Data ReplicationElasticsearch Data ReplicationNineData's data replication supports data replication from MySQL to Elasticsearch, supporting both full and incremental replication.MySQL Replication to Elasticsearch
04-20Database DevOpsData ImportNineData supports data import function, which allows users to import files containing SQL scripts or data content into target databases, supporting files up to 5 GB in size.Data Import
04-06Basic ServicesSupport for new data sourcesNineData now supports Alibaba Cloud AnalyticDB for MySQL data source, as well as Alibaba Cloud, Tencent Cloud, and Huawei Cloud Elasticsearch data sources.Creating Data Sources
04-06Basic ServicesSubscription Management - Data ExportThe Subscription Management module now supports data export, and allows for configuration of alarm methods for data export tasks.Subscription Management
04-06Data ComparisonRedis Data ComparisonNineData Data Comparison now supports data comparison between Redis data sources.Data Comparison
04-06Data ReplicationSQL Server Incremental ReplicationData replication between SQL Server instances now supports incremental replication.Data Replication between Self-built Databases
04-06Data ReplicationRedis Data ReplicationNineData Data Replication now supports data replication between Redis data sources.Data Replication between Redis Instances
04-06Data ReplicationAutomatic MySQL Storage Engine ConversionWhen replicating from a lower version (5.7) of MySQL to a higher version (8.0), partitioned tables with the MyISAM storage engine are automatically converted to InnoDB, resolving the issue of MyISAM not being supported in versions 8.0 and above.MySQL Replication to MySQL
04-06Database DevOpsOnlineDDLNineData SQL tasks now support the OnlineDDL feature, which can execute structural changes to a table without blocking normal reads and writes to that table.Using NineData OnlineDDL to perform non-blocking changes to table structures

March

Release Date
Module
Function
Release Details
Related Links
03-23Data ComparisonData|Structure Comparison for SQL ServerThe data comparison feature supports comparing data and structure for SQL Server data sources.Data Comparison
Structure Comparison
03-23Database DevOpsAI HelpRight-click on the selected target SQL statement in the SQL console, and click on . AI will analyze the SQL statement and explain its logic.SQL console
03-23Database DevOpsCode ConversionSupport converting target functions and stored procedures to Java, Python, C++, C#, Golang, Rust, and NodeJS code.SQL console
03-18Data ReplicationMySQL to Kafka ReplicationNineData replication now supports replicating data from MySQL to Kafka, achieving real-time data flow and distribution.MySQL to Kafka
03-18Data ReplicationIncremental Replication Performance OptimizationThe performance of incremental replication from MySQL to ClickHouse has been improved by 100 times, reaching an RPS of 200,000 and a data throughput of 40 MB/s.Data Replication
03-16Database DevOpsData ExportData Export allows data from a data source to be exported as data files in multiple ways (SQL statements, databases and tables), and in multiple formats (SQL, CSV, Excel). Strict access control is available for the data export process, and it must go through an approval process to ensure data security.Data Export
03-14Database DevOpsIntelligent SQL UpdateThe following features have been added:
  • : AI intelligently analyzes the SQL statement on the cursor's current line and provides optimization suggestions.
  • : AI analyzes the structure of the selected SQL statement and performs formatting to enhance readability.
  • : AI converts the current table's create table statement into create table statements for various database types.
  • : AI converts the current table structure into various programming language codes.
  • : AI converts the current stored procedure, funcion into a Java function.
SQL Console

Using AI to Manage Data Sources
03-09Data ComparisonData|Structure Comparison OptimizationSupports data and structure comparison for databases with over 100,000 tables.Data Comparison
03-09Basic ServicesPermission ManagementThe system administrator role can manage all permissions for users.Configure user permissions
03-09Basic ServicesMy PermissionsDisplays all the permissions the current account has.My Permissions
03-09Basic ServicesApproval Workflow (Data Sources, Databases)Provides a work order application process for data sources and databases that cannot be viewed without permission in the organization.Permission Application and Approval
03-09Basic ServicesAudit LogsThe audit logs mainly record the who, when, object, and operation of what has been done. By viewing the audit logs, system administrators can track the history of operations that have occurred in the console to analyze changes made by users and security events.View Audit Logs
03-02Basic ServicesSupport for new data sourcesAdded support for Huawei Cloud RDS SQL Server data source.Create Data Source
03-02Database DevOpsStandard inheritance, process inheritanceAdded logic for inheritance of standards and processes, i.e., a data source will inherit the standards and processes configured in its bound environment. You can cancel the inheritance and customize the configuration of standards and processes.

February

Release Date
Module
Function
Release Details
Related Links
02-23Data ReplicationBlacklistAdded support for adding databases or objects that do not need to be replicated to the blacklist.Data Replication
02-23Data ComparisonQuick ComparisonThe data comparison feature between MySQL instances supports fast comparison. Users can specify a sampling ratio to quickly compare data on both ends through sampling.Data Comparison
02-23Database DevOpsIntelligent SQLAdded intelligent SQL feature, which can quickly convert natural language expressions into SQL queries.Use AI to Manage Data Sources
02-23Database DevOpsSQL console standard pre-checkUnder organizational modeOrganizational mode supports assigning different roles and resource management permissions to each user under an organization, suitable for multi-user collaborative development within the same organization, while ensuring data security and improving overall production efficiency., the system will check every SQL executed in the SQL console against the Database DevOps Standards configured based on . If the SQL does not comply with the standards, the system will intercept it to ensure database security. After interception, users can modify the SQL according to the standards and resubmit it, or directly submit a SQL task based on the approval process configured based on .SQL task
02-23Database DevOpsSQL Task RevampSQL tasks have been revamped with the addition of SQL standard pre-checks and workflow approval functions.SQL Task
02-23Basic ServicesMessage SubscriptionThe subscription management feature supports custom notification methods for different subscription types, making it easier for you to manage message delivery and improve operational efficiency.Subscription Management
02-23Basic ServicesIn-site MessageThe in-site messaging feature is used to send internal messages, including approval flows, product updates, and notifications.In-site Message
02-23Basic ServicesSingle Sign-On SSOSupport for logging into the NineData console via Single Sign-On (SSO) has been added, reducing login time costs and improving efficiency.Introduction to Single Sign-On SSO
02-23Basic ServicesSQL Standards and WorkflowSQL development standards and workflow approval functions support rule setting, linkage approval, and execution operations based on table structure definition, data query, and other dimensions.Introduction to Standards and Workflow
02-09Data ReplicationTime Zone ConversionIn full replication between MySQL instances and from MySQL to ClickHouse, if there are time-related data, support is provided to automatically convert Timestamp values based on different source and destination time zones.Data Replication
02-09Data ReplicationStructural Replication Performance OptimizationSignificantly enhance the performance of structural replication, achieving a 1200% performance improvement for replicating the database structure of 100,000 tables.Data Replication
02-02Basic ServicesAdd RegionAdded AWS-US West (Northern California) region.Create Data Source

January

Release Date
Module
Function
Release Details
Related Links
01-17Data ComparisonTime Zone ConversionIn comparisons between MySQL instances, as well as from MySQL to ClickHouse, if time-related data is present, there is support for performing time conversions based on time zones before executing the comparison.Data Comparison
01-10AllInternationalizationNineData English version released.Documentation
01-04Data ReplicationMySQL Replication to ClickHouseNineData data replication now supports full data synchronization and incremental data synchronization from MySQL to ClickHouse.MySQL Replication to ClickHouse
01-04Data ReplicationThrottlingFull and incremental data replication support throttling to limit the rate at which data is written to the target data source per second.Data Replication
01-04Database DevOpsSmart Tips for SQL Server and ClickHouseSQL smart tips are now available for SQL Server and ClickHouse data sources in the SQL console.SQL Console
01-04Database DevOpsSQL Console Settings
  • Support for adjusting font size in the SQL console.
  • Support for adjusting result set display mode (overwrite, append).
SQL Console
01-04Database DevOpsSave and View SQLUsers can now save SQL statements from the SQL console to NineData and view saved SQL statements.SQL Console