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:
- Create a linked service for Salesforce and SFTP in Azure Data Factory.
- Create a dataset for CSV file and SFTP in Azure Data Factory.
- Create a pipeline with a copy activity that reads data from the CSV file and writes data to the SFTP site.
- 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
- 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!