How to connect to My Money Database
From MTHWiki
My Money is designed to work with SQL compatible relational databases, default database engine in My Money is Apache Derby, a modern database engine with a storied pedigree. My Money also could be configured to work with Microsoft SQL Server and we have had reports of successful integration with Oracle.
Sometimes it is necessary to be able to connect to the database from outside My Money, for example to visualize the table structure, design a complicated query for a report or take a data snapshot.
If you are using default database engine (Derby) it is very easy to connect using many 3rd party applications. We normally use a Toad, but our recent favorite is AquaFold AquaStudio, absolutely amazing tool available for both Windows and Mac.
For the purposes of this article we will assume that we are using AquaStudio, any recent version 6.4 or better can connect to My Money.
We suggest to download version without the installer, as it allows you to edit AquaStudios library paths, more on that later.
Once you have started the AquaStudio you will need to mount My Money database, or in AquaStudio lingo "Register a new Server"
Please select Generic-JDBC, you can give the server any name you want and if your database is protected by a password you will need to specify it
Here is how the setup window looks
The most important parameters are URL, driver and Driver location:
URL should be a full, valid path to My Money database in the following syntax, for example jdbc:derby:C:\Documents and Settings\mthadm\Desktop\testDb\moneyDB;create=false
Driver should be org.apache.derby.jdbc.EmbeddedDriver
Driver location should be full path to derby.jar, for example C:\Program Files\MTH\My Money\lib\derby.jar
Although unlikely, if you run into driver not found type of problems when connecting on some versions of AquaStudio you may need to copy derby.jar and derbyclient.jar from MyMoney lib directory into AquaStudio lib directory and add them into datastudio.cfg.
Once connected you can expand the My Money database and work with it as you would with any other SQL database.
My Money Database Model schematics is available, we will gradually add more details on why and how things are connected
