Microsoft Fabric

There are multiple tools in Fabric which you can use for extracting data from data sources.

Some examples of tools are:

• Dataflow Gen 2
• Data pipeline (copy activity)
• Notebook (Spark)

Data pipeline is also commonly used for orchestration, e.g. executing Notebooks or Dataflow Gen 2 in a pipeline run, however Notebooks and Dataflow Gen 2 can also be executed without being inside a Data Pipeline. 

Here is some information about the differences:

https://learn.microsoft.com/en-us/fabric/get-started/decision-guide-pipeline-dataflow-spark

Common methods for ingesting data into Lakehouse:

https://learn.microsoft.com/en-us/fabric/data-engineering/load-data-lakehouse

Common methods for ingesting data into Data Warehouse:

https://learn.microsoft.com/en-us/fabric/data-warehouse/ingest-data