This topic describes the business intelligence (BI) tools, database management tools, and extract, transform, load (ETL) tools that you can connect to MaxCompute.

The following figure shows the ecosystem architecture of MaxCompute. Ecosystem architecture

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.

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
  • DBeaver: no special requirements
  • MaxCompute: JDBC driver V3.2.8 and later
Connect DBeaver to MaxCompute Create Connection
DataGrip
  • DataGrip: no special requirements
  • MaxCompute: JDBC driver V3.2.8 and later
Connect DataGrip to MaxCompute Database Connection
SQL Workbench/J
  • SQL Workbench/J: no special requirements
  • MaxCompute: JDBC driver V3.0.1 and later
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