Is there a generic open-source reporting system out there?
- by syntactico
I recently started a position at a new company, and one of the first projects they want is an internal reporting system that points at database A, B, C and reports various metrics/statistics/predictions. Basically, the same thing I've done or worked on and every company I've ever been hired by.
Since this gets a bit boring after a while, I was wondering if there already exists some sort of open-source package that accomplishes this goal. Ideally, it would
work with multiple databases out-of-box (PostgreSQL, MySQL, MSSQL, Oracle minimally),
determine relationships between tables (either automatically from their schemas, or allow you to manually set them up after pooling all the tables),
allow you to create reports based on a subset of tables, customizing what data you wanted to be displayed/calculated (I suppose this would be challenging since you've no idea what every audience wants, and would need to make this flexible)
I'm debating making something like this in my spare time if one does not already exist. Just curious.