Accessing the HoudiniESQ database outside of Houdini can cause data loss. If you access the database using SQL we will no longer provide support of any kind. This information is provided for those who would like to work with a copy of their data that will not be used in a production environment or accessed by Houdini directly. All data access by Houdini is logged in several files as a record of what has ben performed by Houdini. Data that exist without these records are considered orphans and not part of the HoudiniESQ data collection.
Make a copy of your Houdini database folder located at HoudiniESQ/webapps/houdini/esb/config/dbms
Create a new connection using the connection wizard and select Derby/Java DB embedded driver
You will be asked for the location of the database, provide it include the entire path
Supply the database user name and password (your user account and login password)
That is it, you should be able to execute SQL queries against the database e.g.
The tables are named as expected. Matter, Contact, Event etc.
SELECT * FROM esq.matter
The HoudiniESQ database is normalized. Phone numbers, Addresses and Email are not stored with the parent record but
are stored in their own tables.
We have a YouTube video available but you must make a request to view it via support at Houdini ESQ dot com
You can also use the
DBVisualizer tool to export your data to XML, CSV and SQL. Simply, select a table and right click then select export.