We are developing a SaaS product with which we want to give our customers the ability to produce “real time” (i.e. users should be able to get response within seconds) reports. The “raw” (i.e. not specifically materialized for reporting) data is in MongoDB and our front-end clients may be native mobile and Web. The question is how do we achieve the functionality in between these components which is to embed in our applications a visual report generated from the MongoDB data. As we see it, there are two options in general:
- Take care ourselves for all the stack by “in-house” development and using libraries for specific layers (e.g. UI generation, data consumption, etc…)
- Utilize OEM embeddable reporting services which can be given by third parties such as specified here. As a side note, we think that the term “analytics” is an overshot for what we want, that’s why I use the term “Reports” here. Nevertheless, all products use the term “analytics”
We need help with choosing between the approaches. More specifically:
- How common is the 2nd option? Especially with Document DBs such as MongoDB?
- What is the criteria which can help with making a decision here? IOW, what are the conditions in which option (1) can be considered as preferred over (2) and vice-versa?