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.
- 1.Download the OmniSci JDBC driver in
$OMNISCI_PATH/bin/omniscijdbc-<major_version>.<minor_version>.<revision>.jar
. - 2.Verify that Java is installed on your client:
- 1.On Windows, go to Control Panel > Programs > Programs and Features.
-or-- 1.On OSX, go to System Preferences > Java and click About....
- 3.
- 4.
- 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 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.Enter the Website URL.
- 7.Enter the Class Name:
com.omnisci.jdbc.OmniSciDriver
. - 8.Click the Extra Class Path tab.
- 9.Click Add and navigate to the directory where
omniscijdbc-<major_version>.<minor_version>.<revision>.jar
is located. - 10.Click Open.
- 11.Click OK.
- 1.Click Aliases.
- 2.Click + to add a new Alias.
- 3.Give the Alias a Name.
- 4.Choose OmniSci as the Driver.
- 5.Update the example URL with the specific URL for your OmniSci instance.
- 6.Enter your User Name and Password.
- 7.(Optional) Set Auto Logon.
- 8.(Optional) Set Connect at Startup.
- 9.Click Test to verify the connection.
- 10.Click OK.
Last modified 1yr ago