PolarDB:DBeaver

Prerequisites

• The DBeaver client is installed.

• A database account is created in the PolarDB cluster. For more information, see Create a database account.

• The IP address of the host that you use to access the PolarDB cluster is added to an IP address whitelist of the cluster. For information about, see Configure a whitelist for a cluster.

Procedure

1. In the menu of the DBeaver client, choose Database > Driver Manager. In the Driver Manager dialog box, click New.

   

2. In the Create new driver dialog box, configure the driver information.

   • On the Settings tab, configure basic driver information, including Driver Name, Class Name, URL Template, Default Port, Default Database, and Default User. We recommend that you set Driver Name to PolarDB.

     

     Note

     • For Class Name and URL Template, You can use the following values:

       • Class Name:

         com.aliyun.polardb2.Driver

       • URL Template:

         jdbc:polardb2://{host}[:{port}]/[{database}]

     • Default Port, Default Database, and Default User can also be specified when you create a database connection.

   • On the Libraries tab, click Add File to upload the custom JDBC driver. For more information about how to download the JDBC driver, see JDBC.

3. Click to create a connection to the PolarDB database.

   1. In the Connect to a database dialog box, select the PolarDB custom JDBC driver that you create and click Next.

      

   2. Configure the PolarDB database connection information, including Host, Port, Database/Schema, Username and Password, and then click Finish.