Amazing ETL and front end application

What are the best aspects of this product?

I appreciate that Pentaho’s ETL tool is more stable compared to SSIS which is brittle and does not stand changes to source files and others. Pentaho is much better because when something changes, I can easily edit the ETL and re-start my work immediately.

What aspects are problematic or could work better?

I find the built-in report building feature for pre-formatted reports to be old-fashioned. In this case, SSRS offers a superior tool. But Pentaho’s analysis reports are top notch. This tool is more suitable for ad-hoc reporting than to create uniform pre-formatted reports.

What specific problems in your company were solved by this product?

We use Pentaho to create health metrics to report particular numbers to the Federal government and to enhance our business process. We use billing data from Medicaid and other insurance firms as well as data from our Electronic Medical Record system to track the health and trends of our patients.

Are you a current user of this product?

Yes