This topic describes the business intelligence (BI) tools, database management tools, and extract, transform, load (ETL) tools that you can connect to MaxCompute.
BI tools
After you obtain data from computing engines, you can use BI tools to visualize data on dashboards or in charts or graphs. Data visualization helps you make informed business decisions.
The following table describes the BI tools that are supported by MaxCompute.
- BI tools
Tool Required version Access method References Tableau - Tableau: Tableau Desktop 2019.4 and later
- MaxCompute: JDBC driver V3.0.1 and later
Connect Tableau to MaxCompute Yonghong BI Yonghong Desktop: V8.6 and later Connect Yonghong BI to MaxCompute Add a MaxCompute data source Quick BI No special requirements Connect Quick BI to MaxCompute Add a cloud data source MaxCompute - Open source BI tools
Tool Required version Access method References Superset - Superset: no special requirements
- Python on MaxCompute (PyODPS): V0.10.7 and later
Connect Superset to MaxCompute Extra databases settings
Database management tools
Database management tools are GUI tools that are necessary for personnel who manage databases. These tools help the personnel query data.
The following table describes the database management tools that are supported by MaxCompute.
| Tool | Required version | Access method | References |
|---|---|---|---|
| DBeaver |
|
Connect DBeaver to MaxCompute | Create Connection |
| DataGrip |
|
Connect DataGrip to MaxCompute | Database Connection |
| SQL Workbench/J |
|
Connect SQL Workbench/J to MaxCompute | JDBC Drivers |
ETL tools
ETL is a procedure to extract data from the source, transform the data, and load the data to the destination.
The following table describes the ETL tools that are supported by MaxCompute.
| Tool | Access method |
|---|---|
| Kettle | Use Kettle to schedule MaxCompute jobs |
| Apache Airflow | Use Apache Airflow to schedule MaxCompute jobs |
| Azkaban | Use Azkaban to schedule MaxCompute jobs |