Databases for small organizations?

New here?

If you'd like to participate, join us.
If you're already a member, log in.
Search for a specific post?
Subscribe to RSS

New Post

Details

Rate This

40 Replies
1 Subscriber
Postedover 6 years ago

Posted by wcook

on 7 Jun 2007 5:40 PM

If you work at a small nonprofit, what type of database do you use? How did you choose it, and how do you maintain it?

senior editor, TechSoup

Posted by bobalston

on 7 Jun 2007 6:17 PM

I guess such a wide open, non specific question is to get a lot of discussion on the board. If that happens, it will certainly be a very wide discussion.

Are such TechSoup prompted discussions that have a "wide open" topic such as this useful to the members?

Bob

Free case management software for food pantries/emergency services 501(c)(3) organizations. See: http://webpages.charter.net/bobalston/bob1.htm

Posted by ChiefApricot

on 8 Jun 2007 7:06 AM

I think for a better discussion we should elaborate the question - are we talking about choosing a database software (Access, MS SQL, MySQL etc.) or software to handle a database with specific kind of data (contacts database, donations database, members database) - or all of the above?

Dmitry Buterin, Twitter.com/ChiefApricot

Wild Apricot: Web software for associations and non-profits

Posted by akrasne

on 8 Jun 2007 3:18 PM

To clarify, the discussion for this topic should be framed by this article, which discusses databases for tracking constituents.

Does that help?

------------------------
Managing Editor
TechSoup

Posted by ChiefApricot

on 11 Jun 2007 6:00 AM

Thanks for the link, now it makes good sense.
In this case I would like to mention several web-based databases relevant to this:
DabbleDB - great generic online database tool
Wild Apricot - Memeber/contact database (I work there)
Neat Clubs - Member database

Dmitry Buterin, Twitter.com/ChiefApricot

Wild Apricot: Web software for associations and non-profits

Posted by DaveDS

on 13 Jun 2007 1:09 PM

The right database can transform a small and medium sized nonprofit. In the last 3 years I've had to "turn around" two nonprofits...one small (4 staff) and the other medium (40 staff). Both were in critical need of reliable data management. Multiple uncoordinated Xcel spreadsheets were the stones jamming each organization's gears. In both cases we hired CiviCore (www.civicore.com) to analyze and create new web-based solutions. Cost effective, fast, adaptable, and not too confusing. In fact our city's collaborative of mentoring agencies has now adopted this system. Bottomline...as a nonprofit leader I can now trust my information. I can now manage our product and services. Our program data now coorindates with our fund development data. Not only is our credibility is no longer in question, but our quality of service/product is greatly increased (as well as our reputation).

Dave DeForest-Stalls, Pres/CEO
Big Brothers Big Sisters of Colorado

Posted by wildernesscenter

on 13 Jun 2007 1:37 PM

I am looking for new software, but would prefer NOT to use web based software due to the unreliability of our internet connection. We are in the situation of having multiple (around 10) locations where data on donors could be stored. I just viewed a demo for Sage 50, but that is probably too expensive for my organization. We could use a lot of the functionality it offered, though. I also downloaded a demo for Exceed, but since a demo has very limited functionality, I couldn't get a good feel for it. Any suggestions?

Posted by daniel.heath

on 14 Jun 2007 1:41 AM

ChiefApricot--Good to know about those sites; I periodically run into organizations that could use them.

DaveDS--You're absolutely right that the right database can be transformative for an organization (just like the wrong one can waste vast amounts of money and crush morale). And I agree that for a lot of organizations with unique data needs (which is most service organizations), something custom is often the best way to go (and not as expensive as you'd think if you get someone good). That said, no one should re-invent the wheel if their needs are covered by a commercial product (e.g., for a fundraising DB).

wildernesscenter - I think your best bet is to get a more reliable internet connection. You don't want to get into the business of manually synching all those sites. It's a recipe for disaster. Besides, you want your email etc. working all the time anyway.

Daniel Heath Giant Rabbit, LLC http://www.giantrabbit.com

Posted by tclaremont

on 14 Jun 2007 9:23 AM

I think the prospect of fixing your internet connection and then going with a web based approach is going to be more rewarding and beneficial for the organization than investing in an alternate solution.

Tim Claremont
Systems Administrator
Rochester, NY

Posted by lcutcliff

on 15 Jun 2007 12:45 PM

We are pleased with Giftworks. And were are small. 4 employees, I don't know how many constituents we have, I think under 3,000. I have had experience with Raisers Edge and I prefer Gift works

Posted by twilliams123

on 18 Jun 2007 4:00 PM

For three years, we have also used CiviCore (www.civicore.com) to track and manage our donors and stakeholders. Our organization has grown exponentially since then, and CiviCore has kept up the pace beautifully. Reports are easy to produce, export, and manipulate. Data is consistently reliable. Staff is responsive, helpful, and knowledgeable about the product. This database is very cost-effective for a budget-minded organization, and the product is a custom-built application to suit your organization's specific needs. No maintenance required other than adding and modifying entries. We've been very happy with CiviCore and would definitely recommend them.

Chris Myers, Founder & CEO
OpenWorld Learning

Posted by matthewart

on 18 Jun 2007 7:18 PM

We use two different databases for different purposes.

We use several in-house instances of Access. I use one access database (that is fed from a MySQL database online) as a local copy of grant records to track when they were paid and what activities the grantees engaged in.

We use MySQL for online grants management, in several Drupal site, for ArtistsRegister.com, for Artjob.org, Zapplication.org, and Cafe.org.

Personally I prefer the online databases to the local database, but that really has to do with my favouring open source.

If you are looking for a free opensource database to use locally, check out OpenOffice's (www.openoffice.org) offering, "Base".

Best,
Matthew.

http://www.dogstar.org
NonProfit Technology Consulting

Posted by soultenders

on 19 Jun 2007 6:07 PM

I have been satisfied with Filemaker Pro, but am thinking of changing to Access to take advantage of MS Sharepoint. I am leary of putting our member information on a Web database due to security issues. What is your experience with Sharepoint as a way to share the database and have an internal wiki-like shared document creation for multiple locations?

Posted by CALM

on 19 Jun 2007 6:10 PM

Does anyone else worry about the safety of online databases? Here's what I mean: information is a tool which can be used for good or evil. I remember reading that the Dutch kept beautiful, orderly geneology records; when the invaded, they profited from all this hard work by very quickly and efficiently locating Jews and shipping them out to concentration camps. In this new era of terrorism and an unfriendly internet, if we keep our organization's databases online, would we even know if hackers, criminals, or anyone else were tapping into them?
This is the main reason I'm leaning away from some of the excellent web-based products . . . .
Thoughts on this?

Posted by ackidge

on 20 Jun 2007 5:09 AM

I work for a medium non profit (25 full time employees) and have been in charge of the search for a new databaseover the past year. We currently use Filemaker Pro 6, which I love because of it's flexibility. But others would like something more standardized and consistant. One major paramiter that was placed was that this database had to be one that was in house & not web based. We have narrowed our choices down to either Raisers Edge or Sage100. The promises of Raisers Edge are calling to some people, but the practicality and ease of use has me pushing for Sage 100.
What are other peoples opinions comapring these 2 databases?

On the Web:

Account options

Search section

Databases for small organizations?

New here?

Databases for small organizations?