Salesforce Azure Data Factory Source Connector getting less or more columns from salesforce

Satya Praveen Velicheti 6 Reputation points
2023-05-10T15:26:20.0666667+00:00

Hi,

I'm using ADF to get data from Salesforce to SQL Server (Copy Activity). I see everything is working except that Salesforce connector is getting less columns for one Salesforce object and also getting more columns (Than what we see in actual salesforce object) for one other object. Trying to find if i'm missing anything in here or is that an expected behavior.

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,893 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Satya Praveen Velicheti 6 Reputation points
    2023-05-15T11:47:05.27+00:00

    Hi @KranthiPakala-MSFT , For less columns found it's due to a setting at salesforce level. There is a column level setting in Salesforce which needs to be set in order for a column to be visible to respective user/Application. https://developer.salesforce.com/forums/?id=906F0000000AhcPIAS. Following that I was able to see rest of the columns in ADF now. I will try the Post Man today to test more columns piece.


  2. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.


    Comments have been turned off. Learn more