Can I Connect to Salesforce With an API Only User?

Yes, you can connect with an API Only user if the user account is authorized and have the permissions required to access your data.

We use the http://login.salesforce.com API endpoint to log in to Salesforce using a user name and password. If the user account has the permissions required to log into Salesforce using this endpoint and access your data, the connector will work as expected.