Configuring a SQuirreL SQL Client for MapD Core

SQuirreL SQL Client is a graphical Java program that lets you perform common tasks such as viewing the structure of a JDBC-compliant database, browsing data in tables, and issuing SQL commands. For more information on SQuirreL SQL, see http://squirrel-sql.sourceforge.net.

This topic describes how to install and configure SQuirreL SQL for use with MapD Core.

Prerequisites

Download the MapD JDBC Driver

You can find the MapD JDBC Driver in the MapD distribution: for example, in $MAPD_PATH/bin/mapd-1.0-SNAPSHOT-jar-with-dependencies.jar. Alternatively, you can download the latest JDBC driver from https://s3-us-west-2.amazonaws.com/mapd-artifact/mapd-1.0-SNAPSHOT-jar-with-dependencies.jar.

Verify that Java is Installed on Your Client Machine

To verify the Java version installed on your machine:

  • On Windows, look in Control Panel > Programs > Programs and Features.
  • On OSX, open System Preferences > Java and click About....

Download SQuirreL SQL

Download the version of SQuirreL SQL for your platform from http://squirrel-sql.sourceforge.net.

Follow the instructions on the website to install SQuirreL SQL.

Configure SQuirreL SQL for the MapD JDBC Driver

These are the steps to configure SQuirreL for use with MapD Core.

Configure the MapD Driver

  1. Open SQuirrel SQL.
  2. Click Drivers.
  3. Click + to add a new driver.
  4. Enter the Name for your driver. The name is an alias within SQuirreL for this driver.
  5. Enter the Example URL. For MapD, the required components are “jdbc”, “mapd”, a valid DNS name for a machine running MapD, the MapD port number, and the name of the MapD database. For example, jdbc:mapd:machine:9091:dbname. If you are not sure of these values, contact your system administrator.
  6. Click the Extra Class Path tab.
  7. Click Add and navigate to the directory where mapd-1.0-SNAPSHOT-jar-with-dependencies.jar is stored.
  8. Click Open.
  9. Click OK.

Configure the MapD Alias

  1. Click Aliases.
  2. Click + to add a new Alias.
  3. Give the Alias a Name.
  4. Choose MapD as the Driver.
  5. Update the example URL with the specific URL for your MapD instance.
  6. Enter your User Name and Password.
  7. Optionally set Auto Logon.
  8. Optionally set Connect at Startup.
  9. Click Test to verify the connection.
  10. Click OK.