I'm trying to do some research into integrating Moodle with a proprietary database management system. Namely a New Zealand product Cobek aPlus+, which is an assessment management system. I'm just seeing whether it's feasible to integrate the Gradebook function with aPlus+. Where trying to see if it's possible to connect and allow interoperability in either system.
Are there any success stories out there that involved Moodle integration and another DBMS? Open source or proprietary? Especially in terms of what I'm looking at? Anything good is appreciated.
My tiny little 2c worth. I asked the other day about integrating one Moodle I work with with APlus+ (which is I understand a utility to connect at the assignment level with Artena to create qualification level reports) Tutors were descibing a convoluted process using manual data entry. The answer was No. I cannot decide (yet) if this is "no we can't be bothered" "It's to hard" or "we have tried and failed".
Moodle Gradebook can of course export, and the key is the ID numbers. If an input function can be written at the APlus+ end then fine. Or, is there an input spec for APlus+ and then write the export from Moodle to speak to APlus+.
I believe you can do anything you like with Moodle in terms of what you are asking. You can code a report in a given format (etc). Then something else sucks it in. ???
Years ago I PM'd an integration with Salesforce. It worked. I've also been involved with Banner, Peoplesoft (now Oracle Campus), SugarCRM, Google Apps, etc. integrations. If Cobek is proprietary, and if you don't have access to the underlying tables of the rdms it sits on top of, then you would need Cobek to provide an API and/or webservices interface.
Moodle's webservices can do much of an integration if the other system supports that (that is how Salesforce integrations were/should be done). A problem with generic webservices is mapping the data from one system to the other.
IMS-LIS has been an emerging standard for mapping data between educastional systems for many years now - lately adopted by Banner and Oracle, it makes integrations easier - if both systems support it.