Connecting to Salesforce
To open the connection window click on the 'Connect Data Source' in either the source or destination. This will display the 'Connect to Datasource' window. Choose 'Salesforce' and then 'Salesforce Object' provider.
Getting API Configuration Details
Consumer Secret and Consumer Key
To get your consumer key and consumer secret you will need to log into salesforce and create a new connected app, depending on which view you are using the following steps will vary.
Go to Setup > Apps > App Manager and choose New Connected App.
Go to Setup > Build > Create > Apps and under Connected Apps click the 'New' button.
Now enter in the required settings.
The settings to be completed are:
Connected App Name
Type in a title for the App.
Enter an email.
Enable OAuth Settings
Make sure the checkbox is checked.
We set this to be https://www.simego.com.
OAuthScopes Add 'Access and manage your data (api)' to the selected OAuth Scopes.
Then Press save to create the App. This will now display your App settings.
Under API(Enable OAuth Settings) locate Consumer Key and enter this into the Salesforce Connector Window under
Click to reveal the Consumer Secret and enter this into the Salesforce Connector Window in Data Sync under
To get your security token you will need to log into Salesforce and reset your security token.
Go to the User Icon and select 'Settings'. Under the 'My Personal Information' menu choose 'Reset My Security Token' and then click the 'Reset Security Token' button. The system will then send the user an email with the new security token. Copy this into the Salesforce Connector Window in Data Sync under
Locate the user dropdown in the title bar of the page and select 'My Settings'. Open the Person Menu and choose 'Reset My Security Token'. Click on the 'Reset Security Token' button and the system will send the user an email with the new secuirty token. Copy this into the Salesforce Connector Window in Data Sync under
Save the Connection
Once you have entered your required credentials, save the connection by clicking 'Connect & Update Library Connection'.
Enter in a name for the connection and press 'save'. This will appear in the connection tree under 'Salesforce'.
Once you have saved the connection you can make use of the connection tree, where you can drag and drop the object you wish to connect to into either the source or the target or you can right click and choose either
Connect to Source or
Connect to Target.
You can also make use of the query function:
Queries use SOQL DatTime and Date Literals, please see the Salesforce page for more information.
Connect to the Sandbox Login URL.
The Salesforce object to connect to.
Number of records to return per Salesforce request in Incremental Mode.
The SOQL WHERE condition to append the SELECT Query.