2024
November
| Release Date | Module | Feature | Release Details | Related Links |
|---|---|---|---|---|
| 11-13 | Database DevOps | Data Archiving and Cleaning | Added content display for on the page, including , , , , and various task parameters. | Data Archiving and Cleaning |
| 11-13 | Database DevOps | Sensitive Data Protection |
| Manage Sensitive Data |
| 11-13 | Database DevOps | Data Tracking and Rollback | Supports longer tracking time spans. The selectable for creating data tracking and rollback tasks has been extended from 48 hours to 72 hours. | Data Tracking and Rollback |
| 11-13 | Data Replication | PostgreSQL to Kafka | Added support for data replication from PostgreSQL to Kafka, supporting both full and incremental data replication. | PostgreSQL Migration and Sync to Kafka |
October
| Release Date | Module | Feature | Release Details | Related Links |
|---|---|---|---|---|
| 10-30 | Database DevOps | ChatDBA | The latest version of ChatDBA is released, supporting the construction and management of enterprise private knowledge bases. It works with ChatDBA to efficiently retrieve internal knowledge, improving search accuracy and efficiency. | Intelligent Q&A Bot ChatDBA |
| 10-30 | Database DevOps | Sensitive Data Protection | Added three new masking algorithms for ID numbers, phone numbers, and bank card numbers. | Manage Sensitive Data |
| 10-30 | Database DevOps | Data Generation | Added support for Oracle database. | Generate Test Data |
| 10-30 | Data Replication | Custom Target Database Name | When creating a replication task, the Mapping page now supports transferring tables to any target database (allowing manual configuration of the target database name). | None |
| 10-30 | Data Replication | GaussDB Replication | Added support for GaussDB to GaussDB replication, including structure and full data. | Coming Soon |
| 10-30 | Basic Services | Audit Logs | SQL execution logs now support report generation, with options to download reports locally. | View Audit Logs |
| 10-23 | Data Replication | Oracle to Kingbase | Data replication from Oracle to Kingbase is now supported, including structure, full, and incremental data replication. | Oracle Migration Synchronization to Kingbase |
| 10-23 | Data Replication | MySQL to Kingbase | Data replication from MySQL to Kingbase is now supported, including structure, full, and incremental data replication. | MySQL Migration Synchronization to Kingbase |
| 10-23 | Data Replication | Kingbase to PostgreSQL | Data replication from Kingbase to PostgreSQL is now supported, including structure and full data replication. | Coming Soon |
| 10-23 | Data Replication | Kingbase to Oracle | Data replication from Kingbase to Oracle is now supported, including structure and full data replication. | Coming Soon |
| 10-23 | Data Replication | Kingbase to MySQL | Data replication from Kingbase to MySQL is now supported, including structure and full data replication. | Coming Soon |
| 10-23 | Data Replication | Kingbase to Kingbase | Data replication between Kingbase instances is now supported, including structure and full data replication. | Coming Soon |
| 10-23 | Data Replication | Performance Optimization |
| None |
| 10-16 | Database DevOps | Data Generation | Added 14 new data simulation rules, supporting more data simulation scenarios. | Generate Test Data |
| 10-16 | Database DevOps | Sensitive Data Protection | Enhanced sensitive column recognition rules with new content recognition support, improving detection accuracy. | Manage Sensitive Data |
| 10-09 | Database DevOps | Data Generation | NineData supports automatically generating random data in the database that matches specific business scenarios. This helps simulate actual production data for functional testing, stress testing, and other verification tasks without using real data. | Generate Test Data |
| 10-09 | Data Replication | Feature Optimization | When Oracle is the source, it supports minimizing the activation of supplemental logging at the table level for incremental replication. The pre-check has been changed from requiring full instance-level supplemental logging to checking supplemental logging based on the user-selected tables. | None |
| 10-09 | Data Replication | Feature Optimization | When searching for Sybase table objects, it supports ignoring case sensitivity in table names. | None |
September
| Release Date | Module | Feature | Release Details | Related Links |
|---|---|---|---|---|
| 09-11 | Data Replication | New Replication Link | Supports full and incremental data replication from Oracle to Kafka. | Oracle Migration and Synchronization to Kafka |
| 09-04 | Data Replication | Database Group Replication | Added the capability to replicate MySQL database groups, supporting the use of database groups as both source and target. | Sharding Replication |
| 09-04 | Data Replication | One-click Table Resynchronization | In the incremental phase of replication tasks, supports one-click resynchronization of specific tables. | One-click Table Resynchronization |
August
| Release Date | Module | Feature | Release Details | Related Links |
|---|---|---|---|---|
| 08-28 | Data Replication | Replication Feature Optimization | Added row-level loop prevention capability for bidirectional replication from Sybase to PostgreSQL, supporting scenarios with Sybase transaction log merging. | Sybase Replication Sync to PostgreSQL |
| 08-28 | Data Replication | Replication Performance Optimization | Added the following data source types for full streaming reads (optimized read performance, eliminating OOM failures): Greenplum, AnalyticDB PostgreSQL Edition, Doris, SelectDB, StarRocks, SingleStore, OceanBase. | None |
| 08-28 | Database DevOps | New SQL Development Rules | Added rules related to multiple OceanBase for MySQL data sources. | SQL Development Policy Overview |
| 08-28 | Database DevOps | OceanBase for MySQL Feature Support | The following features of Database DevOps now support OceanBase for MySQL: Sensitive Data, SQL Console, SQL Tasks, Structure Design and Deployment, Data Import and Export, SQL Code Review, Policies and Processes, Database and Table Grouping (Batch Changes, Batch Queries). | None |
| 08-28 | Database DevOps | New Data Source Support | Added support for OceanBase for MySQL data source. | Create Data Source |
| 08-28 | Database DevOps | Sensitive Data Protection | Sensitive data protection has been fully upgraded, with added support for sensitive data levels, enabling classified and hierarchical control. Introduced the concept of data types for intelligent identification of sensitive fields in data sources, and automatic addition of these fields. Additionally, new data masking algorithms and identification rules have been added, covering most user scenarios. | Manage Sensitive Data |
| 08-14 | Data Replication | Replication Performance Optimization | Optimized MongoDB replication methods to significantly improve replication performance for large MongoDB instances (several TBs/thousands of collections). Additionally, added support for replicating MongoDB indexes and TTL attributes. | MongoDB Migration to MongoDB |
| 08-14 | Data Replication | Replication Feature Optimization | Added support for replicating source-side DDL statements during incremental replication in the TiDB to PostgreSQL link. | TiDB Migration to PostgreSQL |
| 08-14 | Database DevOps | New SQL Development Rules | Added 10 new rules related to sharding for TDSQL MySQL data sources: | Overview of SQL Development Policies |
| 08-06 | Data Replication | Performance Optimization for Replication | The replication method for AnalyticDB PostgreSQL to PostgreSQL has been optimized, improving the performance of full replication. | Data Replication |
| 08-06 | Data Replication | Full Task Specification Selection | When creating replication tasks, different specifications can be chosen for full tasks. The larger the specification, the more stable the task. Specifications other than Micro need to be purchased first. | Data Replication |
| 08-06 | Database DevOps | Table Structure to Code Generation | When converting table structures to code, MyBatis XML and MyBatis Annotation are now supported. | SQL Console |
| 08-06 | Database DevOps | AI Execution Plan Interpretation | An AI interpretation entry for execution plans has been added for the SQL console and slow query analysis, allowing AI to interpret the execution plan of target statements. | None |
| 08-06 | Database DevOps | TDSQL MySQL Version Support | The following Database DevOps features now support TDSQL MySQL: sensitive data, SQL console, SQL tasks, structure design and release, data import/export, SQL code review, and compliance and workflow. | None |
| 08-06 | Basic Services | New Data Source Support | Tencent Cloud TDSQL MySQL is now supported as a new data source. | Create Data Source |
July
| Release Date | Module | Function | Release Details | Related Links |
|---|---|---|---|---|
| 07-31 | Data Replication | MySQL to Oracle Compatibility Optimization | Oracle now supports fully receiving BIGINT, BINARY, and VARBINARY data types from MySQL. | MySQL Replication to Oracle |
| 07-31 | Data Replication | Doris|SelectDB|StarRocks Performance Optimization | Optimized data writing methods when targeting Doris, SelectDB, and StarRocks, improving write performance and significantly reducing network traffic consumption. | None |
| 07-24 | Data Replication | Oracle Performance Optimization | Optimized incremental functionality for Oracle RAC clusters, enhancing replication performance and task stability during primary-secondary switchovers. | Data Migration Between Oracle Instances |
| 07-24 | Database DevOps | SQL Code Review | Added support for AI-based extraction of SQL statements from Java code. Users can directly upload Java code packages containing SQL. | SQL Code Review |
| 07-24 | Database DevOps | SQL Console | Optimized PostgreSQL visual table structure design, added Btree, Hash, Gin, and Gist indexes, and separately categorized CHECK and exclusion constraints under the constraints tab. | Design PostgreSQL Table Structure |
| 07-18 | Basic Services | Data Source Permission Management | Added support for viewing permissions at the data source level, allowing clear visibility of current data sources and the granted permissions for databases, tables, and columns under each data source. | None |
| 07-10 | Database DevOps | Data Export Encryption | Added a new rule , which supports encryption of files generated by data export tasks. The file can only be decompressed with the correct password. Authorized users can view the password on the task interface. | Data Export |
| 07-10 | Database DevOps | Schema Design and Release | When creating the Schema Design and Release task, it supports selecting the database group as the baseline data source. | Schema Design and Release |
| 07-10 | Database DevOps | SQL Console | For PostgreSQL, Oracle, and DM data sources, a new search function has been added to search for different objects more accurately. | SQL Console |
| 07-10 | Data Replication | Display of Replication Task Progress | During structure replication and full replication, it supports displaying the current replication progress as a percentage. | None |
| 07-10 | Data Replication | Database|Schema|Table Search | In the data replication task list, tasks can be searched by database name, schema name, and table name. | None |
| 07-04 | Data Replication | Replication Performance Optimization | Optimized incremental replication performance for SQL Server, achieving over 5000 RPS. | None |
June
| Release Date | Module | Function | Release Details | Related Links |
|---|---|---|---|---|
| 06-27 | Database DevOps | Data Tracking and Rollback | Added a task termination feature to address scenarios where tasks may impact business databases during peak periods. | Data Tracking and Rollback |
| 06-27 | Database DevOps | SQL Console | Added support for visual creation and editing of PostgreSQL table structures through the SQL Console. | Design PostgreSQL Table Structure |
| 06-27 | Database DevOps | Full Database DevOps Functionality | The full range of Database DevOps features now supports Baidu Cloud GaiaDB-X data sources, including SQL Console, SQL tasks, data import, data export, SQL review, batch database changes, DSQL, and data archiving. | Database DevOps |
| 06-27 | Basic Services | New Data Source Support | Added support for Baidu Cloud GaiaDB-X data source. | Create Data Source |
| 06-27 | Basic Services | Audit Logs | The module has added a and filter criteria; in terms of record display, it now includes , , and . | View Audit Logs |
| 06-27 | Basic Services | Data Source Overview | The data source overview page has added a SQL Execution dashboard that allows viewing of SQL execution conditions over a specific period, sortable by SQL, user, or data source. | N/A |
| 06-20 | Data Replication | Replication Function Optimization | PostgreSQL replication links now support performance monitoring and rate limiting; added capability to continue replication after primary-secondary instance switch. | None |
| 06-20 | Data Replication | Replication Function Optimization | In replication links with Oracle as the source, support for using RAC clusters and ADG instances as the source. | None |
| 06-20 | Data Replication | Replication Function Optimization | Redis now supports replication of large keys. | None |
| 06-20 | Database DevOps | Data Export (PostgreSQL) | Enhanced the existing PostgreSQL data export feature by adding the ability to export data through databases and tables. | Data Export |
| 06-20 | Database DevOps | Data Import (PostgreSQL) | Data import functionality now supports PostgreSQL data sources, allowing SQL, CSV, and EXCEL files containing data to be imported into the target database. | Data Import |
| 06-20 | Database DevOps | SQL Console | For MySQL data sources, added a new search feature to search different objects more precisely. | SQL Console |
| 06-20 | Database DevOps | Data Owner | NineData supports setting a Data Owner for each data source, each database within a data source, and database groups, significantly enhancing the efficiency and accuracy of approval process configurations. | Set Data Owner |
| 06-05 | Data Replication | Replication Function Optimization | Added support for view conversion in replication tasks from MySQL|TiDB to PostgreSQL. | None |
| 06-05 | Data Replication | Replication Performance Optimization | Added batch writing method to improve incremental replication performance for Oracle as the target, significantly increasing write speed. | None |
| 06-05 | Data Replication | Replication Performance Optimization | Optimized data reading method and delay calculation algorithm for MongoDB incremental replication, resolving OOM issues and achieving incremental data reading performance of 20-30 MB/s. | None |
| 06-05 | Data Replication | Replication Function Optimization | Added a bulk skip feature for error prompts on the replication task details page. | None |
| 06-05 | Database DevOps | Structure Design and Release | Added support for multiple data sources in the structure design and release feature. Currently supported data sources include: MySQL, SQL Server, PostgreSQL, Oracle, OceanBase for Oracle, DB2, DM, Kingbase, Klustron, openGauss, TiDB, GreatSQL, GBase, MongoDB, Redis, Doris, SelectDB, AnalyticDB for PostgreSQL. | Structure Design and Release |
| 06-05 | Database DevOps | Data Archiving and Cleaning | Added option for MySQL data sources when creating data archiving tasks. This option supports configuring conflict handling strategies when archiving data to the target end. | Data Archiving and Cleaning |
| 06-05 | Database DevOps | SQL Tasks (GBase) | The SQL Tasks feature now supports GBase data sources. You can initiate change requests for GBase data sources through SQL tasks, with options for immediate or scheduled execution. | SQL Tasks |
| 06-05 | Database DevOps | Data Export Digital Watermark | NineData supports embedding watermarks in exported Excel files. The watermark includes the user's name, helping trace data leaks and assign responsibility. Additionally, the data watermark serves as a reminder, embedding the user's identity into the page to encourage cautious behavior and reduce misconduct. | Data Export |
May
| Release Date | Module | Function | Release Details | Related Links |
|---|---|---|---|---|
| 05-30 | Database DevOps | Table Group Query | The table group query feature allows you to perform unified queries on multiple sub-databases and sub-tables through the SQL console, significantly simplifying the complexity of data queries in the context of sub-database and sub-table setups, and improving query efficiency. | Unified Query for Sub-Databases and Sub-Tables |
| 05-30 | Database DevOps | Data Export (GreatSQL) | The data export feature now supports GreatSQL data sources, allowing you to export data through database tables or SQL query statements. | Data Export |
| 05-30 | Database DevOps | Data Import (GreatSQL) | The data import feature now supports GreatSQL data sources, allowing you to import SQL, CSV, and EXCEL files containing data into the target database. | Data Import |
| 05-30 | Database DevOps | SQL Tasks (GreatSQL) | The SQL tasks feature now supports GreatSQL data sources, allowing you to initiate change requests for GreatSQL data sources through SQL tasks, with options for immediate or scheduled execution. | SQL Tasks |
| 05-30 | Database DevOps | SQL Console (GreatSQL) | The SQL console now supports GreatSQL data sources, allowing you to manage your GreatSQL data sources through the SQL console. | SQL Console |
| 05-30 | Database DevOps | SQL Console (GBase) | The SQL console now supports GBase data sources, allowing you to manage your GBase data sources through the SQL console. | SQL Console |
| 05-30 | Basic Services | Access IP Whitelist | NineData introduces a new security policy for organizations: the access IP whitelist. System administrators can enable the whitelist for trusted networks, blocking all networks outside the whitelist from accessing the current organization. This restriction enhances data and service security by preventing unauthorized access, even if an intruder knows an organization member's account credentials. | Manage Access IP Whitelist |
| 05-30 | Basic Services | Data Source Transmission Encryption | NineData will encrypt all sensitive fields (such as database passwords, cloud vendor access credentials, etc.) during network transmission with user data sources, making the use of the NineData platform more secure and reliable. | None |
| 05-30 | Basic Services | New Data Source Support | Added support for integrating GBase data sources into NineData. | Create Data Source |
| 05-30 | Basic Services | New Data Source Support | Added support for integrating GreatSQL data sources into NineData. | Create Data Source |
| 05-22 | Data Replication | Replication Performance Optimization | Optimized data reading and writing methods for TiDB to PostgreSQL link, significantly enhancing full replication performance (approximately 30-120 MB/s). | None |
| 05-22 | Data Replication | Replication Function Optimization | Added feature in PostgreSQL to Oracle replication link, supporting custom specification of tablespaces for tables and indexes. | None |
| 05-22 | Data Replication | New Replication Link | Added support for data replication of MariaDB (entered as MySQL type). | Data Replication |
| 05-22 | Data Replication | New Replication Link | Added a new replication link from Oracle to Kafka. | Data Replication |
| 05-22 | Data Replication | Batch Operations for Task List | In the task list page of data replication, you can now select multiple data replication tasks and perform batch delete, batch terminate, batch pause, and batch start operations. | None |
| 05-22 | Data Replication | Field Expression (ETL) | Data replication now supports ETL (Extract, Transform, Load) functionality, allowing data to be read from the source during replication, processed and transformed into the desired state, and then replicated to the target. Currently supported replication links include MySQL to MySQL and Sybase to PostgreSQL. | Data Replication |
| 05-22 | Database DevOps | Data Export (Redis) | Data export functionality now supports Redis data sources, allowing data to be exported via query statements. | Data Export |
| 05-22 | Database DevOps | Data Archiving and Cleaning | Significant feature enhancements:
| Data Archiving and Cleaning |
| 05-15 | Database DevOps | Menu and Entry Adjustment | In this release, we have adjusted the menu and entry points in Database DevOps. The left-side menu items have been reclassified and optimized. Now, you can reach the desired functions with fewer clicks, and the new function naming makes the understanding of functions more intuitive. | None |
| 05-15 | Database DevOps | Data Tracking and Rollback | The data tracking and rollback feature has been enhanced to include the generation and download of rollback statements. This facilitates the batch download of rollback SQL and batch execution in the data source. | Track and Rollback |
| 05-15 | Database DevOps | SQL Code Review | Added SQL code review for two different data sources (XML files, code packages). | SQL Code Review |
| 05-15 | Database DevOps | Data Export (TiDB) | The data export feature now supports TiDB data sources, allowing export via database tables or SQL query statements. | Data Export |
| 05-15 | Database DevOps | Data Import (TiDB) | The data import feature now supports TiDB data sources, enabling the import of SQL, CSV, EXCEL files containing data into the target database. | Data Import |
| 05-15 | Database DevOps | New Data Source Support | Added support for incorporating Alibaba Cloud AnalyticDB PostgreSQL version data sources into NineData. | Create Data Source |
| 05-15 | Data Replication | Replication Feature Optimization | On the configure replication object page, it is now possible to import configuration files in Excel format for the target object. | Data Replication |
| 05-15 | Data Replication | Replication Feature Optimization | When selecting replication objects with PostgreSQL, Sybase, TiDB, Oracle as the source, a search function is supported. | Data Replication |
| 05-15 | Data Replication | New Replication Link | Added a new replication link from StarRocks to Doris. | Data Replication |
| 05-15 | Data Replication | New Replication Link | Added a new replication link from SelectDB to Doris. | Data Replication |
| 05-15 | Basic Services | Two-Factor Authentication | For ordinary accounts (registered via phone number, WeChat scan, or email), if there is no history of device login within 30 days or a new device logs in via account password, a text message (or email) verification code will be triggered after password verification success, and only after passing the verification can one enter the console. | None |
| 05-08 | Database DevOps | Task List Optimization | Added a new task type in the task list of Database DevOps. You can now quickly view permission requests that require approval on the task list page. | Workbench |
| 05-08 | Database DevOps | Data Archiving | Provided an Execution Duration option for periodic tasks when creating data archiving tasks. You can use this option to limit the execution duration of tasks, preventing them from exceeding the expected duration and adversely affecting the business database. For example, you can schedule an archiving task to start at 0:00 during off-peak hours and set the execution duration to 6 hours. Even if the task hasn't completed by 6:00 in the morning, it will automatically stop to avoid disrupting business operations. | Data Archiving and Cleanup |
| 05-08 | Database DevOps | Data Export | Added pause and resume functionality to data export tasks to reduce additional impacts on the business database during peak hours. | Data Export |
| 05-08 | Database DevOps | Data Import | Added pause and resume functionality to data import tasks to reduce additional impacts on the business database during peak hours. | Data Import |
April
| Release Date | Module | Function | Release Details | Related Links |
|---|---|---|---|---|
| 04-24 | Basic Service | Workbench | The NineData workbench displays an overview of all tasks under the current account, as well as a summary of tickets (pending approval, pending execution, submitted by me). Modules involved include SQL tasks, data import/export, data archiving, data tracking, data replication, data backup and recovery, database comparison, data sources, etc. | Workbench Introduction |
| 04-24 | Basic Service | Adding Alert Rules | When creating alert rules, two conditions and are added to the alert conditions of data replication tasks, allowing you to configure alerts more flexibly. | Configure Alert Policies |
| 04-24 | Data Replication | Periodic Full Replication Throttling | During periodic full replication, support for throttling the rate of full replication is added to reduce the performance impact on the business database caused by excessive read traffic during full-speed replication. | Periodic Full Replication |
| 04-24 | Database DevOps | Task List | The database DevOps adds a task list feature, which summarizes all database DevOps tasks related to oneself in the current organization. You can quickly filter by task type, task relationships, task status, and also support searching and locating target tasks by data source name, database name, creation time, submitter, task name, or ID. | N/A |
| 04-24 | Database DevOps | Sensitive Data Management (TiDB) | The sensitive data management feature now supports configuring sensitive columns for TiDB data sources. | Manage Sensitive Data |
| 04-24 | Database DevOps | Permission Application (TiDB) | Added permission control for TiDB data sources, allowing users in your organization to apply for read/write permissions for TiDB data sources at the data source level, database level, or sensitive column level. | Permission Application and Approval |
| 04-24 | Database DevOps | SQL Review (TiDB) | NineData SQL Review now supports TiDB data sources. | SQL Review |
| 04-24 | Database DevOps | SQL Task (TiDB) | The SQL task feature now supports TiDB data sources, allowing change requests to TiDB data sources to be initiated via SQL tasks, supporting immediate or scheduled execution. | SQL Task |
| 04-24 | Database DevOps | SQL Console (TiDB) | SQL Console adds support for TiDB data sources, allowing you to manage your TiDB data sources through the SQL Console. | SQL Console |
| 04-18 | Database DevOps | New SQL Development Rule | Added “” 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-18 | Database DevOps | SQL Review | NineData SQL Review now supports OceanBase Oracle data sources. | SQL Audit |
| 04-18 | Database DevOps | Data Tracking | NineData data tracking feature added the rollback SQL download function. | Data Tracking |
| 04-18 | Basic Services | New Data Source Support | Added support for adding OceanBase for MySQL data sources to NineData. | Creating Data Sources |
| 04-18 | Data Replication | Refresh Metadata | During 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-11 | Data Replication | Periodic Full Data Replication | The NineData data replication feature supports periodic full replication between two data sources, automatically transferring the source data in full to the target end based on preconfigured intervals. | Periodic Full Replication |
| 04-11 | Data Replication | Addition of Replication Links | Dozens 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-11 | Database DevOps | Data Tracking | The 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-11 | Database DevOps | SQL Console | When 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-11 | Database DevOps | SQL Console | When 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-11 | Database DevOps | SQL Review | The NineData SQL review feature now supports PostgreSQL data sources. | SQL Review |
| 04-11 | Database DevOps | Slow Query Analysis | The NineData slow query analysis feature now supports PostgreSQL data sources. | Slow Query Analysis |
| 04-11 | Basic Services | Addition of Data Source Support | Added support for bringing TiDB data sources into NineData. | Create Data Source |
| 04-11 | Basic Services | Addition of Data Source Support | Added support for bringing Sybase data sources into NineData. | Create Data Source |
| 04-11 | Basic Services | Addition of Data Source Support | Added support for bringing Hive data sources into NineData. | Create Data Source |
| 04-11 | Basic Services | Data Source Entry Optimization | When 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-02 | Database DevOps | Data Export | The 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-02 | Database DevOps | SQL Console | The 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-02 | Basic Services | New Architecture Support for Data Sources | Added support for two deployment architectures of MySQL data sources: disaster recovery and read-write splitting. | Create Data Source |
| 04-02 | Basic Services | Data Source Input Optimization | Introducing a Read Preference Setting for Read Traffic Distribution in MongoDB Replica Set Architecture. | Create Data Source |
March
| Release Date | Module | Function | Release Details | Related Links |
|---|---|---|---|---|
| 03-27 | Database DevOps | Product Upgrade | NineData'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-27 | Basic Services | Audit Log | Two optimizations have been added to the audit log functionality:
| Audit Log |
| 03-27 | Database DevOps | SQL Task | The automatic backup feature for SQL tasks now supports PostgreSQL data sources. | SQL Task |
| 03-27 | Database DevOps | Data Archiving | Data archiving functionality now supports PostgreSQL data sources. | Data Archiving |
| 03-27 | Database DevOps | Sensitive Data Management | Sensitive data management functionality now supports configuring sensitive columns for PostgreSQL data sources. | Manage Sensitive Data |
| 03-27 | Database DevOps | Table-Level Permission Request | NineData 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-27 | Database DevOps | Development Pipeline | The 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-13 | Database DevOps | Add 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-13 | Database DevOps | Permanent Free Version of Database DevOps Professional Edition | NineData 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-28 | Database DevOps | SQL Console | Added 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-28 | Basic Services | No Specify Approver | Added 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-28 | Basic Services | Added Support for New Data Sources | Added support for Tencent Cloud TDSQL PostgreSQL instances. | Create Data Source |
| 02-28 | Basic Services | Added Support for New Data Sources | Added support for Tencent Cloud TDSQL MySQL instances. | Create Data Source |
| 02-22 | Basic Services | Automatically Create Organization for New Registered Users | For 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-22 | Data Comparison | Data Comparison between MySQL and PostgreSQL | Added support for data comparison between MySQL and PostgreSQL data sources. | Data Comparison |
| 02-22 | Data Replication | Structure Replication from MySQL to Greenplum | Added 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-22 | Data Replication | MySQL to PostgreSQL Replication | Added support for data replication from MySQL to PostgreSQL, supporting structure, full, and incremental data replication. | MySQL Replication to PostgreSQL |
| 02-05 | Data Replication | Oracle to PostgreSQL | Data replication from Oracle to PostgreSQL is now supported. It includes support for structural, full, and incremental data replication. | Oracle to PostgreSQL Replication |
| 02-05 | Database DevOps | Administrator Mode for Task Tickets | SQL 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-05 | Database DevOps | Full-Featured Database DevOps | Full 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-05 | Basic Services | Added Data Source Support | Added support for Baidu Cloud GaiaDB as a data source. | Create Data Source |
| 02-05 | Basic Services | Configure Session Timeout | System 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-31 | Basic Service | Permission Application (Redis SQL Task Permissions) | Support applying for Redis SQL task permissions. | Permission Application and Approval |
| 01-31 | Database DevOps | SQL Console Optimization | The SQL Console style has been optimized as follows:
| SQL Console (RDBMS) |
| 01-31 | Data Replication | Structural Conversion | NineData's structural conversion functionality now supports downloading converted SQL scripts, which can be batch executed in the target database. | Structural Conversion |
| 01-31 | Data Replication | MySQL to StarRocks | NineData data replication supports synchronization of structure, full data, and incremental data from MySQL to StarRocks data sources. | Replication to StarRocks |
| 01-31 | Data Replication | Kafka to Kafka | Kafka to Kafka data replication functionality is now supported. | Kafka to Kafka Replication |
| 01-24 | Data Replication | Structural Transformation | NineData 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-24 | Basic Services | Addition of Data Source Support | Addition 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-24 | Database DevOps | Data Archiving | NineData 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-24 | Database DevOps | SQL Review | Major 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-24 | Database DevOps | Data Export (ClickHouse) | Data export functionality now supports ClickHouse data sources and can be exported using SQL query statements. | Data Export |
| 01-16 | Database DevOps | OnlineDDL Optimization | Added 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-16 | Database DevOps | Database DevOps Standards Update | Added the "" rule to control the execution of NoSQL commands in SQL tasks. | Overview of SQL Development Rules |
| 01-16 | Basic Services | Encryption for Redis Data Source | When 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-10 | Data Comparison | Data Comparison between Oracle and SingleStore | Data comparison functionality between Oracle and SingleStore has been supported. | Data Comparison |
| 01-10 | Data Replication | Oracle to MySQL | Data replication from Oracle to MySQL is now supported, covering structural, full, and incremental data replication. | Oracle to MySQL Replication |
| 01-10 | Data Replication | Oracle to SingleStore | Data 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-10 | Database DevOps | Addition of SQL Development Rules | Addition of the "" rule for setting the concurrency of SQL tasks. | Overview of SQL Development Rules |
| 01-10 | Database DevOps | OnlineDML | NineData'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-10 | Basic Services | Monitoring Alerts Support Email Service | Support 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-03 | Data Replication | MongoDB Replication Optimization | After 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-03 | Data Replication | Redis Replication Optimization | During 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-03 | Data Replication | MySQL Replication Optimization | Optimizes the performance of reading large transactions in MySQL incremental replication, reduces CPU consumption, and decreases latency. | MySQL Replication to MySQL |
| 01-03 | Database DevOps | Batch Database Changes | Supports 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 |
) above the left navigation tree).