Use Talend ETL to sync database using CDC records.

Postgresql benchmark - pgbench

pgbench

Jasperreport - the BI visualization tools

https://www.jaspersoft.com/ - enterprise edition
https://community.jaspersoft.com/ - community edition

Business Intelligence

https://www.g2crowd.com/compare/qlikview-vs-tableau-desktop
http://www.tableausoftware.com/products/desktop
http://www.qlik.com/
http://www.predictiveanalyticstoday.com/open-source-free-business-intelligence-solutions/
http://www.pentaho.com/determine-customer-value
https://www.g2crowd.com/categories/business-intelligence
https://www.jaspersoft.com/reporting-and-analytics-inside-your-application
http://www.slideshare.net/boyarski/the-5-levels-of-embedded-bi

Monitor linux process memory or cpu resource usage

Find the process: > ps -ef | grep java

>top -p pid

interactive commands:
"f" - add/drop columns
"c" - command details
"M" - sort by memory
...

Talend built jar review

The jar file executes but does have memory leak.

tools - webmin - manage linux web based

http://www.webmin.com/

Trial run on SpagoBI all-in-one server

• Not stable.
• Used > 1GB RAM
• Require lots of resources to run.
  

Tools: SAP Crystal Reports

SAP Crystal Reports

A robust production reporting tool, SAP Crystal Reports turns almost any data source into interactive, actionable information that can be accessed offline or online, from applications, portals and mobile devices.