Skip to content

Data Factory objects in Synapse Studio

Reading Time: 3 minutes

In this post I want to cover where you can find Azure Data Factory objects in Synapse Studio. I want to do this post for a couple of reasons.

First reason is that at the start of the year I published a post on how to automate a Data Factory pipeline migration to an Azure Synapse Analytics workspace using Azure DevOps.

Even though I showed one way that you can automate the migrations of a Data Factory to a Synapse workspace I did not show where you can view them in Synapse Studio.

Second reason is because I keep telling everybody they can use the same pipelines in Azure Synapse Analytics but the objects can be found in different places.

To clarify, Synapse Studio is the frontend that comes with Azure Synapse Analytics. In order to use Synapse Studio, you must first create a Synapse workspace.

By the end of this post, you will know where to find the common Azure Data Factory objects in Synapse Studio.

Data Factory objects in Azure Data Factory

In Azure Data Factory Studio the most commonly used objects are pipelines, datasets and mapping data flows. You can find these objects grouped together within the Author hub.

Objects in Azure Data Factory Studio
Objects in Azure Data Factory Studio

However, in Synapse Studio they are in different hubs. Which I will cover below.

Data Factory objects in Synapse Studio

In this post I go through the objects in the order that they are shown in Azure Data Factory. However, be aware that the hubs are in a different order when you go from top to bottom on the left-hand side in Synapse Studio.

Those new to Synapse Studio to go through my other post which is a six-minute crash course about Synapse Studio.

Anyway, you can view the pipelines in the Integrate hub. Which is also the hub where you can now configure Azure Synapse Link for SQL.

Integrate hub in Synapse Studio
Integrate hub in Synapse Studio

When I click on the pipeline name you can see that it has same canvas as pipelines in Azure Data Factory.

Pipeline details in Synapse Studio
Pipeline details

You can find datasets in the Data hub. However, in Synapse Studio they are known as Integration datasets. When I click on one you can see that you get the same three tabs as you do Azure Data Factory. Which are the Connection, Schema and Parameters tabs.

Integration Datasets in Synapse Studio
Integration Datasets in Synapse Studio

Finally, in the Develop hub you can find mapping data flows (also known as data flows by some).

Develop hub in Synapse Studio
Develop hub in Synapse Studio

When I click on the mapping data flow you can see the same canvas view as you do in Azure Data Factory.

Mapping data flow canvas in Synapse Studio
Mapping data flow canvas

Final words

I hope this post about where you can find Azure Data Factory objects in Synapse Studio proves to be useful.

Because I want people to realize where the common objects used in Azure Data Factory can be found in Synapse Studio.

Of course, if you have any comments or queries about this post feel free to reach out to me.

Published inAzure Data FactoryAzure Synapse Analytics

Be First to Comment

Leave a Reply

Your email address will not be published. Required fields are marked *