Search…
v6.1.1 (latest)
Welcome to HEAVY.AI Documentation
Overview
Overview
Release Notes
Installation and Configuration
System Requirements
Installation
Services and Utilities
Configuration Parameters
Security
Distributed Configuration
Loading and Exporting Data
Supported Data Sources
Command Line
SQL
Data Definition (DDL)
Data Manipulation (DML)
Heavy Immerse
Introduction to Heavy Immerse
Admin Portal
Working with Dashboards
Measures and Dimensions
Using Parameters
Using Filters
Multilayer Charts
SQL Editor
Customization
Chart Types
Python / Data Science
Data Science Foundation
JupyterLab Installation and Configuration
Using HEAVY.AI with JupyterLab
Python User-Defined Functions (UDFs) with the Remote Backend Compiler (RBC)
Ibis
Interactive Data Exploration with Altair
Additional Examples
APIs and Interfaces
Overview
heavysql
Thrift
JDBC
ODBC
Vega
RJDBC
SQuirreL SQL
heavyai-connector
Tutorials and Demos
Loading Data
Using Heavy Immerse
Hello World
Creating a Kafka Streaming Application
Getting Started with Open Source
Try Vega
Troubleshooting and Special Topics
Vulkan Renderer
FAQ
Optimizing
Known Issues and Limitations
Logs and Monitoring
HeavyConnect
HeavyConnect Release Overview
Getting Started
Best Practices
Examples
Command Reference
Parquet Data Wrapper Reference
ODBC Data Wrapper Reference
Powered By GitBook
SQuirreL SQL
​
You can use SQuirreL SQL to interface with HeavyDB.
SQuirreL SQL client is a graphical Java program for performing common tasks such as viewing the structure of a JDBC-compliant database, browsing data in tables, and issuing SQL commands.
For more information about SQuirreL SQL, see http://squirrel-sql.sourceforge.net.

Installing SQuirreL SQL

  1. 1.
    Download the HEAVY.AIU JDBC driver in $HEAVYAI_PATH/bin/heavyaijdbc-<major_version>.<minor_version>.<revision>.jar.
  2. 2.
    Verify that Java is installed on your client:
    1. 1.
      On Windows, go to Control Panel > Programs > Programs and Features.
    -or-
    1. 1.
      On OSX, go to System Preferences > Java and click About....
  3. 3.
    Download the version of SQuirreL SQL for your platform from http://squirrel-sql.sourceforge.net.
  4. 4.
    Follow the instructions on the SQuirreL SQL website to install SQuirreL SQL.

Configuring SQuirreL SQL for the HEAVY.AI JDBC Driver

Configure the HEAVY.AI Driver

  1. 1.
    Open SQuirreL SQL.
  2. 2.
    Click Drivers.
  3. 3.
    Click + to add a new driver.
  4. 4.
    Enter the Name for your driver. The name is an alias within SQuirreL for this driver.
  5. 5.
    Enter the Example URL. For HEAVY.AI, the required components are “jdbc”, “omnisci”, a valid DNS name for a machine running HEAVY.AI, the HEAVY.AI port number, and the name of the HEAVY.AI database. For example, jdbc:heavyai:machine:9091:dbname. If you are not sure of these values, contact your system administrator.
  6. 6.
    Enter the Website URL.
  7. 7.
    Enter the Class Name: com.heavyai.jdbc.HeavyaiDriver.
  8. 8.
    Click the Extra Class Path tab.
  9. 9.
    Click Add and navigate to the directory where heavyaijdbc-<major_version>.<minor_version>.<revision>.jar
    is located.
  10. 10.
    Click Open.
  11. 11.
    Click OK.

Configure the HEAVY.AI Alias

  1. 1.
    Click Aliases.
  2. 2.
    Click + to add a new Alias.
  3. 3.
    Give the Alias a Name.
  4. 4.
    Choose HEAVY.AI as the Driver.
  5. 5.
    Update the example URL with the specific URL for your HEAVY.AI instance.
  6. 6.
    Enter your User Name and Password.
  7. 7.
    (Optional) Set Auto Logon.
  8. 8.
    (Optional) Set Connect at Startup.
  9. 9.
    Click Test to verify the connection.
  10. 10.
    Click OK.
APIs and Interfaces - Previous
RJDBC
Next - APIs and Interfaces
heavyai-connector
Last modified 4mo ago
Export as PDF
Copy link
Outline
Installing SQuirreL SQL
Configuring SQuirreL SQL for the HEAVY.AI JDBC Driver
Configure the HEAVY.AI Driver
Configure the HEAVY.AI Alias