Demo - End to End Automation for Loading Data into Master Data Services Model

Automation is playing critical role in Data and Analytics. Additionally, Automated systems are proved more robust and efficient due to less or zero human intervention. In this video, I am showing you automating the data load process from end to end within SQL Server 2019 environment. You will see the power of Master Data Services(MDS) to complying data governance within modern enterprises. The solution has three important parts 1. Demo Source table containing records to be loaded into MDS table 2. Automated Stored Procedures loading these records into MDS Product Entity 3. SQL Agent Job that will execute the stored procedure at defined interval and push the new data into MDS automatically 4. Verification of new Data at MS Excel as well as Dimension level. You might need to watch following video as well. It will help you understand the full scenario.