I would like to create a debate on the above topic.
The scenario at hand is that you have an electronic database (maybe Electronic Medical Record System, such as OpenMRS). Your users want online, real-time reports available to them. What possibilities do you have at hand?
I am not providing any answers right now, but with a vast number of options available, the debate can easily begin now.
Just to hint, a commercial reporting solution which I use is SQL Server Reporting Services (SSRS); the opensource counterparts that I use are JasperReports (with iReport designer) and Business Intelligence and Reporting Tool (BIRT).
Please have your say ...
I use SQL Yog, although up to now i have failed to configure its SMTP settings. But I believe it would work well with MYSQL.
ReplyDeleteI haven't used SQLYog, but my understanding is that SQLYog is a MySQL manager and admin tool - not a reporting tool. The equivalents of SQLYog would be MySQL Browser, MySQL Workbench, SQL Server Management Studio, Phpmyadmin, Oracle Management something (don't quite remember the actual name).
ReplyDeleteThere is also Toad (I think there are several versions for different database management systems).