The solution to the following situation might help you troubleshoot Salesforce connections:
The connection fails to connect to a Salesforce account.
You may have to enter a Salesforce security token in the Salesforce connection details. If the security token is required and the Security Token field in the Salesforce connection is empty or invalid, the following error message appears when you test or create the connection:
The login to Salesforce.com failed with the following message - LOGIN_MUST_USE_SECURITY_TOKEN:
Go to the Salesforce web site to obtain the security token. To avoid adding the security token to connection details, you can also add Data Integration IP addresses to Trusted IP Ranges in your Salesforce account. For more information, see Security Tokens and Trusted IP Ranges in the Connect to Snowflake topic. You can find additional information with in the Informatica How-To Library article: Activating IP Addresses for Salesforce Connections.