Introduction to NineData Database DevOps Enterprise Edition
NineData Database DevOps Enterprise Edition is a database management platform designed to support large-scale application development and enterprise-level requirements. It provides a range of powerful features to meet the customized Database DevOps and collaboration needs of multiple businesses and scenarios.
What Challenges Do Enterprise Users Face?
In traditional team collaboration development, there are often the following problems:
- Many Developers Directly Access the Database: Directly accessing the database can pose challenges to core business in terms of stability, audit compliance, and more. For example, an inefficient SQL query can directly impact the stability and performance of the core database, leading to critical business downtime and inestimable losses for the enterprise.
- Difficult Permission Control: Due to frequent employee turnover, the database's built-in authentication capabilities may not meet enterprise needs, making comprehensive permission management difficult.
- Lack of Standards: The absence of development standards can lead to ineffective management of SQL execution. Neglect on the part of developers can result in various issues related to business security, database performance, and more.
- Lack of Approval Processes: A lack of strict change management processes can lead to unapproved database changes, increasing the risk and likelihood of errors.
- Data Security Risks: Sharing sensitive information and database access credentials can lead to data leaks and security risks, especially in the absence of proper permission management.
What Is Database DevOps Enterprise Edition?
Database DevOps Enterprise Edition is a database collaborative management solution offered by NineData for medium to large enterprises. Databases are at the core of enterprise data assets, and effectively managing and protecting core data is crucial for business operations. Database DevOps Enterprise Edition aims to provide enterprises with a unified data management platform that includes advanced features such as team collaboration, permission control, data security protection, customized SQL development standards, automation of approval processes, audit logs, and more. It creates an efficient and secure database management environment, preventing security incidents like data leaks and database deletion.
Key Features
Database DevOps Enterprise Edition offers the following features:
- Unified Database Management Platform: NineData Database DevOps provides a unified database management platform for you and your team. Regardless of the database you use, you can perform operations in the same interface, eliminating the need to switch tools frequently and saving time learning and adapting to different tools.
- Customized Standards and Processes: Large enterprises typically have diverse business scenarios and needs. The Enterprise Edition allows you to customize SQL development standards and approval processes based on your business scenarios, meeting the differentiated requirements of various business teams. Automated process standards ensure that SQL changes undergo proper review and authorization, intercepting SQL statements that do not conform to standards, reducing the risk of introducing errors.
- Permission Control: Simplify the permission request process, allowing users to easily apply for the permissions they need, effectively avoiding unnecessary permission assignments and reducing security risks. It also supports role-based permission allocation, allowing appropriate permissions to be assigned based on user roles, ensuring that user data access and changes correspond to their responsibilities.
- Enterprise-Level Data Source Support: The Enterprise Edition is compatible with enterprise-level database management systems (such as Oracle) and supports all Database DevOps Enterprise Edition features.
- Extended Audit Log Retention: Provides a retention period of up to 3 years for audit logs, facilitating future audits and regulatory reviews. This helps meet compliance requirements and extends the time frame for tracking and analyzing user activities.
- Unlimited Sensitive Data Protection: Offers the capability to protect sensitive data from an unlimited number of data sources. This means you can extend sensitive data protection measures to all your business areas, ensuring the security of sensitive information.
- Single Sign-On (SSO): The Enterprise Edition introduces SSO functionality, supporting the SAML protocol (LDAP|OpenLDAP, etc.). It synchronizes enterprise member information to the NineData platform, simplifying the login process for enterprise members, enhancing security, and improving work efficiency.
- Data Watermarking: The Enterprise Edition offers data watermarking functionality to protect the content of the console pages. It can embed watermarks containing the information of the currently logged-in user in the console of the current organization, preventing users from taking screenshots or printing the current page information without authorization.
Use Cases
- Large-Scale Application Development: The Enterprise Edition is suitable for the development of large projects and applications. It can support high-performance queries and large-scale data processing on enterprise-level databases (e.g., Oracle).
- Compliance Requirements and Security Incident Tracing: The Enterprise Edition provides a retention period of up to 3 years for audit logs, facilitating future audits and regulatory reviews. It also extends the time frame for tracing security incidents for enterprises.
- Unlimited Sensitive Data Protection: Provides the capability to protect sensitive data from an unlimited number of data sources. This means you can extend sensitive data protection measures to all your business areas.
- Customized Standards and Processes Requirements: Large enterprises typically have diverse business scenarios, and the Enterprise Edition allows for customizable SQL development standards and approval processes to meet the differentiated requirements of various business teams.
- Single Sign-On (SSO) Requirements: The Enterprise Edition introduces SSO functionality, supporting LDAP|OpenLDAP systems, making it easy to synchronize enterprise member information to the NineData platform, simplifying the login process for enterprise members, enhancing security, and improving work efficiency.
- Application Integration: Provides console integration entry points, allowing you to integrate the NineData console into other tools, platforms, or applications to meet business customization requirements.
Getting Started with Enterprise Edition
Master Database DevOps Enterprise Edition in Three Minutes
Best Practice
- Add Sensitive Columns for All Business Data Sources
- View a Security Incident That Occurred Two Years Ago
- Create Custom SQL Development Standards for a Specific Department
- Create Custom Approval Processes for a Specific Department
- Import Member Information from LDAP into NineData for SSO Login
- Add Data Watermark to the Console to Prevent Security Incidents
- Query data across multiple different types of data sources from the database
- Collect slow queries in the database and generate optimization suggestions
Overview of Enterprise Edition Features
| Category | Function Name | Subfunction |
|---|---|---|
| Database DevOps | SQL Console | AI Services |
| Database Development Tools | ||
| Execution History | ||
| Visual Result Set Editing | ||
| Visual Table Structure Design | ||
| SQL Specification Precheck | ||
| Sensitive Columns | ||
| SQL Tasks | SQL Task Submission and Execution | |
| Task Approval Workflow | ||
| Specification Precheck | ||
| OnlineDDL | ||
| OnlineDML | ||
| Development Pipeline | ||
| Data Export | Export Task Submission and Execution | |
| Task Approval Workflow | ||
| Data Import | Import Task Submission and Execution | |
| Task Approval Workflow | ||
| Data Generation | - | |
| DSQL | - | |
| Slow Query | - | |
| SQL Review | - | |
| Batch Data Change in Multiple instances | - | |
| Data Archiving | - | |
| Data Tracking | - | |
| Operations and Monitoring | Configure Alert Receivers | - |
| Configure Alert Policies | - | |
| View Alert History | - | |
| Basic Services | Data Source Management | Add Custom Data Sources |
| Add Cloud Provider Data Sources | ||
| Enterprise-Level Data Sources (Oracle) | ||
| Environment Customization | ||
| Gateway Management | Create Gateway | |
| Create Proxy Gateway | ||
| Cloud Provider Access Credentials | - | |
| Private Network Connection | - | |
| Manage Sensitive Data | - | |
| Specifications and Processes | SQL Development Specifications | |
| Approval Workflows | ||
| Add Specifications | ||
| Add Workflows | ||
| Account Management | Manage Organizations | Create Organization |
| Switch to Organization | ||
| View or Edit Organization Information | ||
| Data Watermark | ||
| Single Sign-On (SSO) | ||
| Manage Users | Invite Users | |
| Add SSO Users | ||
| Edit Users | ||
| Remove Users | ||
| Configure User Permissions | ||
| Manage Roles | Add Roles | |
| Edit Roles | ||
| Delete Roles | ||
| Bind Roles | ||
| Configure Role Permissions | ||
| Permission Requests and Approvals | Request Data Source Permissions | |
| Request Database Permissions | ||
| Request Sensitive Column Permissions | ||
| My Permissions | Manage My Permissions | |
| Audit Logs | View Audit Logs | |
| Message Center | In-Site Messages | Receive In-Site Messages |
| Subscription Management | Configure Message Reception Methods | |
| AIGC | ChatDBA | - |