This topic describes the clients and Extract, Transform, Load (ETL) tools that AnalyticDB for MySQL supports. The following tables list the compatibility of clients and ETL tools with AnalyticDB for MySQL from a variety of aspects such as database connectivity, database listing, table creation, and table data query.
Compatibility of clients with AnalyticDB for MySQL
| Client |
Database connectivity |
Database listing |
Table creation |
Table listing |
Table schema query |
Data write |
Table query |
View creation |
View structure query |
View query |
| Navicat Premium |
Supported |
Supported |
Supported |
Supported |
Supported |
Supported |
Supported |
Supported |
Supported |
Supported |
| DBeaver |
Supported |
Supported |
Supported |
Supported |
Supported |
Supported |
Supported |
Supported |
Supported |
Supported |
| DBVisualizer |
Supported |
Supported |
Supported |
Supported |
Supported |
Supported |
Supported |
Supported |
Supported |
Supported |
| SQL WorkBench/J |
Supported |
Supported |
Supported |
Supported |
Supported |
Supported |
Supported |
Supported |
Supported |
Supported |
| DataGrip |
Supported |
Supported |
Supported |
Supported |
Supported |
Supported |
Supported |
Supported |
Supported |
Supported |
| Superset |
Supported |
Supported |
Supported |
Supported |
Supported |
Supported |
Supported |
Supported |
Supported |
Supported |
| Tableau |
Supported |
Supported |
N/A |
Supported |
N/A |
N/A |
Supported |
N/A |
N/A |
Supported |
| QlikView |
Supported |
Supported |
N/A |
Supported |
Supported |
N/A |
Supported |
N/A |
Supported |
Supported |
| Yonghong BI |
Supported |
Supported |
N/A |
Supported |
Supported |
N/A |
Supported |
N/A |
Supported |
Supported |
| FineBI 5.0 |
Supported |
Supported |
N/A |
Supported |
Supported |
N/A |
Supported |
N/A |
Supported |
Supported |
| FineReport 10.0 |
Supported |
Supported |
N/A |
Supported |
Supported |
N/A |
Supported |
N/A |
Supported |
Supported |
| Smartbi |
Supported |
Supported |
N/A |
Supported |
Supported |
Supported |
Supported |
N/A |
Supported |
Supported |
Compatibility of ETL tools with AnalyticDB for MySQL
| ETL tool |
Database connectivity |
View query |
Table query |
Data write |
Database listing |
Table creation |
Table listing |
Table schema query |
View structure query |
View creation |
| Oracle Golden Gate |
Supported |
Supported |
Supported |
Supported |
- Oracle GoldenGate (OGG) is used for channel synchronization. It does not support these features.
- Before you use OGG, create a source Oracle table, a destination AnalyticDB for MySQL table, an OGG synchronization channel, and MySQL tables used to store the metadata of the source Oracle table.
|
| Scriptella |
Supported |
Supported |
Supported |
Supported |
Supported |
Supported |
Supported |
Supported |
Supported |
Supported |