Product: CHADDB -- The Church Administration Database
By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
Category: Church management database
Developer/vendor: Oakdale Christian Fellowship, Charlotte, N.C.
Availability: Java front-end was released in March, 2005. The back-end for use with OpenOffice.org has been available for months.
Purpose: Designed for churches of all sizes, this database could be used by some non-profits as well. Its focus is on managing relationships among members and auxiliaries.
Resources: Screenshots of the test data on OpenOffice.org's Website
Assuming you have OpenOffice.org, MySQL, and JDBC already set up correctly, you can use the menu Tools --> Data Sources to open the data sources dialogue box to configure the MySQL connection.
- Run SQL scripts to create an setup CHADDB in MySQL. We recommend creating a database called chaddb_test for testing purposes, and use the test data included with the download. (All test data offered in this example is fictional.)
- Complete the General Tab by entering a name for the connection in the Name box; selecting JDBC as the database type; and entering the following:
- Complete JDBC tab, making sure that the driver class is com.mysql.jdbc.Driver. The URL should be set to:
Then, set your MySQL user name, and check the Password required box. You should use "auto_increment" in the Auto-Increment box.
- Check the Tables tab. You just need to make sure all tables have a check mark next to them.
- Use the Queries tab to create any queries you want. You can create a simple address book query using the "person" and "address" tables, joining them on the "psn_id" field.
- Open a document in OpenOffice.org, and use F4 to view the data sources.
Select the tables or queries you want. To do this, just drag a column header into your Writer document at the insertion point to create a form letter using an address book query.
Don Parris is an ordained minister and an advanced, mostly self-taught user of Windows and Linux. He is the author of "Penguin in the pew" and this tip on migrating a non-profit organization to Linux.