Skip to main content

Varicent ELT Help Center

Salesforce import

Abstract

Connect your Varicent ELT and Salesforce accounts to import your data.

Connect your Varicent ELT and Salesforce accounts to import your data.

Before you begin

The Salesforce account used for import requires certain Salesforce permissions. The account must be assigned a Profile or Permission Set with the following permissions enabled:

Permission or feature

Description

API Enabled

This permission allows the user to be API enabled.

Bulk API

This feature allows the user to query, queryAll, insert, update, upsert, or delete bulk records asynchronously.

Note

This API is available in the following Salesforce editions: Enterprise, Performance, Unlimited and Developer editions.

Salesforce import needs API access and Bulk API feature. API access could be granted through enabling API Enabled permission. For information on enabling the Bulk API feature, see: Enable Asynchronous API.

Run Reports

This permission enables the user to run reports.

View Roles and Role Hierarchy

This permission enables the user to view roles and the role hierarchy.

View Setup and Configuration

This permission enables the user to view setup and configuration.

Deleted Salesforce records

Salesforce keeps deleted records in the recycle bin for 15 days. These records could be visible through the API until the recycle bin completely purges them.

You can determine which records are deleted records by checking the IsDeleted column (property) of a record.Varicent ELT only imports rows that are not deleted by checking this property.

Supported data sources

This connector can import data from many Salesforce objects, including the custom objects you define.

Note

Ensure that you define the appropriate permissions so Varicent ELT can access the object.

The following list are the objects that Varicent ELT doesn't support:

  • 'AssetTokenEvent'

  • 'AttachedContentNote'

  • 'EventWhoRelation'

  • 'QuoteTemplateRichTextData'

  • 'TaskWhoRelation'

  • 'SolutionStatus'

  • 'ContractStatus'

  • 'RecentlyViewed'

  • 'DeclinedEventRelation'

  • 'AcceptedEventRelation'

  • 'TaskStatus'

  • 'PartnerRole'

  • 'TaskPriority'

  • 'CaseStatus'

  • 'UndecidedEventRelation'

  • 'Announcement'

  • 'ContentDocumentLink'

  • 'CollaborationGroupRecord'

  • 'Vote'

  • 'IdeaComment'

  • 'FieldDefinition'

  • 'PlatformAction'

  • 'UserEntityAccess'

  • 'RelationshipInfo'

  • 'ContentFolderMember'

  • 'ContentFolderItem'

  • 'SearchLayout'

  • 'SiteDetail'

  • 'EntityParticle'

  • 'OwnerChangeOptionInfo'

  • 'DataStatistics'

  • 'UserFieldAccess'

  • 'PicklistValueInfo'

  • 'RelationshipDomain'

  • 'FlexQueueItem'

  • 'ListViewChartInstance'

  • 'FeedLike'

  • 'OutgoingEmail'

  • 'OutgoingEmailRelation'

  • 'FeedSignal'

  • 'ActivityHistory'

  • 'EmailStatus'

  • 'UserRecordAccess'

  • 'Name'

  • 'AggregateResult'

  • 'OpenActivity'

  • 'ProcessInstanceHistory'

  • 'OwnedContentDocument'

  • 'FolderedContentDocument'

  • 'FeedTrackedChange'

  • 'CombinedAttachment'

  • 'AttachedContentDocument'

  • 'ContentBody'

  • 'NoteAndAttachment'

  • 'LookedUpFromActivity'

  • 'AttachedContentNote'

  • 'QuoteTemplateRichTextData'

Note

Varicent ELT also does not support any object whose name ends with ChangeEvent, such as AccountChangeEvent.

Varicent ELT can only pull data from objects and reports that have permission to be viewed by the user who created the Salesforce connection. If objects or reports not listed in the previous unsupported objects list are unavailable to import, check the permissions associated with them in Salesforce. This also applies to individual fields, such as columns, within objects, as they can have permissions applied directly to them.

Import

With the correct permissions in place, you can now import your data into Varicent ELT.

Importing data

Important

When you create a new Salesforce connector within Varicent ELT, you are prompted to login to Salesforce. After you authenticate, you are asked to give Varicent ELT permission to access some of your data in Salesforce. This permission is required to allow Varicent ELT to import data from your Salesforce objects and reports.

The user who authenticates with Salesforce and creates the connection must have the API-enabled permission selected in their Salesforce user profile. Otherwise, the imports will fail.

  1. In Varicent ELT, select the Data module from the sidebar navigation pane.

  2. Click Import data.

  3. In the Third party sources, click Salesforce.

  4. Click New connection.

  5. On the Connect to your Database page, enter the connector name. Click Next.

    Note

    You can also connect to your Salesforce sandbox account. Select Use sandbox and you are redirected to the Salesforce website where you can connect to an available sandbox account.

    You are redirected to the Salesforce website.

  6. On the Salesforce website, enter your credentials.

  7. On the Allow Access? page, click Allow to give Varicent ELT access to your Salesforce account. You will be redirected back to Varicent ELT.

    Note

    After you allow Varicent ELT access to your Salesforce account, you can find Varicent ELT listed as a connection in your Salesforce account. To view the connection listing, go to your Salesforce profile and click Settings > My Personal Information > Connections.

    If Varicent ELT is not listed as a connection, or if the connection is revoked, recreate a Salesforce connection in Varicent ELT to import from Salesforce.

  8. On the Select data page, select the directory and the start date. Click Next.

  9. On the Import data page, review your data and select the data to obfuscate (if any). Click Next.

  10. On the Filter data page, optionally click Filter data to refine your data, or click Import data to continue.

    1. Filter the rows in your data by selecting the column to filter, the filter category and the value or text.

    2. Click Import data to continue.

    Note

    For more information about how to configure data filters, see: Filter data.

  11. On the Review page, review the data sets that you are importing.

  12. Click Import data.

    The data is available on the My Data page.

Note

If you are performing a lot of Salesforce imports at a time, or have other third party apps regularly interacting with your Salesforce account, there is a chance that you will hit Salesforce’s daily API call limit. If this occurs, you will have to wait until the next day before performing more imports.

Usage examples

With a new Salesforce connection, you can start importing your data from Salesforce.

You will be provided with a list of available objects and reports you can import.

For example, if you want to analyze your Salesforce leads, you can search for and select the Lead object, complete the import setup, and start the import into Varicent ELT. Shortly after, your Lead data will be available in Varicent ELT, where you can view it, and start analyzing it in a pipe.

Security and privacy

We use standard practices to authenticate with Salesforce, and we securely store encrypted access tokens.

We only import data on the Salesforce objects and reports that you specify, and the data is stored securely.

You can remove Varicent ELT permission to access your Salesforce data at any time. To remove permission, follow the following steps:

Removing permission

  1. Go to your Salesforce account.

  2. Go to Connected Apps.

  3. Click Connected Apps OAuth Usage.

  4. Block the Varicent ELT app.

    Blocking the Varicent ELT app prevents any further data imported into Varicent ELT from your Salesforce account.

Error handling

The following errors may appear during the import process:

Error

Description

Solution

Bulk API permissions are currently disabled for this Salesforce account. Enable this setting in Salesforce and try again.

This error occurs if the Enable API permission is not selected for the user who created the Salesforce connection.

To fix this error, you can enable the permission for the user.

We can't find <field_name> column on <object_name> object. Review the Field Level Permissions in Salesforce. Try importing your data again.

This error can occur on imports or refreshes, if a field, or field level permission of a field, that was initially available was removed.

To fix this error, you can either perform a fresh import of the affected object, or restore the field or permission to its previous state in Salesforce.

Generic connection error

You may encounter other connection errors if the Varicent ELT app is blocked in Salesforce.

To fix this error, you can either unblock the app in Salesforce, or create a new connection.

Salesforce has reported 12489/15000 (83.26%) total Bulk API quota used across all Salesforce Applications. Terminating replication to not continue past configured percentage of 80% total quota.

You are over 80% of the allowed Salesforce REST API usage quota.

Learn more about Salesforce API Request Limits and Allocations.

This replication job has made 50 REST requests (30%) of total quota. Terminating replication due to allotted quota of 25% per replication.

You are over the limit of allotted Salesforce REST API requests for your current request.

To fix this error, you can either increase your quota limit on Salesforce or choose not to import the file.

Learn more about Salesforce API Request Limits and Allocations.