So I work for a non-profit org using A Raiser's Edge database-(Which holds our constituent and fundraising information)
At it's root it's a MSSQL 2000 database.
I'd like to be able to integrate a Drupal site and information from our Database. As a custom web solution that could be above and beyond.
I'd like to be able to use the API that we were gouged for (Yup you have to purchase it separately)-
Politically around here the database is not going away any time soon.
Blackbaud (makers of The Raiser's Edge and other expensive nonprofit software) is a Microsoft company--I'm getting depressed reading their documentation--
Info from the docs:
API follows the guidelines of Microsoft’s Component Object Model (COM). Therefore, you may use it from any COM-enabled programming environment, including Microsoft’s Visual Basic, Visual C++, and Visual Basic for Applications. We wrote most of the examples included in this help file using VBA.
So the API is out, Yes?
I could directly access the database--but that's a pretty ugly solution.
How about building a web service? Getting some XML Goodness going?
Anyone with experience along these lines out there?