I want load Salesforce Data coming in CSV to a SFTP site which takes data in XML format

Ujjwal Chand SA 20 Reputation points
2024-12-09T07:45:25.6966667+00:00

I want to migrate salesforce data from salesforce to STFP site but I couldn't find a way to convert the csv into XML structure, so that the data ready to be loaded to SFTP.

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,637 questions
0 comments No comments
{count} votes

Accepted answer
  1. Pinaki Ghatak 5,600 Reputation points Microsoft Employee Volunteer Moderator
    2024-12-09T10:01:06.2766667+00:00

    Hello @Ujjwal Chand SA

    To convert CSV data to XML format, you can use Azure Data Factory. You can create a pipeline with a copy activity that moves data from a Salesforce source by using different tools/APIs. You can use the following tools to create a pipeline: Visual Studio, Azure PowerShell, Azure Resource Manager template, .NET API, and REST API.

    Here are the high-level steps to convert CSV data to XML format using Azure Data Factory:

    1. Create a linked service for Salesforce and SFTP in Azure Data Factory.
    2. Create a dataset for CSV file and SFTP in Azure Data Factory.
    3. Create a pipeline with a copy activity that reads data from the CSV file and writes data to the SFTP site.
    4. Use a mapping data flow to transform the CSV data into XML format before writing it to the SFTP site. You can find more information on how to create a pipeline with a copy activity in the following article: https://docs.microsoft.com/en-us/azure/data-factory/copy-activity-overview 
    5. To transform the CSV data into XML format, you can use a mapping data flow in Azure Data Factory. You can find more information on how to use mapping data flows in the following article: https://docs.microsoft.com/en-us/azure/data-factory/concepts-data-flow-overview

    I hope this helps!


1 additional answer

Sort by: Most helpful
  1. Ganesh Gurram 7,295 Reputation points Microsoft External Staff Moderator
    2024-12-09T17:06:49.8866667+00:00

    Hello @Ujjwal Chand SA

    Thanks for the question and using MS Q&A forum.

    Follow this link to convert CSV to XML: CSV to XML conversion using Logic Apps Standard

    Refer to this similar thread: Convert CSV to XML

    http://blogs.recneps.net/post/Processing-a-flat-file-with-Azure-Logic-Apps

    Hope this helps. Do let us know if you have any further queries.


    If this answers your query, do click `Accept Answer` and `Yes` for was this answer helpful. And, if you have any further query do let us know.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.