Skip to main content
Gainsight Inc.

Configure Out of the Box Jobs

IMPORTANT NOTE: Gainsight is upgrading Connectors 2.0 with Horizon Experience. This article applies to tenants which are yet to be upgraded to the Horizon Experience of Connectors 2.0. If you are using Connectors 2.0 with Horizon Experience, you can find the documentation here.

This article is the fifth in a series of Salesforce connector articles. Gainsight recommends you refer to the initial articles and then proceed with this article.

This article explains the default settings configured in Out of the box sync jobs. If you are not aware of different stages in a Data sync job, refer to the Create Data sync jobs article and then proceed with this article.

Overview

When you authorize a connection, Gainsight creates six out of the box data sync jobs. You can modify the jobs, if required. These jobs are used to sync the basic data required to perform routine operations in Gainsight. The six out of the box jobs are:

currency sync job_SFDC.png

Picklist Sync Job

This job is named as Picklist Sync_ Connection name. (here Picklist Sync_Connect to SFDC). This job syncs data from Salesforce Picklist to Gainsight Dropdown lists. By default, this job does not have any dependencies. You can add a dependent job, if required. The Notification Details fields of this job contain the email address of the logged in user. You can add, edit, or delete email recipients. 

There are no configurations or mappings for this section. You can only schedule the execution of this job.

2..GIF

User Sync Job

This job is named as User Sync_ Connection name. (here User Sync_Connect to SFDC). This job syncs user data from the Salesforce User object to the Gainsight User object. By default, this job has a dependency on Picklist Sync job. You can add a dependent job, if required. The Notification Details fields of this job contain the email address of the logged in user. You can add, edit, or delete email recipients. 

  • In the job configuration stage, Source object is mapped to Salesforce User Object and target Object is mapped to Gainsight User Object. You cannot modify this setting. 
  • By default, there are five field mappings configured in this job. You can add, edit, or delete these field mappings. The mappings are: 
    • First Name -> First name 
    • Last Name -> Last Name
    • Email -> Email
    • Time Zone -> Timezone
    • Username -> Username

By default, the mapping between Username field from Salesforce and Username field from Gainsight is set as the Upsert key. You can select some other mapping as the Upsert key or even have multiple mappings as Upsert keys, if required. It is mandatory to configure at least one mapping as Upsert key.

  • There are no derived mappings configured for this job. You can add any number of derived mappings to populate values into the GSID type fields as required. For more information, refer the Data Import Lookup article.
  • The Filters section has two filters by default. These filters are configured to fetch only Standard and Active users. You can add, edit, or delete the filters as required. 
  • The Schedule section is not configured for this job. You can either schedule an execution or import data now with the available options. 

3..GIF

All of the Salesforce users, whether they are assigned with an Active or Inactive Gainsight CSM License, after syncing through Salesforce Connector > User Sync job, the users will be marked as Active in the Gainsight User Management page. If you want to mark any user as Inactive in Gainsight, change the Status to Inactive manually from the Gainsight User Management page.

For more information on the Active users in Gainsight, refer to the Gainsight User Management article.

Company Sync Job

This job is named as Company Sync_ Connection name. (here Company Sync_Connect to SFDC). This job imports data from the Salesforce Account object and inserts it into the Gainsight Company object. By default, this job has a dependency on the User Sync job. You can modify the dependent job, if required. The Notification Details fields of this job contains the email address of the logged in user. You can add, edit, or delete email recipients. 

  • Since this job syncs data from Salesforce Account object to Gainsight Company object, the Source object is mapped to Salesforce Account object and target object is mapped to Gainsight Company object. You cannot modify this setting. 
    Note: To learn more about various objects available in Gainsight, refer to the Gainsight Data Management article.
  • By default, there are three field mappings configured in this job. You can add or edit the mappings.The mappings are:
    • Account ID  -> SFDC Account Id
    • Account Name -> Name 
    • Employees -> Employees

By default, the mapping between Account ID field from Salesforce Object and SFDC Account Id field from Company object is set as the Upsert key. You can select some other mapping as the Upsert key or even have multiple mappings as Upsert keys, if required. It is mandatory to configure at least one mapping as Upsert key.

  • By default, there are no Derived mappings, Filters, or Schedule configured for this job. However, you can configure these sections, as required.

4..GIF

Relationship Type Sync Job

This job is named as Relationship Type Sync_ Connection name. (here Relationship type Sync_Connect to SFDC). This job imports data from the Salesforce Relationship Type object and inserts it into the Gainsight Relationship Type object. By default, this job has a dependency on the Company Sync job. You can modify the dependent job, if required.The Notification Details fields of this job contains the Email address of the logged in user. You can add, edit, or delete email recipients.

  • Since this job fetches data from Salesforce Relationship Type object to Gainsight Relationship type Object, the Source object is mapped to Salesforce Relationship Type Object and target Object is mapped to Gainsight Relationship Type Object. You cannot modify this setting.
  • By default, there are two field mappings configured in this job. You can add or edit the mappings. The mappings are:
    • Name -> Name
    • Id -> SFDC Relationship Type Id (Person)

The mapping between Id field in Salesforce Relationship Type Object and SFDC Relationship Type Id field in Gainsight Relationship Type object, is configured as the Upsert key. You can select another mapping as the Upsert key or even have multiple mappings as Upsert keys, if required. It is mandatory to configure at least one mapping as the Upsert key.

  • By default, there are no Derived mappings, Filters, or Schedule configured for this job. However, you can configure these sections, as required.

6..GIF

Relationship Sync Job

This job is named as Relationship Sync_Connection name. (here Relationship Sync_Connect to SFDC). This job imports data from the Salesforce Relationship object and inserts it into the Gainsight Relationship object. By default, this job has a dependency on the Relationship type sync job. You can modify the dependent job, if required.The Notification Details fields of this job contains the Email address of the logged in user. You can add, edit, or delete email recipients.

  • Since this job fetches data from Salesforce Relationship object to Gainsight Relationship Object, the Source object is mapped to Salesforce Relationship Object and target Object is mapped to Gainsight Relationship Object. You cannot modify this setting.
  • By default, there are two field mappings configured in this job. You can add or edit the mappings. The mappings are:
    • Name -> Name
    • Id -> SFDC Relationship Id (Person)

The mapping between Id field in Salesforce Relationship Type Object and SFDC Relationship Id field in Gainsight Relationship Type object, is configured as the Upsert key. You can select another mapping as the Upsert key or even have multiple mappings as Upsert keys, if required. It is mandatory to configure at least one mapping as the Upsert key.

  • By default, there are no Derived mappings, Filters, or Schedule configured for this job. However, you can configure these sections, as required.

7..GIF

Currency Sync Job

Currency Sync Job is created only when Multi-Currency is enabled in the org from the Currency Management page. This job is required to sync currency information such as supporting currencies and conversion rates from Salesforce to Gainsight. In the Currency sync job, data from the CurrencyType (Salesforce source object) is imported to the GS Currency Coefficient (Gainsight target object). The Notification Details fields of this job contain the Email address of the logged in user. You can add, edit, or delete email recipients. Following configurations are available in the Currency Sync Job:

  • Three field mappings are configured in this job. Adding or editing the mappings is not allowed. Currency ISO Code field is marked as Upsert Key. The mappings are:
Source Field Source Data Type Target Field Target Data Type
Conversion Rate Double Conversion Rate Number
Currency ISO Code picklist Currency Code String
Corporate Currency boolean Corporate Currency Boolean

  • Honour Source Currency Code toggle is Switched off.
  • Derived Mappings and Filters are not configured for this job.
  • Job schedule is configured as required to update the currency information in Gainsight.

For more information on Multi-Currency, refer to the Multi-Currency Support in Gainsight article.

Data Sync Jobs for Renewal Center

If you are using Gainsight Renewal Center, two additional data sync jobs are created out of the box ; Opportunity Stage Sync and Opportunity sync jobs. 

Opportunity Stage Sync Job

This job syncs data between Salesforce Opportunity Stage object and GS Opportunity Stage object. This job has a dependency on the Company sync job. By default, this job has 11 field mappings. The mapping between Opportunity Stage Id field in Salesforce and External Id field in Gainsight is used as the Upsert key. Gainsight doesn’t recommend changing the Upsert key. The complete list of field mappings is  shown below:

new.png

This job does not have any derived mappings or filters, by default. However, you can add them, as required and schedule the execution or run the job instantly. 

Opportunity Sync Job

This job syncs data from the Salesforce Opportunity object to Gainsight’s GS Opportunity object. This job is dependent on the Opportunity Stage sync job. This job has 11 field mappings by default. Apart from the 11 field mappings, you must map another four mandatory fields. The fields to be mapped are given below (the names provided in the Salesforce Field Name column below are only for representation purpose. The names of the fields can vary in your Salesforce environment)::

Salesforce Field Name Gainsight Field Name
Forecast Amount Forecast amount
Target  Amount Target  Amount
Final Amount Final Amount
Target Date Due Date

Apart from these fields, you must also map custom fields (if any), to ensure that Opportunity data is successfully synced back to Salesforce when a user modifies an opportunity. By default, the mapping between Opportunity ID field in Salesforce and External Id field in Gainsight is used as the Upsert key. 

9..GIF

This data sync job has four Derived Mappings:

  1. The first derived mapping uses Direct Lookup (to User object) to populate GSID to the Created By field in GS Opportunity object. The matching is between the Created by ID field in Salesforce and SFDC User Id field in Gainsight User object.  

10..GIF

  1. The second derived mapping uses Direct Lookup (to User object) to populate GSID to the Modified By field in GS Opportunity object. The matching is between the last Modified By ID field in Salesforce and SFDC User Id field in Gainsight User object.  

11..png

  1. The third derived mapping uses Direct Lookup (to User object) to populate GSID to the OpportunityOwner field in GS Opportunity object. The matching is between the owner ID field in Salesforce and SFDC User Id field in Gainsight User object.

12..png

  1. The fourth mapping uses Direct Lookup (to Company object) to populate GSID to the Company field in GS Opportunity object. The matching is between the Account ID field in Salesforce and SFDC Account Id field in Gainsight Company object.

13..png

CAUTION

  • If you have configured a field in Salesforce Connector, you must not delete the field from Data management page. This breaks the Renewal Center deployment. 
  • You must not create any formula fields (calculated fields) in the GS Opportunity object. This prevents Renewal Center from synchronizing updates.
  • Was this article helpful?