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.