I am looking to integrate some dynamically generated BI reports into a web app. The requirements are:
Able to view report based on JSON RPC XML, or some similar streaming data source (therefore, not requiring direct access to the DB). Why? Because many users have access to different copies of similar data. I.e. 3 companies, 5 projects. None of the 3 companies should have access to the other companies' data.
Be able to build reports and have the same report be usable by each of the different companies mentioned in #1 above. However, depending on the company, the user of the report will get data served from the server via XML RPC specific to that company.
Has to be open-source. I can't afford to pay per-user licenses at this stage.
Based on my own searching, I find Jasper seems to match these requirements best. Am I wrong? Is there a better one? I have looked at: MicroStrategy, Spago, Pentaho, RapidI, and Openl.
Anyone have any experience with this?