Cassandra Dbeaver

Posted : admin On 1/3/2022

Latest DBeaver version contains driver for Apache Cassandra.
Currently it is accessible with Generic driver and JKISS Cassandra JDBC driver.
Although Cassandra is not relational database some concepts are similar to regualr databases – metadata browser makes sense and CQL queries are just like SQL.
Main difference is that Cassandra’s column families are not relational tables and doesn’t have particular set of columns. Generally each row may have its own set of columns and it makes standard resultset viewer almost useless. However you may execute simple CQL and browse column families with strict structure.
We are going to add non-relational data viewer features in future versions of DBeaver (it’ planned for Cassandra, Mongo, Berkley and probably for hierachical dbs like IMS).
JKISS Cassandra JDBC driver is open source. Sources can be checked out from SVN: https://svn.jkiss.org/dev/jkiss/trunk/jdbc/cassandra/.
It is based on cassandra jdbc project. It has Apache 2.0 license.
This driver provides additional support of Cassandra keyspace metadata + support of older (prior 1.x) Cassandra versions.
Also unnecessary dependencies removed (cassandra clientutil and google utils).

Check out popular companies that use DBeaver and some tools that integrate with DBeaver. PostgreSQL, SQLite, Oracle, DB2, SQL Server, Sybase, Teradata, MongoDB, Cassandra, Redis, etc. DBeaver is a tool in the Database Tools category of a tech stack. DBeaver is an open source tool with 20K GitHub stars and 1.9K GitHub forks. DBeaver is certainly an ultimate Universal client which incorporates RDBMS and NoSQL Databases. The GUI is very useful and easy to manipulate all kind of DB queries.DBeaver is remarkably fast and stable. It loads quickly and responds instantaneously. Especially, It is the only client tool for Apache Cassandra NoSQL Database in market. DBeaver is another Java-powered SQL client; like the JDBC connector, it has a large set of databases it can connect to. There’s an Enterprise version, which includes NoSQL database support (Cassandra, MongoDb and Redis), but the community edition is the one I’ve examined. Cassandra java driver 4 email protected AWS Kinesis KCL streams support #1667 by @aserrallerios. Cassandra Java driver 4. Alpakka Cassandra is completely rewritten and now based on the Cassandra Java driver version 4. Be comfortable with and use other Cassandra 2 features such as static columns.

If you are interested you may join this project. I’ll create landing site for it in nearest time.
If you have any questions/suggestions – please write me

Cassandra Dbeaver Connection

Posted in Articles

The CData JDBC Driver for Cassandra implements JDBC standards that enable third-party tools to interoperate, from wizards in IDEs to business intelligence tools. This article shows how to connect to Cassandra data with wizards in DBeaver and browse data in the DBeaver GUI.

Create a JDBC Data Source for Cassandra Data

Follow the steps below to load the driver JAR in DBeaver.

  1. Open the DBeaver application and, in the Databases menu, select the Driver Manager option. Click New to open the Create New Driver form.
  2. In the Driver Name box, enter a user-friendly name for the driver.
  3. To add the .jar, click Add File.
  4. In the create new driver dialog that appears, select the cdata.jdbc.cassandra.jar file, located in the lib subfolder of the installation directory.
  5. Click the Find Class button and select the CassandraDriver class from the results. This will automatically fill the Class Name field at the top of the form. The class name for the driver is cdata.jdbc.cassandra.CassandraDriver.
  6. Add jdbc:cassandra: in the URL Template field.
Dbeaver

Create a Connection to Cassandra Data

Dbeaver Cassandra Ssl

Follow the steps below to add credentials and other required connection properties.

  1. In the Databases menu, click New Connection.
  2. In the Create new connection wizard that results, select the driver.
  3. On the next page of the wizard, click the driver properties tab.
  4. Enter values for authentication credentials and other properties required to connect to Cassandra.

    Set the Server, Port, and Database connection properties to connect to Cassandra. Additionally, to use internal authentication set the User and Password connection properties.

    Built-in Connection String Designer

    For assistance in constructing the JDBC URL, use the connection string designer built into the Cassandra JDBC Driver. Either double-click the JAR file or execute the jar file from the command-line.

    java -jar cdata.jdbc.cassandra.jar

    Fill in the connection properties and copy the connection string to the clipboard.

    Below is a typical connection string:

    jdbc:cassandra:Database=MyCassandraDB;Port=7000;Server=127.0.0.1;

Query Cassandra Data

Dbeaver Cassandra Create Keyspace

You can now query information from the tables exposed by the connection: Right-click a Table and then click Edit Table. The data is available on the Data tab.