Salesforce to SQL Server Data type conversion

Question

I am using ADF pipelines to bring Salesforce data into SQL Server, most of the fields in SQL server are coming as nvarchar due to data type on Salesforce.
Some cases I know data is always int or varchar, but due to data type at Salesforce these are by default coming as nvarchar. It is important to keep right data types in SQL server for performance reasons.
For now I do not want to change data type on Salesforce. is there any way I can instruct ADF pipeline to put data into specific type of column (int or varchar) irrespective of source data type?

Answer 1

Hi VipinSharma,

Thanks for reaching out to Microsoft Q&A.

Yes you can change the datatype using ADF, please go through the following link where the similar question has been answered by pradeep.

https://learn.microsoft.com/en-us/answers/questions/408226/how-to-transform-data-type-in-azure-data-factory.html

Please Upvote and Accept as answer if the reply was helpful.