2.6 iSQL-Viewer

Another open-source graphical user interface is the iSQL-Viewer. It runs on any Java-enabled platform.

Once installed and started you have the option define a service (or let the system find one itself). [Ignore the auto detect of services option]

The Tools->Service Manager choice brings up a form to provide the detail for the MonetDB connections. Click the third button in tool bar and select 'Local Service' to define a service Immediately select the tab named 'Resource' and add the location of the MonetDB JDBC driver, installed by default in or C:\Program Files\CWI\MonetDB\share\MonetDB\lib\monetdb-1.4-jdbc.jar under Windows and and in /usr/share/MonetDB/lib/monetdb-1.4-jdbc.jar under Linux and OSX

Go back to tab 'General' and enter the following items:

Connection Name	MonetDB SQL
JDBC Driver	nl.cwi.monetdb.jdbc.MonetDriver
JDBC URL	jdbc:monetdb://localhost/database
User name	monetdb
Password	monetdb

Warning, disable the authentication prompt if you can not edit the user and password fields.

In the Tools->Service Manager->Resource panel enter the location of the MonetDB JDBC driver C:\Program Files\CWI\MonetDB\share\MonetDB\lib\monetdb-1.4-jdbc.jar

Documentation and tutorial on iSQL-Viewer are available on their website.