Database DevOps Professional Edition
NineData Database DevOps Professional Edition is designed for growing teams that need controlled SQL development, collaborative database changes, access management, and operational visibility across multiple data sources.
Key Features
- Database change review: Apply SQL development policies and approval workflows before changes are executed.
- Unified database workspace: Manage different databases from one web console instead of switching between separate tools.
- Access control: Let users request only the permissions they need, and assign access based on role and responsibility.
- OnlineDDL: Run supported lock-free table structure changes to reduce downtime risk.
- Audit logs: Keep 3 months of audit logs for security review and operational tracing.
- Sensitive data protection: Protect sensitive data in up to 3 data sources.
- Data generation: Generate realistic test data without exposing production data.
- Slow query analysis: Identify performance-impacting SQL and review optimization suggestions.
- Batch database changes: Apply the same structural or data change across multiple data sources, databases, or tables.
- Data archiving: Move inactive data to an archive database on demand or on a schedule.
- Development pipeline: Manage validation, approval, and release stages across development environments.
- Data tracking: Track data or object changes and generate rollback SQL when supported.
Use Cases
- Small and medium-sized teams: Support developers and DBAs who collaborate on schema design, SQL review, query writing, and performance troubleshooting.
- Multi-data-source environments: Manage databases across cloud providers, self-managed environments, and common engines such as MySQL, SQL Server, ClickHouse, and more.
- Controlled database changes: Route SQL changes through task management, policy checks, and approvals before execution.
Professional Edition Feature Overview
| Category | Feature Name | Subfeatures |
|---|---|---|
| Database DevOps | SQL Console | AI Services |
| Database Development Tools | ||
| Execution History | ||
| Visual Result Set Editing | ||
| Visual Table Structure Design | ||
| SQL Specification Pre-check | ||
| Sensitive Columns | ||
| SQL Task | SQL Task Submission and Execution | |
| Task Approval Workflow | ||
| Specification Pre-check | ||
| OnlineDDL | ||
| OnlineDML | ||
| Development Pipeline | ||
| Data Export | Data Export Task Submission and Execution | |
| Task Approval Workflow | ||
| Data Import | Data Import Task Submission and Execution | |
| Task Approval Workflow | ||
| Data Generation | - | |
| Slow Query | - | |
| Batch Data Change in Multiple instances | - | |
| Data Archiving | - | |
| Data Tracking | - | |
| Operation and Monitoring | Configure Alarm Receivers | - |
| Configure Alarm Policies | - | |
| View Alarm History | - | |
| Basic Services | Data Source Management | Add Self-built Data Sources |
| Add Cloud Vendor Data Sources | ||
| Environment Customization | ||
| Gateway Management | Create Gateway | |
| Create Proxy Gateway | ||
| Cloud Vendor Access Credentials | - | |
| Private Network Connection | - | |
| Manage Sensitive Data | - | |
| Standards and Processes | SQL Development Standards | |
| Approval Workflows | ||
| Account Management | Manage Organizations | Create Organization |
| Switch to Organization | ||
| View or Edit Organization Information | ||
| Manage Users | Invite Users | |
| Edit Users | ||
| Remove Users | ||
| Configure User Permissions | ||
| Manage Roles | Add Roles | |
| Edit Roles | ||
| Delete Roles | ||
| Bind Roles | ||
| Configure Role Permissions | ||
| Permission Application and Approval | Apply for Data Source Permissions | |
| Apply for Database Permissions | ||
| Apply for 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 Receipt Methods | |
| AIGC | Intelligent Question and Answer Robot ChatDBA | - |