I've been tasked with leveraging a realtime API to develop an operational dashboard (who's online, AHT, etc..). The API returns a JSON response to parameters identified in a URL via a GET request. I'll figure out the rest as I go along. To clarify: I'm not a developer but program a lot of VBA and have managed to come up with some pretty cool solutions over the years by researching/programming as I go along. I know they're cool because real programmers tell me so.
Anyway - I'm curious if anybody has any opinion on the best approach? I can think of 2 but there may be something better.
1) Use Pentaho spoon to write (replace) the JSON results to a table(s) in my MySQL database every few seconds. Then, point Microstrategy to the MySQL DB.
2) Develop something with vb.net which would probably be a bit more involved.
Any other suggestions?