Protection of Internal Databases

Jedox Integrator uses H2 file-based databases to store the following information:

• Monitoring data (Execution History, Logs, Drillthrough Metadata) in <Install>\\tomcat\webapps\etlserver\data\db\etl_history.
• Internal Drillthrough Data in <Install>\\tomcat\webapps\etlserver\data\db\etl_drillthrough.

By default, these databases are not password protected. To assign passwords to these databases, the following steps are necessary:

1. Stop JedoxSuiteTomcatService.
2. Remove the directories for the databases mentioned above. Caution: these changes should be done directly after the installation, as all monitoring/drillthrough data will be lost in this process.
3. Edit the file <Install>\tomcat\webapps\etlserver\config\connections.xml as follows:
   • For Monitoring data, edit the connection with name="History"
   • For Internal Drillthrough data, edit the connection with name="Drillthrough"
   • Assign a password in the tag <password></password>
4. Start JedoxSuiteTomcatService

Related link: Encryption of Database Files

Updated June 5, 2023