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

Satya Praveen Velicheti 6 Reputation points


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.
7,213 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Satya Praveen Velicheti 6 Reputation points

    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. 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.