Access Incorta 4.x Derby DB From Remote Client

If you have a need to connect to Incorta’s Derby DB from a remote client (DBVisualizer running on your laptop,  for example), this can be achieved using the following steps:

1) Make sure port 1527 is open on the Incorta server's firewall
2) Add the following line to your IncortaNode/startDerby.sh

export DERBY_OPTS=-Dderby.drda.host=0.0.0.0

3) Bounce the Derby process (IncortaNode/stopDerby.sh then IncortaNode/startDerby.sh) and connect from the SQL Client of your choice: