"What do you think of creating my own system and communicate with the Moodle web service API to get the data I need from Moodle."
I would generally caution anyone building something from scratch unless there is no clear alternative and software development is your main line of work. But if you do decide to do that, please post questions and progress here.