Connecting SmartConnect to Salesforce without a Security Token

With the latest released version of SmartConnect you can connect to Salesforce without using the Salesforce security token. This allows the Salesforce connector to be setup using just the Salesforce login and password. You will want to have a static IP address, otherwise you will need to be updating the Trusted IP Ranges in Salesforce any time your IP address changes. 

To setup your Salesforce account to not require the security challenge you will need to go to Setup. Expand Security Controls and select Network Access. You can also just enter Network Access into the Quick Find search box.

Click the New button to add a trusted IP address. If you have a range of IP addresses you can set the entire range you would like your organization to be able to connect from without the security challenge. You can find out your current IP address by visiting Save the IP address settings in Salesforce.

Open SmartConnect and go to the Setup tab and choose the Salesforce connector. Enter your Salesforce username and password. When you click the Test button you should get a ‘Connected Successfully’ message if you are connecting from a machine in the trusted IP range setup in Salesforce.



With this setup you will not have to change the Salesforce connector setup if the Salesforce security token is reset. This will allow any SmartConnect Salesforce integrations to continue without any updating.


Excel data sources work intermittently or give blank error message.
How to set up automatic payments on eOne's website portal
"Info 1625. This installation is forbidden by system policy", when attempting to install the SmartConnect Excel Add-In
Salesforce Objects or fields are not available in SmartConnect
Attempting to select a readonly publisher for solution


SSL Security error using OLEDB Connection
Removed Part: /xl/vbaProject.bin part. (Visual Basic for Applications (VBA))
The server process could not be started because the configured identity is incorrect.
Using WINSCP and a task to upload or download files from an SFTP site
Shortcuts Template for Extender



open all | close all


Business Central CRM D365 Business Central Dynamics 365 dynamics crm Dynamics GP Dynamics NAV Econnect Employee Spotlight eone eOne News Events Excel Excel Report Builder Extender Extender Enterprise Flexicoder GP GPUG integration Meet the Team Microsoft dynamics crm Microsoft Dynamics GP Office Relationships partners Popdock release Reporting SalesForce scripting SmartConnect SmartConnect Bootcamp SmartConnect Office Hours SmartList SmartList Builder SmartList Designer SmartView SQL Support Tech Tuesday Templates training Zendesk

Integrate & Automate without Any Code.

SmartList Data has Never Been Faster.

The Easiest Way to Report on GP Data.