As a distributed database, OceanBase Database excels at handling massive data storage and computation. By integrating with mainstream BI tools (such as Superset and Power BI), OceanBase Database enables users to quickly transform complex data into intuitive charts, supporting business decision-making, real-time monitoring, and multidimensional analysis.
Supported BI tools
Apache Superset
- Flexible customization: Supports direct SQL queries on OceanBase tables, allowing customization of dashboards and data boards.
- SQL query optimization: Leverages OceanBase Database's HTAP capabilities to execute complex analytical SQL directly in Superset.
For more information, see Analyze data by using Superset and OceanBase Database.
Power BI
- Enterprise-level collaboration: Supports hierarchical permissions, dataset sharing, and real-time refresh.
- ODBC driver: Allows connection to clusters by installing the OceanBase ODBC driver and using Power BI Desktop.
- Real-time analysis: Uses the DirectQuery mode of Power BI to dynamically query OceanBase Database.
For more information, see Connect to OceanBase Database in Power BI and obtain data.
Quick BI
- Direct connection to OceanBase: Allows configuration of data sources through the Alibaba Cloud console without the need for additional drivers.
- Integrated workflow: Seamlessly integrates with DataWorks and MaxCompute to create an end-to-end analysis pipeline.
For more information, see Connect to OceanBase Database in Quick BI and obtain data.
Tableau
- Enterprise-level deployment: Provides the Server edition for large-scale team collaboration.
- JDBC/ODBC driver: Allows connection to OceanBase clusters by installing the Tableau connector and configuring the connection parameters.
- Data extraction: Supports offline storage of data to accelerate complex analysis.
For more information, see Connect to OceanBase Database in Tableau.
GuanData BI
- AI-enhanced analytics: Integrates built-in predictive models and anomaly detection features.
- Direct connection to OceanBase: Allows configuration of cluster IP, port, and account through the GuanData BI database connector.
- Predefined templates: Provides OceanBase data panel templates for industries such as e-commerce and finance.
Yonghong vividime BI
- High-performance processing: Supports second-level responses for billions of records, optimized for OceanBase's HTAP architecture.
- JDBC driver: Allows connection to OceanBase clusters by configuring the JDBC connection parameters and supports distributed query optimization.
- Data governance: Integrates a built-in data cleansing tool that automatically adapts to the partitioned tables and index structure of OceanBase Database.