Apache Solr JDBC – DbVisualizer

Overview

My previous post on Apache Solr JDBC gave an introduction of the feature and a sneak peak into some of the SQL clients and database visualization tools that can be connected to Apache Solr. This post highlights how to connect DbVisualizer to Apache Solr using the JDBC driver. DbVisualizer is a Java based database query and management tool. The step by step guide below contains screenshots showing how to add the Apache Solr JDBC driver, make a connection to Solr, and then perform some SQL queries over Solr. This post corresponds to the Apache Solr JIRA SOLR-8521 and Apache Solr Reference Guide page on Parallel SQL.

Setup Driver

Open Driver Manager

dbvisualizer_solrjdbc_1

Add Driver

dbvisualizer_solrjdbc_2

Name the Driver

dbvisualizer_solrjdbc_3

Add Driver Files to the Classpath

dbvisualizer_solrjdbc_4 dbvisualizer_solrjdbc_5 dbvisualizer_solrjdbc_6 dbvisualizer_solrjdbc_7 dbvisualizer_solrjdbc_8 dbvisualizer_solrjdbc_9

Review and close Driver Manager

dbvisualizer_solrjdbc_10

Create a Connection

dbvisualizer_solrjdbc_11

Use the Wizard

dbvisualizer_solrjdbc_12

Name the Connection

dbvisualizer_solrjdbc_13

Select the Solr Driver

dbvisualizer_solrjdbc_14

Specify the Solr JDBC URL

dbvisualizer_solrjdbc_15

Open and Connect the Connection

dbvisualizer_solrjdbc_16

dbvisualizer_solrjdbc_17 dbvisualizer_solrjdbc_18

Use the SQL Commander to enter queries

dbvisualizer_solrjdbc_19 dbvisualizer_solrjdbc_20

What is next?

My next post will highlight how to connect SQuirrel SQL to Solr using the JDBC driver. The official Solr documentation Apache Solr Reference Guide will be updated to include more detail about connection parameters and some information about specific clients. If you have any questions about the Solr JDBC driver or want to help contribute, the Solr website has a section on Community and how to use the solr-user mailing list.

The next post in my series, Apache Solr JDBC – SQuirrel SQL, is now posted.

And as I’ve stated in my prior posts, myself and my team at Avalon are available to provide expert help with Apache Solr, search on Hadoop (primarily Hortonworks or Cloudera), or general big data projects. If you’ve got an initiative that could use some expertise to guide you down the right path, you can reach us at info <at> avalonconsult.com.  You can also follow our LinkedIn page or sign up to our mail list to be alerted to future installments of my blog series on Apache Solr and the JDBC driver.

Kevin Risden About Kevin Risden

Kevin Risden, an Apache Lucene/Solr committer, has been consulting on search and Hadoop for over 3 years at Avalon Consulting, LLC. He has helped organizations successfully transform their big data into business results.

Leave a Comment

*