Challenge: Enhance the company’s platform with a user-friendly ETL and analytics tools to manage plastic-compounding systems.
Solution: Pentaho Data Integration and Pentaho Business Analytics automate data processing and improve access to data.
Made the ETL process easy to manage.
Can be used a stand-alone tool or embedded into the platform.
Supports a broad range of data sources.
Optimizes costs and profitability.
Kirchhoff Datensysteme Software uses Hitachi Vantara software to enhance their knowledge of the plastics industry.
The Challenge: Find an ETL and Analytics Tool That Can Process Data
Kirchhoff Datensysteme Software (KDS) is a software development company focused on industry-specific solutions. As plastic compounding is highly complex and specialized, profit margins depend on how efficient this process is managed, as well as on the volatile prices of energy and raw materials.
The company needed software that was flexible enough to support its industry-specific reporting and analysis tool, Poly.MIS. KDS needed a flexible platform that would allow it to define analysis scenarios, dashboards and reporting options specific to compounding.
Due to the nature of the business, the organization required an analytics tool that could handle a variety of data types. KDS sought an analytics platform that could load and process data from various specialized IT systems relevant to plastic compounding.
Additionally, the solution needed to be easy for people across the business to use without IT support. KDS wanted to offer Poly.MIS as a stand-alone analytics tool and to also embed it into their ERP system, Poly.ERP.
Pentaho’s user-friendly interface made it easy to lower costs and maximizing profits.
— Oliver McKenzie, Managing Director, Kirchhoff Datensysteme Software
The Solution: Pentaho Business Analytics, Pentaho Data Integration
KDS created an OEM partnership with Hitachi Vantara and purchased Hitachi Vantara’s Pentaho Data Integration solution to load and process data from the various plastic compounder systems. Some of these systems include ERP, energy management, production planning, and quality management. Pentaho Business Analytics now serves as the reporting and analytics tool. KDS uses Hitachi Vantara’s Pentaho solution as the basis for their industry-specific reporting and analysis.
The Outcome: Industry Understanding Optimized Through Data
The KDS OEM partnership with Hitachi Vantara enabled the company to optimize their knowledge and skills related to the plastic-compounding industry by taking advantage of Hitachi Vantara software and specialized knowledge of data integration and business analytics. Pentaho reporting and analysis tools enabled Poly.MIS to deliver preconfigured, standard reports and analysis scenarios for plastic compounding. Gross profit and contribution margin analyses now take raw material and energy volatility into account and help KDS to optimize costs and profitability.
Sales process analyses that blend sales data with product and composition data help compounders determine material requirements and work more efficiently. Support for other industry-specific scenarios includes container-oriented inventory and current stock value analysis, receivables and open-orders analysis, energy management analysis, and many others.
The visual interface of Hitachi Vantara’s Pentaho Data Integration has made the whole ETL process easy to manage. Its open architecture means that data from a wide range of proprietary sources can be effortlessly integrated. Poly.MIS users can easily run a range of specialized reports on topics including gross profit analysis, production time/idle time and inventory, without IT support. Poly.MIS is now available as a standalone tool or as an embedded part of Poly.ERP.