Forum Discussion

TroyStory's avatar
TroyStory
Regular Visitor
6 years ago
Solved

How can I build a data warehouse?

Hi All, looking for some guidance on the way to approach the below.   I had previously built a report that was importing data from excel spreadsheets to a report that was published in the powerBI s...
Need Help
  • edhans's avatar
    edhans
    6 years ago

    I know very little about actual data sync. MS has a tool for this, and I know there are third party tools to sync between various data sources, like SQL, SharePoint List, etc. to Azure. You'd just need to do a bit of searching, or head to the Azure community on the MS tech forums. I know someone there will have hands-on experience with this and can assist.

TroyStory's avatar
TroyStory
Regular Visitor
6 years ago

Thanks edhans 

 

Lastly, I already have data in a production SQL database as well as in some spreadsheets.

 

What would the recommended method be to regularly update this information to the Data warehouse? Ideally this would be in azure to not have any impact on the production environment.

 

Is there a tool that can be used to simply push the data across or what do I need to look into to do this?

 

Thank you for all your answers, I really appreciate your time.

edhans's avatar
edhans
Community Champion
6 years ago

I know very little about actual data sync. MS has a tool for this, and I know there are third party tools to sync between various data sources, like SQL, SharePoint List, etc. to Azure. You'd just need to do a bit of searching, or head to the Azure community on the MS tech forums. I know someone there will have hands-on experience with this and can assist.