Salesforce Connector [via FiveTran]
To connect Salesforce to CaliberMind, you need:
- Access to an active Salesforce account
- An Enterprise level account plan or higher, or purchased API calls
Step 1: Enable field history tracking
Read the Salesforce documentation to learn how to enable field history tracking.
Step 2: Disable session IP locking
If you have Session IP Locking enabled or get an
INVALID_SESSION_ID error, go to the Session Settings page and uncheck the Lock sessions to the IP address from which they originated box. It is very rare that this setting needs to be updated (<1% of cases), because by default it is already disabled for the majority of users.
Step 3: Finish CaliberMind configuration
- In the connector setup form, enter the Destination schema name of your choice.
- Click Authorize to authorize the API. You will be taken to the Salesforce login page.
- Login to your Salesforce account to authorize CaliberMind to connect to it.
- Return to the CaliberMind dashboard and click Save & Test. CaliberMind will take it from here and sync your data from your Salesforce account.
Step 4: (Optional) Limit permissions to tables or columns
CaliberMind syncs the data that we have access to based on the viewing permissions of the connected user. If you don't want CaliberMind to sync a certain type of data to into your destination, limit the permissions of the connecting user.
There are two ways to limit the data that we extract from your Salesforce account. You can either disable tables in the CaliberMind dashboard or limit the connecting user in Salesforce.
Option 1. Disable tables in the CaliberMind dashboard
- In your CaliberMind dashboard, navigate to the Salesforce connector details page.
- Go to the schema tab and disable the tables and columns which you do not want to be synced.
If you are concerned about unintentionally syncing sensitive data to your destination, disable "Include new schemas and tables by default."
Option 2. Limit the connecting user in Salesforce
CaliberMind connects to your Salesforce instance through the credentials of the connecting user, so to limit our access to the data, limit that user's access. You can do this in Salesforce through Permission Sets.
It's best to limit the connecting user's access before you initially connect the user through our setup form. Otherwise, you may have some dead tables in Salesforce that will no longer be updated after you've restricted the user's permissions.
- Log in to Salesforce. You must have administrative privileges to set permissions.
- Go to Setup in the top right corner of your screen.
- Under the Administer tab on the left side of the screen, click on the arrow next to Manage Users.
- You should now see a drop-down menu below the arrow. Select Permission Sets in the drop-down menu.
- We recommend that you create a new set of permissions specifically for the user that you will use to connect to CaliberMind. Name it something memorable, such as "CaliberMind Permissions."
Users can have multiple sets of permissions assigned to them. If you'd like to be certain of what data we have access to, assign only one set of permissions to the connecting user.
Press New > Enter in Label > Choose Appropriate User License Type
- You'll see the settings for the new Permission Set (for example, "CaliberMind Permissions"). Select Object Settings.
- Select which fields you would like this connecting user, and therefore CaliberMind, to have access to. The default setting is "No Access."
The only permissions relevant to CaliberMind are that we can read the data, though the user themselves may need to be able to do more. The difference between the "Read" permission and the "View All" permission is that "Read" gives access to view records that are created by that user or are shared via rules, roles, or manual sharing. "View All" gives access to all records of that type (for example, the "Account" type).
- When you've chosen the appropriate permissions, go to Administer > Manage Users > Users and select the user whose account you will use to log in through CaliberMind.
- When you're on that user's page, scroll down to Permission Set Assignments and click Edit Assignments.
- Move "CaliberMind Permissions" from "Available Permission Sets" to "Enabled Permission Sets" and click Save.
What will this connection do?
We will backup a copy of all your relevant CRM data from 14 standard objects (ask your account manager if you'd like to add additional custom objects)
Which Tables and Fields require "Read", or "Read" and "Write" access?
As noted above, there are 14 objects which will be synced to our data warehouse: Account, Campaign, CampaignMember, Contact, Group, Lead, Opportunity, OpportunityContactRole, OpportunityHistory, Profile, RecordType, Task, User, UserRole
There are 5 caveats to this information:
- All 14 objects noted above will require "Read" access - only the "standard" and non-custom fields within these objects require this access
- Three tables - Account, Contact, Lead - also require that ALL fields within these tables - both standard and custom - have "Write" access as well. This is due to any possible deduplication, merge, or other data management workflows which might be set up would require this user permission to perform these actions.
- If a future workflow involving the "CampaignMember" object is requested for implementation, this object - as well as the "Campaign" object - would also require "Write" access for ALL fields (both standard and custom) on these objects
- Any custom fields (noted with either "_c" or "_pc" at the end of the field's API name) that are used or referenced in any formulas or customizations (opportunity amounts, formulas, etc.) within the CaliberMind system would also require "Read" permissions (or both "Read" and "Write" permissions - depending on if these fields are within a "Write" table as noted above)
- Any custom fields that are used or setup for pushing CaliberMind data back to your Salesforce would also require "Write" permissions
Could this integration disrupt any business processes or data in my CRM?
- There are several "safety" mechanisms in place to prevent any business disruption.
- For data replication from Salesforce, we use the Salesforce Bulk API and copy 10,000 records from each object per request. So our usage is VERY efficient.
- All instances of CaliberMind start as read-only, so no workflows can accidentally be created that impact your sales data.
- Eventually you will WANT to create meaningful, scalable and automated business processing using the data in your CaliberMind data lake... but not yet! (We're just getting started).