Skip to content

‣ DBeaver

  • This article includes information that was originally written by Erick Ramirez on DataStax Community

Overview

DBeaver is a universal database management tool for everyone who needs to work with data in a professional way. With DBeaver you are able to manipulate with your data like in a regular spreadsheet, create analytical reports based on records from different data storages, export information in an appropriate format.

Prerequisites

This article assumes you have installed DBeaver Community Edition on your laptop or PC. It was written for version 21.2.0 on MacOS but it should also work for the Windows version.

Astra Community JDBC Drivers

1. Download JDBC Driver

Download latest archive astra-jdbc-driver-x.y.jar from Github Release page

2. Configure the Connection

The following screenshot are done with Dbeaver lite on MACOS

Go the DBeaver download page and download the version associated with your laptop.

  • Open DBeaver application

  • In the menu go Database > Driver manager

  • The Panel Click new without selecting anything

  • (1) Choose the TAB libraries
  • (2) Select Add File, look for the jar we just downloaded.

  • (1) Go back to the tab Settings and enter the following values:
  • (2) Driver Name: Astra JDBC Driver and driver Type: Generic
  • (3) Class Name: com.datastax.astra.jdbc.AstraJdbcDriver
  • (4) Username is token
  • (5) Save your modifications with [OK]

  • You have new entry in the list of drivers called Astra JDBC Driver

3. Create the DataSource

  • In the menu now select Database > New Database Collection

  • Pick the driver Astra JDBC Driver and click Next

  • Populate the URL as follow: jdbc:astra://<db>/<keyspace>?region=<region>

  • Populate your token value (it should start by AstraCS:...)

  • Click on Test Connection and validate with Finish

4. Use DataSource

  • On the left panel you can now see your data

Using JDBC Simba Drivers

1. Download JDBC Driver

Download the JDBC driver from the DataStax website:

  1. Go to https://downloads.datastax.com/#odbc-jdbc-drivers.
  2. Select Simba JDBC Driver for Apache Cassandra.
  3. Select JDBC 4.2.
  4. Read the license terms and accept it (click the checkbox).
  5. Hit the blue Download button.
  6. Once the download completes, unzip the downloaded file.

2. Import Driver

  1. Go to the Driver Manager.
  2. Click the New button.
  3. In the Libraries tab, click the Add File button.
  4. Locate the directory where you unzipped the driver download and add the CassandraJDBC42.jar file.
  5. Click the Find Class button which should identify the driver class as com.simba.cassandra.jdbc42.Driver.

  6. In the Settings tab, set the following:

  7. Driver Name: Astra DB

  8. Driver Type: Generic

  9. Class Name: com.simba.cassandra.jdbc42.Driver

  10. Click the OK button to save the driver

At this point, you should see Astra DB as one of the drivers on the list:



3. Create New Connection

Connect to your Astra DB in DBeaver:

  1. Open the New Database Connection dialog box.
  2. Select Astra DB from the list of drivers.
  3. In the Main tab, set the JDBC URL to: jdbc:cassandra://;AuthMech=2;TunableConsistency=6;SecureConnectionBundlePath=/path/to/secure-connect-dbeaver.zip Note That you will need to specify the full path to your secure bundle.
  4. In the Username field, enter the string token

  5. In the Password field, paste the value of the token you created in the Prerequisites section above. The token looks like AstraCS:AbC...XYz:123...edf0.

  6. Click on the Connection details button

  7. In Connection name field, give your DB connection a name:
  8. Click the Finish button
  9. Click on the Test Connection button to confirm that the driver configuration is working:



4. Final Test

Connect to your Astra DB. If the connection was successful, you should be able to explore the keyspaces and tables in your DB on the left-hand side of the UI.

Here's an example output:

Last update: 2023-10-13