Hamburger Hamburger Hamburger

Hainbuch Workholding Technology

Hainbuch Improves Operations and KPI Management

Hainbuch Workholding Technology






Needed a BI solution to holistically Analyzing All Data For Entire Organization.



Pentaho Data Integration and Pentaho Business Analytics Provides a Seamless ETL and Analytics Platform.


  • Improved Access to Information About KPI's
  • Data is updated and loaded regularly
  • Management and Sales Have Better Analytics and Reporting
  • Ad-hoc analytics as needs

Hainbuch Needs to Enhance Analytics and Improve Operations.

The Challenge: Hainbuch Needed Centralized BI Solution

Hainbuch Workholding Technology needed a central BI solution for their operations department. They needed faster and more efficient reporting and analysis. They desired to automate their data loading process.

Additionally, they needed to be able to easily access the company's key performance indicators (KPI's). The team desired to find an analytics tool that could connect to their existing ERP solution and their other IT applications was essential.

Connecting to our ERP and IT Systems is a big plus, allowing us to efficiently manage KPIs.

– Benjamin Weller, Controller, Hainbuch Workholding Technology

The Solution: Pentaho Data Integration, Pentaho Business Analytics

Hainbuch runs Pentaho Business Analytics with the Centos 6 Linus distribution. They use VMWare 5.5 virtual services and a MySQL database. Initially, they tested the Community edition of Pentaho. Eventually they migrated to the Enterprise Edition for its greater functionality and ease of use. Lastly, Pentaho's Consulting Services ensured an efficient, high-quality implementation, and they provided training services.

The German machine tools manufacturer chose Hitachi Vantara's Pentaho platform for various reasons. Pentaho's fast and easy to use reporting and analysis was a key benefit. They appreciated that Pentaho automated their ETL (extract, transform, load) process. Furthermore, Hainbuch picked Hitachi Vantara’s big data integration and analytics solution because of its broad connectivity with other tools.

The Outcome: Upgraded Analytics and Reporting Results in Better Insights

Hainbuch is now able to consolidate insight and knowledge about KPI's, such as revenue by product groups or country, cost base or product groups and on-time delivery. Their operations department works with Pentaho on a data basis. Their data is updated and loaded overnight using a standardized process. Three members of the team work on analysis and reporting on a weekly and monthly basis. They are able to provide insights to management and sales. The team can now provide ad-hoc analysis when needed. Hitachi Vantara's big data integration and analytics solution's consulting services team are actively training team members for future projects with Pentaho Dashboards.

Explore More

{ "FirstName": "First Name", "LastName": "Last Name", "Email": "Business Email", "Title": "Job Title", "Company": "Company Name", "Address": "Address", "City": "City", "State":"State", "Country":"Country", "Phone": "Business Telephone", "LeadCommentsExtended": "Additional Information(optional)", "LblCustomField1": "What solution area are you wanting to discuss?", "ApplicationModern": "Application Modernization", "InfrastructureModern": "Infrastructure Modernization", "Other": "Other", "DataModern": "Data Modernization", "GlobalOption": "If you select 'Yes' below, you consent to receive commercial communications by email in relation to Hitachi Vantara's products and services.", "GlobalOptionYes": "Yes", "GlobalOptionNo": "No", "Submit": "Submit", "EmailError": "Must be valid email.", "RequiredFieldError": "This field is required." }