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 Coming soon
QlikView 10 on Win (Personal Edition) Coming soon
QlikView 10 on Win (Personal Edition) Coming soon
FineBI 5.0 Coming soon
FineReport 10.0 Coming soon
Metabase Coming soon
Sequel Pro 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 functions.
  • 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 Coming soon
Informatica Coming soon
Talend Coming soon
Kettle Coming soon