This topic describes the clients and extract-transform-load (ETL) tools that AnalyticDB
for MySQL supports as well as their compatibility with AnalyticDB for MySQL. The following
tables list the compatibility from multiple aspects, such as database connectivity,
database listing, table creation, and table data query.
Compatibility of clients with AnalyticDB for MySQL
| Client |
Connection to AnalyticDB for MySQL |
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 |
| Sequel Pro |
Coming soon |
| Metabase |
Coming soon |
| Power BI |
Coming soon |
Compatibility of ETL tools with AnalyticDB for MySQL
| ETL tool |
Connection to AnalyticDB for MySQL |
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 |
| Informatica |
Coming soon |
| Talend |
Coming soon |
| Kettle |
Coming soon |