How Can I Check Whether the Connection's Authorizing User Can Access Missing Data?

Question

Tables or fields are missing from the destination. How can I check whether the connection's authorizing user can access the relevant data?

Environment

The following connectors:

• Salesforce
• Salesforce Sandbox

Answer

To check whether the authorizing user can access the relevant data, do the following:

1. In Fivetran, go to your Salesforce connection page.
2. Select the Setup tab.
3. In the Connection metadata & setup section, make a note of the Salesforce User and Org ID.
4. Log in to your Salesforce account as the Salesforce User from step 3.
5. Check that your Salesforce Organization ID matches the Org ID from step 3 by looking at the ID in your Salesforce environment's URL or on the Support landing page. For more information, see Salesforce's Find your Organization ID documentation.
6. Check whether you can access the relevant data.

IMPORTANT: Accessing the data in Salesforce doesn't guarantee that we can sync it or access it using the Salesforce API. For more information, see our Salesforce setup guide.