Salesforce® Integration
With the Konvert™ Salesforce® Integration, you can easily streamline the onboarding process by connecting to your customer and prospect account records. The Salesforce integration brings your Salesforce account data into Konvert. After the integration is set up, your accounts in Salesforce will be imported into Konvert, and any changes made to this data within Salesforce will be updated in Konvert every 15 minutes.
In the article, we will explain:
- Account filtering
- Field selection and mapping
- Related lists
- Related list filtering
- Initial import and syncing changes
- Prerequisites
- Installing the Konvert Data Integration App in Salesforce
- Integration settings in Konvert
ACCOUNT FILTERING
Example: You have both prospect and customer account records in Salesforce. You include an account number for customer accounts but not for prospects. If you want to only bring over the customer accounts, you can do so by providing a filter like AccountNumber !=’’
Any SOQL WHERE statement can be used to filter for the accounts you wish to sync.
FIELD SELECTION AND MAPPING
Any data from fields on the Salesforce account can be brought over to Konvert. Each field is stored in a custom field on the account in Konvert.
To set this up, provide a list of Salesforce field names, for example, AccountNumber and the corresponding Konvert custom field names where they should be stored.
The Salesforce ID and name for the account will automatically be stored. The ID is stored as the Konvert Account’s customId. This is used to keep the data in sync and can be used to retrieve the account using the Salesforce ID via the Konvert API.
RELATED LISTS
Data from related lists under accounts can be stored on custom fields for the account. One or multiple fields on the related object can be stored in the Konvert account. To set this up, provide a list of Salesforce related lists with the following information for each related list:
- Object Name of the related list objects
- Relationship Field Name on Account (field name where the related list is attached)
- Optional filter (see related list filtering)
- Field Map – list of one or multiple fields to get data for
- Salesforce field name (field on the related object)
- Konvert Account field name (where you want to store data from the related object)
RELATED LIST FILTERING
The related lists can optionally be filtered much like accounts can, using a SOQL WHERE String. This will only bring data over into Konvert from a filtered list of related objects.
INITIAL IMPORT AND SYNCING CHANGES
Once the integration is set up on Konvert and within Salesforce, your accounts will be imported using the filters and field maps provided. As data changes in Salesforce, it will be updated in Konvert every 15 minutes.
- When an account is created in Salesforce, it will be created in Konvert
- When an account is updated in Salesforce, it will be updated in Konvert
- When an account is deleted in Salesforce, it will be deleted in Konvert
- When related objects that are mapped are created, modified or deleted in Salesforce, the parent account is updated in Konvert
RELATED FEATURES
There are some related Konvert features available, which are often used in conjunction with Salesforce integration.
- Providing a user registration page that asks the user for a piece of information from their account for verification. This is often an account number. If valid, the user is registered and added to the Account with the matching account number.
- Mapping an account field to which user groups for the account will be added. For example, an account has a field of Salesforce Asset Names that the account owns. This data is mapped to a list of Konvert user groups to which the users of the account will be added.
PREREQUISITES
The Salesforce organization you are connecting to Konvert must be one of the following editions:
- Enterprise Edition
- Unlimited Edition
- Performance Edition
- Professional Edition (when API Access add-on is purchased)
A user within your Salesforce organization must have the following permissions:
- Customize Application
- Modify All Data
- Manage Profiles and Permission Sets
INSTALL THE KONVERT DATA INTEGRATION APP IN SALESFORCE
- Navigate to the URL: https://login.salesforce.com/packaging/installPackage.apexp?p0=04t5w000005Dm4r
- Log into your Salesforce organization if necessary from a user account with the required permissions listed under Prerequisites.
- Select Install for Admins Only
- Check the checkbox “I acknowledge…”
- Click Install
Once the application finishes installing, within the Setup area of your Salesforce organization, complete the following steps:
- Navigate to: Setup -> Apps -> Connected Apps -> Manage Connected Apps
- Click the edit link next to Konvert Data Integration
- Set Permitted Users to: Admin approved users are pre-authorized
- Navigate to: Setup -> Apps -> Connected Apps -> Manage Connected Apps
- Click Konvert Data Integration
- Under profiles, click the Manage Profiles button
- Select the profile of a user which will be used for the integration. This can be the user installing the application or a separate user, as long as the profile has API enabled under Administrative Permissions. (System Administrator profile has API Enabled by default and can be used in most situations.)
INTEGRATION SETTINGS IN KONVERT
To enable Salesforce integration, please provide the following settings to Konvert:
- The Salesforce username of a user in your organization with the profile used when Managing the Konvert Data Integration. The API calls that the Konvert Data Integration performs will be on behalf of this user. We recommend having a dedicated user for this integration that is not tied to any actual person. If you do use a username associated with a person whose Salesforce account is deactivated, the integration will stop syncing data until a new username is provided.
- Optional account filter (see Account Filtering)
- Field Map (see Field Selection and Mapping)
- Related Lists (see Related Lists)
- Object Name of the related list objects
- Relationship Field Name on Account (field name where the related list is attached)
- Optional filter (see related list filtering)
- Field Map – list of one or multiple fields to get data for
- Salesforce field name (field on the related object)
- Konvert Account field name (where you want to store data from the related object)
The Salesforce® Integration is included in the Enterprise plan and is offered as an add-on with the Professional plan. Additional costs may apply.