Thursday 19 April 2018

Opensource DB UI Tool for Cassandra DB- DBweaver


DBweaver ::

Best opensource tool for CASSANDRA .

I spent lot of time to find open source tool for cassandra , atlast this is the right solution.


#dbeaver-cassandra cassandra db gui

1. Download dbeaver (Community Edition): dbweaver-Download
2. Download cassandra jdbc jar files: http://www.dbschema.com/cassandra-jdbc-driver.html or direct link CassandraJdbcDriver.zip
3. extract cassandra jdbc zip
4. run dbeaver.exe
5. go to Database > Driver Manager
6. click New
7. Fill in details as follow:
   - Driver Name: Cassandra (or whatever you want it to say)
   - Driver Type: Generic
   - Class Name: com.dbschema.CassandraJdbcDriver
   - URL Template: jdbc:cassandra://{host}[:{port}][/{database}]
   - Default Port: 9042
   - Embedded: no
   - Category: <leave blank>
   - Description: Cassandra (or whatever you want it to say)
8. click Add File and add all of the jars in the cassandra jdbc zip
9. click Find Class to make sure the Class Name is found okay
10. click OK
11. Create New Connection, selecting the database driver you just added
dbschema.com
Cassandra JDBC Driver | DbSchema Cassandra Designer
Cassandra free JDBC driver provided by DbSchema Cassandra Admin GUI Tool - best interface for complex Cassandra databases.

5 comments:

  1. Thank you very much!!! I was going through many tools for a proper GUI tool for Cassandra. You saved my day. It worked !!!!!!!!!

    ReplyDelete
  2. DbSchema Cassandra Admin GUI Tool is a free tool?

    ReplyDelete
  3. In latest versions of DBSchema, they don't ship Cassandra driver by default within a common package. When I download jdbc:cassandra driver from inside DBSchema exe and then import this driver into "dbeaver" I get some weird error "Null connection returned Bad URL: jdbc:cassandra://my-cassandra-host:9042" where my-cassandra-host is actually the IP of my local Cassandra host

    ReplyDelete
  4. Followed the instructions here and was able to connect, but when I try to query a table, it times out after 2 seconds with "SQL Error: Query timed out after PT2S". Haven't found a place where this 2 second timeout is specified. The query timeout in DBeaver is set to 0, which means no timeout (and I've tried increasing it, but doesn't help)

    ReplyDelete

Please comment here