This page describes the compatibility test results for DBeaver 6.1.2 Community Edition with AnalyticDB for MySQL. Ten scenarios are tested, covering connectivity, database operations, and view management.
Prerequisites
Before you begin, make sure you have:
AnalyticDB for MySQL V3.1.0 or later
DBeaver 6.1.2 Community Edition
Java 1.8.0_161 (Java(TM) SE Runtime Environment, build 1.8.0_161-b12; Java HotSpot(TM) 64-Bit Server VM, build 25.161-b12, mixed mode)
MySQL Ver5.6.46 for osx10.13 on x86_64 (Homebrew)
Compatibility test results
All ten scenarios pass compatibility testing. The following sections show the test results.
Test connectivity
Connect DBeaver to AnalyticDB for MySQL using the MySQL driver.
List databases
Browse the available databases after connecting.
Create a table
Create a new table in AnalyticDB for MySQL using DBeaver.
List all tables
View all tables in a database.
Query the schema of a table
Inspect the column definitions and structure of a table.
Write data to a table
Insert data into a table.
Query the data of a table
Run a SELECT query and view results in DBeaver.
Create a view
Create a view in AnalyticDB for MySQL using DBeaver.
Query the structure of a view
Inspect the definition of a view.
Query a view
Run a query against a view and review the results.
