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