Please indulge me for asking a rather vague, 10,000 foot type question. I hope to get some feedback from anyone who faced a similar situation. Thanks!
A manufacturing company uses three separate instances of the same ERP (Enterprise Resource Planning) software in three different countries (U.S., Sweden and China). The ERP system uses sql server 2017 for it's database.
What are the possibilities of using SSIS to integrate the three instances of the ERP data into one central warehouse?
If security and infrastructure considerations are satisfied and the data is integrated what are the possibilities for sharing reports and cubes from the warehouse with users in each country?
Would an Azure warehouse be useful in this case?