Steps

1. Download and install the latest 64-bit DBVisualizer from the download section of http://www.dbvis.com/.

   • For Windows it is recommended to download the DBVisualizer 64-bit with embedded JRE. This way it is guaranteed that the firebird driver is always started with 64-bit java.
   • Install DBVisualizer in a directory that does not contain any spaces.
2. Extract dbvis_addons.zip into the DBVisualizer installation directory (e.g. jdbc subfolder and dlls are copied into the DBVisualizer installation directory).
3. Start  DBVisualizer (e.g. ignore / close the DriverManager).
4. Import dbvis_settings.jar using File->Import settings. Restart when DBVisualizer prompts to restart.
5. In the list of connections, right-Click on a suitable connection example and duplicate it.
6. Edit the new connection and put in the correct connection details.

Example urls for each local datastore database

Derby

jdbc:derby:d:\fews\OC\localDataStore\local.derby

Firebird

jdbc:firebirdsql:embedded:d:\fews\local.fdb?lc_ctype=UTF-8

Hsqldb

jdbc:hsqldb:file:d:\fews\local.hsqldb\hsqldb