Overview

2025-06-24 11:54:39  Updated

OceanBase, as a high-performance distributed relational database, has gradually built an ecosystem that integrates multiple tools, simplifying database management, improving operational efficiency, and achieving seamless integration with diverse IT environments.

integration-overview-en

Programming languages

Schema evolution

Data ingestion

  • Canal: A Change Data Capture (CDC) framework for database synchronization and integration. For more information, refer to Use Canal to synchronize data.

  • dbt: An open-source tool for data transformation. For more information, refer to Analyze OceanBase data by using dbt.

  • Debezium: An open-source enterprise-grade universal computing framework supporting multi-engine task scheduling and management. For more information, refer to Debezium.

  • Flink: An open-source framework for large-scale data processing and analysis. For more information, refer to Use Flink to synchronize data.

  • Glue: A serverless data integration service. For more information, refer to Migrating OceanBase Data Using AWS Glue.

  • Informatica Cloud: A cloud-based data integration and management solution. Users can connect and integrate heterogeneous data sources in cloud environments, including on-premises and cloud-based sources, for better data analysis, insights, and business decisions. For more information, refer to Data integration guide: Informatica Cloud and OceanBase.

  • Kafka: A high-performance distributed streaming platform. Kafka is commonly used for processing real-time data streams and is widely applied in building real-time data pipelines, stream processing applications, and real-time analytics systems. For more information, refer to Best practices for integrating OceanBase Database with Kafka.

  • Maxwell: A Change Data Capture (CDC) tool for MySQL databases. For more information, refer to Maxwell.

  • NiFi: Apache NiFi is an automated dataflow processing platform that enables efficient and reliable data transfer between systems. For more information, refer to Integrate OceanBase Cloud with Apache NiFi.

  • SeaTunnel: A distributed, high-performance data integration platform for data migration and real-time stream processing tasks. For more information, refer to SeaTunnel. Currently in Beta status, preliminary testing completed, pending comprehensive adaptation.

  • DataWorks: a data development and governance platform on Alibaba Cloud, based on big data engines such as MaxCompute, Hologres, EMR, AnalyticDB, and CDP, providing unified end-to-end processing capabilities for data warehouses, data lakes, and lakehouse solutions. For more information, refer to DataWorks.

SQL development

Orchestration

  • Airflow: An open-source platform designed for developing, scheduling, and monitoring batch-oriented workflows. For more information, refer to Integrate OceanBase Cloud with Apache Airflow.

  • DolphinScheduler: An open-source distributed workflow task scheduling system supporting various task types. For more information, refer to DolphinScheduler. Currently in Beta status, preliminary testing completed, pending comprehensive adaptation.

  • Linkis: An open-source enterprise-grade universal computing framework supporting multi-engine task scheduling and management. For more information, refer to Integrate OceanBase Database with Linkis.

Visualization

  • Grafana: A powerful and flexible open-source analytics and monitoring solution. For more information, refer to Visualize OceanBase Cloud monitoring data with Grafana.

  • Power BI: A collection of software services, applications, and connectors that work together to transform various data sources into coherent, visually immersive, and interactive insights. For more information, refer to Connect to OceanBase Cloud in Power BI.

  • QuickBI: An easy-to-use data visualization and analysis tool supporting rapid report generation. For more information, refer to Connect to OceanBase Cloud in Quick BI.

  • Superset: An open-source business intelligence tool for data exploration and visualization. For more information, refer to Connect to OceanBase Cloud in Superset. Currently in Beta status, preliminary testing completed, pending comprehensive adaptation.

  • Tableau: An intuitive data visualization tool for creating interactive and shareable reports. For more information, refer to Connect to OceanBase Cloud in Tableau. Currently in Beta status, preliminary testing completed, pending comprehensive adaptation.

Observability

Database management

  • Bytebase: A collaborative database management tool for streamlining workflows. For more information, refer to Manage OceanBase instances with Bytebase. Currently in Beta status, preliminary testing completed, pending comprehensive adaptation.

AI

Contact Us