The document tracking feature is configured as part of FES to track SBW events into H2 database running within Enterprise Server. This database can be changed for a profile in Profile Manager and database details are saved in the sbwdb.cfg file present in FIORANO_INSTALL_DIR\esb\server\profiles\<profilename>\FES\conf. To view or configure the database:
Load the profile and right-click the node and select the Open SBW Config option. A dialog box is displayed with all the database properties along with their default values.
In the Configure SBW Database dialog box, select the required database from the drop-down menu in 'Database Name' property which loads specific values for all the properties applicable for that database. Modify these values and click OK to save the configured database.
Configuration of database can be done simultaneously for more than one profile node. For doing this, select both the nodes by using CTRL or SHIFT button, right-click and select Open SBW Config menu option; configuration properties for the selected profiles appear on the dialog box. Make necessary changes and click OK to save the database details of the profile nodes.
For file-based databases like apache and HSQL, the default location is in the ESB_USER_DIR (which is set in fiorano_vars script). The user has to give the complete path with these variables resolved when using the JDBC URL in a third party tool.