Forum Discussion
What is the difference between the below technical terms?
Hi Experts,
I am confused about below technical terms. I had searching a lot but still not clear. It seems the purpose below are for data storage. Could someone help to give me an overview on it
Data Lake
Azure Databricks
Azure Synapse
Dataverse
Fabric
Moreover, we are studying to develop some dashboards(via Power BI Desktop or Power BI Embedded) for showing the budget data to user to view on-line. The budget data is come from Oracle database. Extract all necessary data from Oracle database and import into local/cloud server. Schedule the data extraction job to be running at night.
My question is how should I choose the above 5 items for storing the budget data? What ETL should I be used? Which RDMBS is used? Should I use the Microsoft SQL Server... etc. May I have your advice, pls?
Thanks
Toms
1 Reply
Hello TomsNg ,
Well it all depends on how huge is your data and where it is stored, but i will share you the following Microsoft documentations for each technical term you've mentioned:
Data Lake:
https://learn.microsoft.com/en-us/power-query/connectors/data-lake-storage
Azure Databricks:
https://learn.microsoft.com/en-us/power-query/connectors/databricks
Azure Synapse:
https://community.fabric.microsoft.com/t5/Community-Blog/Azure-Synapse-with-Power-BI/ba-p/2541921
Dataverse:
https://learn.microsoft.com/en-us/power-apps/maker/data-platform/data-platform-intro
Fabric:
https://learn.microsoft.com/en-us/fabric/get-started/microsoft-fabric-overview
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
