Consolidate data to one source with Azure SQL Managed Instance | Komatsu

14:10
 
Share
 

Manage episode 291580338 series 1320201
By Jeremy Chapman and Microsoft Mechanics. Discovered by Player FM and our community — copyright is owned by the publisher, not Player FM, and audio is streamed directly from their servers. Hit the Subscribe button to track updates in Player FM, or paste the feed URL into other podcast apps.

Modernize your existing data at scale, and solve for operational efficiency with Azure SQL Managed Instance. Azure SQL MI is an intelligent, scalable, cloud database service and fully managed SQL server.

Nipun Sharma, lead data architect, joins Jeremy Chapman to share how the Australian subsidiary of large equipment manufacturer, Komatsu, built a scalable and proactive sales and inventory management and customer servicing model on top of Azure SQL Managed Instance to consolidate their legacy data estate on-premises. See what they did to expand their operational visibility and time to insights, including self-service reporting through integration with Power BI.

► QUICK LINKS:

00:00 - Introduction

00:30 - Komatsu’s background

03:28 - Komatsu’s modernization path

04:12 - Consolidating data to one source

05:50 - Data migration and consolidation of 3 core systems

08:20 - Example reports

09:49 - Self-service reporting

11:17 - Built-in auto tuning

12:45 - What’s next for Komatsu?

13:45 - Wrap up

► Unfamiliar with Microsoft Mechanics? We are Microsoft’s official video series for IT. You can watch and share valuable content and demos of current and upcoming tech from the people who build it at #Microsoft.

Subscribe to our YouTube: https://www.youtube.com/c/MicrosoftMechanicsSeries?sub_confirmation=1

Join us on the Microsoft Tech Community: https://techcommunity.microsoft.com/t5/microsoft-mechanics-blog/bg-p/MicrosoftMechanicsBlog

Watch or listen via podcast here: https://microsoftmechanics.libsyn.com/website

► Keep getting this insider knowledge, join us on social:

Follow us on Twitter: https://twitter.com/MSFTMechanics

Follow us on LinkedIn: https://www.linkedin.com/company/microsoft-mechanics/

Follow us on Facebook: https://facebook.com/microsoftmechanics/

362 episodes