Komatsu Australia offers its customers products, parts and services for a full range of earthmoving, mining, construction and utility equipment. As a fast-moving organization and early cloud adopter with multiple data sources, a system was required to receive instant access to data for real-time visibility into operations.
Earthmoving Vehicles, Digital Transformation
Komatsu was founded in 1921 and soon afterwards built its first crawler tractor. Since then, it has developed one of the widest ranges of earthmoving, mining, construction and utility equipment. Komatsu has a deeply integrated approach to research, development and design, with technology ingrained in every aspect of this process. From the innovative human/machine interactions built into the machines, to their range of self-driving autonomous haulage vehicles and even the collection of data from these machines, Komatsu has fully embraced digital transformation while ensuring that technology developed in one industry sector flows to other sectors.
Today, Komatsu Australia offers a full range of products, parts and a reliable service network to meet their customers’ needs. Products are directly marketed, serviced and supported throughout Australia, New Zealand and New Caledonia, while factory ownership and national coverage ensure the shortest possible lines of communication between manufacturing facilities and distribution outlets. This allows for faster response times to customer needs and more efficient handling of special requests.
As a fast-moving organization with a great need for information – to aid in planning, decision making and monitoring – and with multiple systems – including a new deployment of Microsoft Dynamics AX for operational data, KOMTRAX for telemetry data and LIMC for fluid sampling data forming part of the core data environment – visibility across all the systems needed to be improved.
Microsoft produced this video about Komatsu, Azure SQL Database Managed Instance and Timextender
Cloud Adoption for Data Management
With data from three business critical systems identified as a must-have, and the possibility of additional internal and external data sources being added, Komatsu needed an data infrastructure that could support future growth from both a source and complexity perspective. It was of course also desired that this solution would have the quickest time-to-value for the business. After an evaluation period, Timextender was chosen for its data management capabilities, ease of use, Microsoft-aligned cloud strategy and its Dynamics AX adapter.
Being an early cloud adopter, some of Komatsu’s key technical success factors for the project were to have the infrastructure and services supporting their data platform deployed to Microsoft Azure while catering for Development, User Acceptance Testing and Production environments with strong version control and governance. Timextender’s Azure Certification, ability to deploy through the Azure Marketplace, built-in environment migration, which moves changes from development to test to production, and the Team Development with versioning capabilities, helped to meet all the technical requirements.
The first phase of the project focused on data from the Dynamics AX environment. Using Timextender’s built-in Dynamics AX adapter to abstract some of the complexity in the ERP database, data was rapidly and securely sourced into Komatsu’s data warehouse. The adapter’s understanding of the AX data structure meant dashboards were available within weeks. Once the AX data was integrated, data from KOMTRAX and data from LIMC were integrated and modeled in Timextender, creating a contiguous view of related data from the systems while maintaining the unique data aspects of each.
This data infrastructure, built with Timextender, now supports Komatsu’s reporting and its plans for machine learning. Specifically, this means that core analytics can be achieved through Timextender’s Semantic Layer – with dashboards served up via Power BI – whilst providing a platform from which deep learning algorithms can be trained and fed using the same data asset that is continually updated and maintained.
Cost Savings and Instant Access to Data
Implementing Timextender has had many benefits, with one of the most important being that the setup could move between Azure services without a rebuild. This benefit was clearly illustrated when it was decided to move from Azure SQL DB in an Elastic Pool to Azure SQL DB Managed Instance, due to data size and granular environment management constraints.
Using Timextender’s native capabilities to deploy to any supported Azure Data Service, the UAT environment was successfully migrated to SQL DB MI in just 2 days, forming the successful test case based on which the full production environment was migrated. All of this was achieved in less than 2 weeks, while still complying with all required change control and governance procedures. As John Steele, Komatsu’s General Manager of Business Technology reported, “We were able to deploy our Timextender solution into production on Azure SQL Database Managed Instance in a matter of weeks. We immediately realized a 49% cost savings and a 25-30% performance improvement, and the promise of applying artificial intelligence through machine learning to our data is an exciting opportunity for us.”
While the ability to move to the most suitable Azure data service is a major technical benefit, the biggest business benefit lies in the fact that Timextender has empowered Komatsu’s decision makers and enabled instant access to data for real-time visibility into operations. This has improved access to Komatsu’s data and resulted in more informed decision making.
Timextender
