MaxCompute supports various connection tools. Select the tool that best fits your use case and follow the instructions to prepare your environment.
Connection tool categories
SQL analysis
Use cases: Quick start, lightweight data analysis, and permission management.
|
Item |
Description |
|
Environment requirements |
We recommend using the latest version of Google Chrome. |
|
Access |
Console > . |
|
Instructions |
odpscmd
Use cases: Process data using the command line.
Comparison
|
Item |
Cloud Shell (odpscmd) |
MaxCompute client (odpscmd) |
|
Environment requirements |
No installation is required. |
|
|
Limitations |
Limitations apply to supported regions, the number of virtual machines, session windows, termination due to inactivity or expiration, file storage, and prohibited operations. For more information, see Limitations. |
None. |
|
Instructions |
MaxCompute Studio
Use cases: In-depth Java and Python development, and user-defined function (UDF) debugging.
|
Item |
Description |
|
Environment requirements |
|
|
Instructions |
DataWorks
Use cases: Visual development, data integration, data services, and periodic scheduling of jobs.
|
Item |
Description |
|
Environment requirements |
We recommend using the latest version of Google Chrome. |
|
Instructions |
Ecosystem tool integration
Database management tools
Use cases: Manage data using graphical database tools.
|
Tool |
Environment requirements |
Instructions |
|
DBeaver |
MaxCompute: JDBC driver 3.2.8 or later |
|
|
DataGrip |
MaxCompute: JDBC driver 3.2.8 or later |
|
|
SQL Workbench/J |
MaxCompute: JDBC driver 3.0.1 or later |
ETL tools
Use cases: Extract, transform, and load (ETL) data from a source to a destination.
|
Tool |
Environment requirements |
Instructions |
|
Kettle |
MaxCompute: JDBC driver 3.2.8 or later |
|
|
Apache Airflow |
No special requirements. |
|
|
Azkaban |
No special requirements. |
BI tools
Use cases: Visualize data from the compute engine using dashboards, charts, or other graphical outputs.
|
Tool |
Environment requirements |
Instructions |
|
Tableau |
|
|
|
FineBI |
|
|
|
FineReport |
|
|
|
Yonghong BI |
Yonghong BI: Desktop 8.6 or later |
|
|
Quick BI |
No special requirements. |
|
|
Guanyuan BI |
No special requirements. |
|
|
Netease YouShu BI |
No special requirements. |
|
|
Davinci |
MaxCompute: JDBC driver 3.2.8 or later |
|
|
Sugar BI |
No special requirements. |
|
|
Metabase |
|