Can an API-only Salesforce User Authenticate a Connection?

Yes, an API-only Salesforce user can authenticate a Salesforce connection in Fivetran if:

• The Salesforce account is active.
• The Salesforce organization is on an Enterprise plan or higher, or has purchased API calls.
• The user hasn't authenticated more than four existing Fivetran Salesforce connections using the same account credentials.

For prerequisites and setup instructions, see our Salesforce Setup Guide.

Limit what Fivetran can sync

Fivetran can only sync the data that the authenticating API-only user can access. To limit the objects and fields we can sync, restrict the user's access in Salesforce. For more information, see our documentation on limiting a connecting Salesforce user.

For more information on how Salesforce permissions work, see the Salesforce Permissions and Access Settings documentation.