What is the difference between the below technical terms?

[TomsNg]

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

Need Help

[Idrissshatila]

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 👍

Follow me on Linkedin