skip to Main Content

I have an Ubuntu 20.04.5 install which has a Cassandra database which I want to connect to with DbVisualizer v14.0.1 using the Cassandra Twig driver (for reasons best known to my organisation).

I have installed DbVis and downloaded the cassandra-twig-jdbc-3.0.1.jar driver, started DbVis with the free version.

I have installed the driver successfully, providing the URL format as jdbc:cassandra://<server>:<port>/<database> specified by the Cassandra docs, and named it ‘Cassandra’:
driver manager screenhot

I am now trying to create a database connection, for which the documentation states there is a wizard, however I cannot find that.

Going with a manual connection, I do not see the Database Connection panel described by the documentation, I just get a driver selection:
enter image description here

If I select the ‘Cassandra’ driver I don’t get a ‘Database URL’ field:
database connection

Clicking ‘Connect’ fails – how can I define the connection URL for my local database?

2

Answers


  1. Open Tools->Driver Manager and choose the Cassandra DataStax driver entry. In the right pane click the Start Download link. Once ready, close the dialog. In the main window and in the Databases tab, click to create a new database connection and choose Cassandra DataStax. Now you can choose Database URL.

    Login or Signup to reply.
  2. The first step where you have installed the Twig driver in DBVisualizer, that’s where you configure the URL.

    In your screenshot, you have configured it with:

    jdbc:cassandra://<server>:<port>/<database>
    

    You should instead populate it with details of your cluster. For example, for this cluster:

    • contact point IP – 10.1.2.3
    • client port – 9042
    • keyspace name – mykeyspace

    the corresponding JDBC URL is:

    jdbc:cassandra://10.1.2.3:9042/mykeyspace
    

    I haven’t written instructions specifically for DBVisualizer but if you’re interested, I’ve written one for DBeaver in this post — How do I connect to Cassandra with Dbeaver Community edition?. Cheers!

    Login or Signup to reply.
Please signup or login to give your own answer.
Back To Top
Search