Export/Import pipelines created via synapse studio to ADF service

Question

We have developed some pipelines using the azure synapse analytics orchestrate tab (Great job adding all the services under same roof!).
Now we wanted some of these pipelines to be migrated into separate ADF service. Is it possible?

Regards
Lokesh

Answer 1

Hi @Lokesh ,

Thank you for your response. Currently direct export of pipeline/entities is not supported in Synapse studio but Export/Import factories is in the near future plan according to the confirmation from internal sources. Components like Data Flows can actually be fully copy & pasted from the script-behind between ADF & Synapse.

And another way to create same resources from Synapse studio to another Data factory resource is to save the JSON payloads of the IntegrationRuntimes, Linked Services, Datasets and pipelines from Synapse studio into separate .json files and then use powershell as described in below document to create the entities in the desired Data Factory resource using those saved .json files. Please make sure to create the entities in an order to avoid dependency conflicts.

• Create an Azure data factory using PowerShell
• Create a linked service
• Create datasets
• Create a pipeline

Also I would highly recommend you to please share your feedback/suggestion in Azure Synapse Analytics user voice forum : https://feedback.azure.com/forums/307516-azure-synapse-analytics. All the feedback shared in this forum are actively monitored and reviewed by Azure Synapse Analytics engineering team.

Please do share the feedback link here, once it is created, as it would help other users with similar idea to up-vote and/or comment on your suggestion as well as to increase the priority of the feature request.

Also please subscribe to Azure Updates to get the latest updates on Azure products and latest features.

Hope the above info helps. Do let us know if you have further query.

----------

Thank you
Please do consider to click on "Accept Answer" and "Upvote" on the post that helps you, as it can be beneficial to other community members.

Answer 2

Hi @Lokesh ,

I found the following work around by using Azure DevOps.
By linking your ADF and Synapse workspace to the same collaboration branch, you can share developments in ADF and Synapse.
Hope this helps!