As a high-performance distributed relational database, OceanBase Database provides a comprehensive ecosystem that integrates many tools to simplify database management, improve operational efficiency, and seamlessly connect to a variety of IT environments.
Programming languages
C: a general-purpose programming language that is widely used in the development of system software and applications. For more information, see Connect to OceanBase Database by using MySQL Connector/C and Connect to OceanBase Database by using OceanBase Connector/C.
Java: a popular, object-oriented programming language that powers many applications. For more information, see Connect to OceanBase Database by using OceanBase Connector/J.
Python: a versatile, high-level programming language with easily readable syntax. For more information, see Connect to OceanBase Database by using mysqlclient.
PHP: a widely-used, open-source server scripting language that is designed specifically for website and server-side application development. For more information, see Connect to OceanBase Database by using the EXT driver. This tool is under beta testing. Preliminary testing has been completed, pending comprehensive adaptation.
Go: a statically typed, compiled programming language designed by Google. It is known for its concurrency model and high efficiency. For more information, see Connect to OceanBase Database by using Go-SQL-Driver/MySQL.
ORM frameworks
Java
- Sprint Boot: a framework that simplifies the development of Spring Boot applications. It allows you to quickly create independent production-level Spring Boot applications. For more information, see Connect to OceanBase Database by using Spring Boot.
- Spring Batch: a framework intended for batch processing tasks. It supports large-scale data processing and provides flexible execution and monitoring mechanisms. For more information, see Connect to OceanBase Database by using Spring Batch.
- Spring Data JDBC: an important module for simplifying database access. It provides a series of classes and APIs for simpler and more efficient interactions between Java applications and relational databases. For more information, see Connect to OceanBase Database by using Spring Data JDBC.
- Spring Data JPA: a persistence framework that simplifies database operations and enhances the readability of code in accordance with the JPA specifications. For more information, see Connect to OceanBase Database by using Spring Data JPA.
- Hibernate: a powerful object-relational mapping (ORM) framework that automatically maps Java objects and database tables and supports complex queries and transaction management. For more information, see Connect to OceanBase Database by using Hibernate.
- MyBatis: a semi-automated persistence framework that allows developers to customize SQL statements and maps the SQL statements to Java objects, contributing to high flexibility. For more information, see Connect to OceanBase Database by using MyBatis.
Go
- GORM: a powerful ORM library that provides simple APIs and efficient database operations. It supports multiple types of databases and provides the migration feature. For more information, see Connect to OceanBase Database by using GORM.
Data integration
- Change Data Capture (CDC) Connectors for Apache Flink ("Flink CDC" for short): Apache Flink is an open-source framework for large-scale data processing and analysis. Flink CDC is a set of connectors for Apache Flink to capture database change events. By leveraging the capabilities offered by the framework, Flink CDC provides a powerful real-time data processing and analysis solution. For more information, see Use Flink CDC to synchronize data from a MySQL database to OceanBase Database and Use Flink CDC to migrate data from OceanBase Database to a MySQL database.
- Canal: a CDC framework for database synchronization and integration. For more information, see Use Canal to synchronize data from a MySQL database to OceanBase Database and Use Canal to synchronize data from OceanBase Database to a MySQL database.
- Amazon Web Services (AWS) Glue: a serverless data integration service. It helps users easily discover, prepare, move, and integrate data from multiple sources to support analytics, machine learning, and application development. AWS Glue provides comprehensive data integration capabilities, including data discovery, modern extract-transform-load (ETL), data cleansing and transformation, and centralized cataloging, all integrated into a single service. For more information, see Migrating OceanBase Data Using AWS Glue.
- data build tool (dbt): an open-source data conversion tool that can convert commands into tables or views by using SQL. For more information, see Analyze data in OceanBase Database by using dbt.
- Maxwell: a CDC tool for MySQL databases. For more information, see Read data from OceanBase Database by using Maxwell.
- SeaTunnel: a high-performance, distributed data integration platform for data migration and real-time streaming tasks. For more information, see Read and synchronize data in OceanBase Database by using SeaTunnel. This tool is under beta testing. Preliminary testing has been completed, pending comprehensive adaptation.
- Debezium: an open-source distributed platform that monitors and captures database change events and turns them into event streams that can be used by various consumers. For more information, see Connect to OceanBase Database by using Debezium and obtain data.
SQL development
- Navicat: a database management and development tool that allows you to connect to multiple database systems. For more information, see Connect to OceanBase Database by using Navicat.
- DBeaver: a free general-purpose database management tool with a range of features. For more information, see Connect to OceanBase Database by using DBeaver. This tool is under beta testing. Preliminary testing has been completed, pending comprehensive adaptation.
- DataGrip: an integrated development environment (IDE) developed by JetBrains for database management and SQL development. It can help database developers and data analysts to efficiently manage and query databases, write complex SQL queries, as well as design and maintain databases. For more information, see Connect to OceanBase Database in DataGrip.
- TablePlus: a modern native database management tool that provides a convenient and user-friendly GUI for managing various relational databases, such as MySQL, PostgreSQL, and SQLite. For more information, see Connect to OceanBase Database in TablePlus.
Orchestration
DolphinScheduler: an open-source, distributed workflow task scheduling system that supports multiple types of tasks. For more information, see Configure an OceanBase data source for DolphinScheduler. This tool is under beta testing. Preliminary testing has been completed, pending comprehensive adaptation.
Linkis: an open-source general-purpose computing framework for enterprises, which supports task scheduling and management of multiple computing engines. For more information, see Integrate OceanBase Database with Linkis.
Visualization
- Grafana: a tool for monitoring data in OceanBase Database. For more information, see Visualize OceanBase Cloud monitoring data with Grafana.
- Superset: an open-source business intelligence (BI) tool for data exploration and visualization. For more information, see Connect to OceanBase Database by using Superset. This tool is under beta testing. Preliminary testing has been completed, pending comprehensive adaptation.
- Power BI: a BI tool developed by Microsoft that allows you to easily connect to all sorts of data sources, convert and analyze data, and create interactive visualizations and reports. For more information, see Connect to OceanBase Database in Power BI and obtain data. This tool is under beta testing. Preliminary testing has been completed, pending comprehensive adaptation.
- Quick BI: a self-service data analysis and visualization tool developed by Alibaba Cloud. It allows you to further explore data with drag-and-drop operations and to create various charts and dashboards. For more information, see Connect to OceanBase Database in Quick BI and obtain data. This tool is under beta testing. Preliminary testing has been completed, pending comprehensive adaptation.
- Tableau: a tool that provides a simple UI to visualize and display a large amount of data. With powerful data processing capabilities, it enables both database beginners and experts to effectively gain data insights. For more information, see Connect to OceanBase Database in Tableau. This tool is under beta testing. Preliminary testing has been completed, pending comprehensive adaptation.
Database management
- The Database DevOps module of NineData provides powerful features such as data asset management, data query, SQL execution, data editing, data import and export, SQL approval workflow, SQL specification pre-check, approval process, and sensitive data protection. For more information, see Manage OceanBase data sources with NineData.
- Bytebase: A collaborative database management tool designed to streamline workflows. For more information, see Managing OceanBase Instances with ByteBase. Currently in Beta, it has completed initial testing and awaits further comprehensive adaptation.