Links

SQuirreL SQL

You can use SQuirreL SQL to interface with OmniSciDB.
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 OmniSci JDBC driver in $OMNISCI_PATH/bin/omniscijdbc-<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 OmniSci JDBC Driver

Configure the OmniSci 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 OmniSci, the required components are “jdbc”, “omnisci”, a valid DNS name for a machine running OmniSci, the OmniSci port number, and the name of the OmniSci database. For example, jdbc:omnisci: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.omnisci.jdbc.OmniSciDriver.
  8. 8.
    Click the Extra Class Path tab.
  9. 9.
    Click Add and navigate to the directory where omniscijdbc-<major_version>.<minor_version>.<revision>.jar
    is located.
  10. 10.
    Click Open.
  11. 11.
    Click OK.

Configure the OmniSci Alias

  1. 1.
    Click Aliases.
  2. 2.
    Click + to add a new Alias.
  3. 3.
    Give the Alias a Name.
  4. 4.
    Choose OmniSci as the Driver.
  5. 5.
    Update the example URL with the specific URL for your OmniSci 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.