Note: This document applies to Denodo 6.0. For newer Denodo versions this configuration is performed from the web tool. Please read the document Use an External Database for the Data Catalog
This document explains how to configure the Information Self-Service Tool to store its settings on an external database.
By default, the Information Self-Service Tool stores certain settings for each user in a local database for example, “My Queries”, fields selected to display on a view, etc.
If Denodo is installed on a cluster environment and there is a Information Self-Service Tool installed on each node of the cluster, it is possible to configure all the Information Self-Service Tool servers to store and retrieve these settings from a common database. Otherwise, users will use different settings depending on the node the load balancer redirects them.
This section explains how to install the common database in which all the Information Self-Service Tool servers will store its settings.
The following steps assume that the file has been decompressed in these directories.
derby.drda.host=<IP address of the host>
The common database is ready.
This section explains how to configure the Information Self-Service Tool to use the common database. This process involves stopping the Denodo web container. I.e. all the SOAP and REST web services and web administration tools will be stopped for a few seconds.
Follow these steps for each node of the cluster.
jdbc:derby://<IP address>:<Port Number>/self-service-database
<IP address> is the IP of the node where Apache Derby is installed as seen in the previous section.
<Port Number> is the port number set in the previous section, by default 10000.
Note: there are two occurrences of this string. In the second one, make sure to leave the suffix “;create=true” after the modified URL. For example,
In the first line of the result, the message “Web Container: stopped” should appear. If that is not the case and the web container is still started, wait for some time until the web container is stopped.
This will start all the Denodo SOAP and REST web services.