Hi @michal ,
Thankyou for using Microsoft Q&A platform and posting your query .
As I went through your ask, it seems you want to know which is the best platform to use for the requirement of copying data from source like SFTP to storage account or copy data within the storage account. Please let me know if my understanding is incorrect.
You can use the Copy activity to copy data among data stores located on-premises and in the cloud. It is available in Azure Data Factory Pipelines as well as in Synapse pipelines. You can use anyone of these tools to meet your requirement.
Azure synapse just have additional capabilities of bring ADF pipeline feature (where you can create data ingestion pipelines and make use of data flow to perform data transformation) along with spark technology features within itself as there you can create notebooks and write custom codes in pyspark/scala/.Net spark/Spark SQL. You can make use of datawarehouse features using dedicated and serverless sql pools , you can integrate it with PowerBI to create reports.
To know more about Azure synapse analytics , please visit Azure syanpse overview
Coming back to your query, please visit the following resources to know what can be achieved using Copy activity in ADF or Synapse pieplines:
Copy activity in Azure Data Factory and Azure Synapse Analytics
Copy Data tool in Azure Data Factory and Synapse Analytics
Hope this will help. Please let us know if any further queries.
- Please don't forget to click on or upvote button whenever the information provided helps you.
Original posters help the community find answers faster by identifying the correct answer. Here is how
- Want a reminder to come back and check responses? Here is how to subscribe to a notification
- If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators