Skip to main content

Varicent ELT Help Center

Salesforce

Abstract

Connect your Varicent ELT and Salesforce accounts to export your data to your Salesforce account.

Connect your Varicent ELT and Salesforce accounts to export your data to your Salesforce account. This connection allows Varicent ELT to write data to Salesforce.

Set up the connector to be available for use with the Export tool. You only need to set up the connection once. After the connection is set up, Varicent ELT can write updates and inserts in Salesforce.

Important

You can import Salesforce read-only data, but Varicent ELT cannot update the data in Salesforce on export.

Salesforce Record IDs

When exporting to Salesforce, records are updated or added based on the id column of the row. The following behavior can occur:

  • If the id is missing in the row, a new record is added to the Salesforce object.

  • If the id exists in the row, the record with matching id in Salesforce will be updated.

  • If an invalid id is used, the export will fail with MALFORMED_ID status code.

Create the connection

Create the connection between Varicent ELT and Salesforce. Generate a new Salesforce connection or use an existing one.

Creating a new connection

  1. In Varicent ELT, go to your pipe.

  2. Add the Export tool.

  3. In the Export tool configuration section, click the Connection drop-down.

  4. From the connection drop down, click + New connection.

  5. Create the new Salesforce connection for the export tool.

    1. On the Create a connection page, click Salesforce.

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

      Note

      If you are not signed into Salesforce, Varicent ELT redirects you to the Salesforce website. On the Salesforce website, enter your credentials. Salesforce then redirects you back to Varicent ELT.

      The Salesforce connector name now appears in the Connection field.

  6. In your pipe on the Export tool configuration page, find the new connection in the Connection drop-down.

  7. Enter a name for the connection and select the Object name.

  8. Click Export now.

    The data is now available to use in the Export tool. For more information about the tool, see Export.

Using your existing Salesforce connection

  1. In Varicent ELT, go to your pipe.

  2. Add the Export tool.

  3. In the Export tool configuration section, click the Connection drop-down.

  4. Search for and select your existing Salesforce export connection.

  5. Enter a name and select the Object name.

  6. Click Export now.

    The data is available to use in the Export tool. For more information about the tool, see Export.

Error handling

The following errors may appear during the export process:

Error

Description

(status code: reason of failure)

Any errors prefixed with “Export failed with the following Salesforce error:” are errors that Varicent ELT receives from the Salesforce API. These errors show a status code and the reason for the failure.

For more information about Salesforce error codes, see Status Code.