March 2018 Update

I originally posted this content to LinkedIn here, here, and here in April-May 2016. Cross posting to my blog with edits on the ~2 year anniversary of the announcement of me becoming an Apache Lucene/Solr committer. This post combines the three original posts since the content has been migrated to the Apache Solr Reference Guide.

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 that you can connect DbVisualizer, SQuirreL SQL, and Apache Zeppelin to Apache Solr using the Solr JDBC driver.

DbVisualizer

DbVisualizer is a Java based database query and management tool. The step by step guide 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 corresponds to the Apache Solr JIRA SOLR-8521 and Apache Solr Reference Guide page on DbVisualizer.

SQuirreL SQL

SQuirreL SQL is a Java-based database query and management tool. The step by step guide contains screenshots showing how to add the Solr JDBC driver, add an alias for Solr, connect to Solr, and then perform some SQL queries over Solr. This corresponds to the Apache Solr JIRA SOLR-8825 and Apache Solr Reference Guide page on SQuirreL SQL.

Apache Zeppelin

Apache Zeppelin is a web-based notebook that enables interactive data analytics. The step by step guide contains screenshots showing how to add the Apache Solr JDBC driver as an interpreter, use the interpreter in a notebook, and then perform some queries with the notebook. This corresponds to the Apache Solr JIRA SOLR-8824 and Apache Solr Reference Guide page on Apache Zeppelin.