Salesforce Component Release Notes

This page lists the main features added to the Salesforce component.

Feature Highlights

Version 2.1.3

Salesforce to Rdbms Upload Template

Default SQL Batch Size is set to 1000 to improve performance.

Version 2.1.0

Support of EMF Compare

Several improvements have been made to support EMF Compare.

Version 2.0.2

Change Data Capture (CDC)

Multiple improvements have been performed to homogenize the usage of Change Data Capture (CDC) in the various Components.

Parameters have been homogenized, so that all Templates should now have the same CDC Parameters, with the same support of features.

Multiple fixes have also been performed to correct CDC issues. Refer to the changelog for the exact list of changes.

Version 2.0.1

Sample project

The component example project can now be imported directly in the "New" menu of the Project Explorer.

Version 2.0.0

Storage folder

The template "Integration rdbms to Salesforce" creates a temporary exchange file, in the temporary folder of the Runtime.

A new parameter named "Out File Name" has been added to customize the path of this temporary file.

When setting this parameter, the exchange file will be located at another place than default.

Therefore, be careful if you are retrieving the response of the Salesforce Integration in a target database in your Mapping.

You must set the 'In file Name' parameter of the target 'Load Salesforce to Rdbms' template to the same path. Otherwise, the load template will not find the exchange file and will not be able to load the response.

Change Log

Version 2023.1.10

New Features

  • DI-8788: Template Load Salesforce to Hive: added the ability to retrieve deleted Salesforce objects with the Get Deleted Row option.

Bug Fixes

  • DI-4386: Template Load Salesforce to Hive: fixed an issue where temporary files were not being created in the same location as the export file.

Version 2023.1.9

New Features

  • DI-7209: Implement error and bulk concurrency management in the Salesforce Bulk V2 template.

Bug Fixes

  • DI-8417: Update Okio third-party libraries.

Version 2023.1.4

Bug Fixes

  • DI-7939: When Salesforce returns multiple error messages for the same input line, these messages are unexpectedly all identical.

Version 2023.1.3

Bug Fix

  • DI-7836: When trying to generate an OAuth2 token while the security metadata have some defined auth parameters or HTTP headers, the error Failed to generate OAuth 2 Authorization Header is displayed.

  • DI-7765: The error messages returned as output by Salesforce are incomplete/truncated in some situations.

Version 2023.1.1

Bug Fix

  • DI-6747: When Salesforce rejects a row with multiple error messages, only one error is available. To leverage all these errors, customers should reverse-engineer the XML metadata corresponding to the error output and adapt their data processes accordingly.

  • DI-7262: OAuth2 requests a new token even if a former token is still valid.

Version 2023.1.0

New Features

  • DI-4742: In the Replicator Salesforce to Rdbms template, the Record Separator parameter allows changing the record separator used in temporary files.

  • DI-5389: The metadata reverse-engineering has been improved.

  • DI-5628: The order in which data is integrated in Salesforce can now be defined.

  • DI-6110: Salesforce SDK - Third-party library upgrade.

Bug Fixes

  • DI-4497: Wizards do not propose a scroll bar on small screens or when resizing them. This makes certain fields inaccessible.

  • DI-4878: The temporary file is not cleaned at the end of the execution when using the Load Salesforce To Hive template.

  • DI-6085: When the DUPLICATES_DETECTED error is returned by Salesforce, the component unexpectedly stops reading the results of the current batch.

  • DI-6461: When running multiple data flows with different OAuth2 tokens, the tokens are mismatched with each other, leading to authentication errors.

Version 5.3.12 (Component Pack)

Bug Fixes

  • DI-7663: Salesforce upsert operation fails with the error 'InvalidJob : External ID was blank'.

  • DI-7667: Missing result data after Salesforce integration process.

  • DI-7765: In some situations, Salesforce returns error messages that are incomplete or truncated.

  • DI-8942: ClassNotFound exception in Designer when loading some components.

Version 5.3.11 (Component Pack)

Bug Fix

  • DI-6980: When mapping Rdbms to Salesforce in the bulk mode, if a Salesforce field has an error, the error message does not mention the name of the field.

Version 5.3.7 (Component Pack)

Bug Fixes

  • DI-6085: When a DUPLICATES_DETECTED error is returned by Salesforce, the component unexpectedly stops reading the results of the current batch.

Version 3.0.1 (Component Pack)

New Features

  • DI-5164: Template - integration Rdbms to Salesforce - support the oauth2 property named "JsonProperties"

Version 3.0.0 (Component Pack)

New Features

  • DI-3035: Use Salesforce BULK API V2 to write

  • DI-3701: Allow Components to contribute to Designer monitored statistics

  • DI-4508: Update Components and Designer to take into account dedicated license permissions

  • DI-4727: Rebranding: Templates and sample projects

  • DI-4962: Improved component dependencies and requirements management

Version 2.1.3 (Salesforce Component)

New Features

  • DI-4994: Template - Load Salesforce to Rdbms - set a default SQL batch size to 1000 for performances purposes

Version 2.1.2 (Salesforce Component)

New Features

  • DI-1058: Salesforce - ability to filter the list of returned records based on source data through a new "query" mode

Bug Fixes

  • DI-1088: "Maximum attribute size limit" error was unexpectedly thrown when uploading an attachment

  • DI-1295: "Exceeded max size limit" error was silently ignored in some situations

  • DI-1296: "Storage limit exceeded" error was silently ignored in some situations

Version 2.1.1 (Salesforce Component)

New Features

  • DI-3959: Component updated to support the replacement of SQL Explorer with the Stambia Query Editor

Version 2.1.0 (Salesforce Component)

New Features

  • DI-3510: EMF compare utility - Component has been updated to support EMF Compare comparison utility

Bug Fixes

  • DI-1621: When extracting data from Salesforce, such as when using the replicator, a "Connection reset" was thrown in some situations, most notably when extracting large sets of data

  • DI-1961: Template - Integration Rdbms to Salesforce - fix a typo on "SQL Fetch Size" parameter, "Fecth" instead of "Fetch"

  • DI-2810: When the execution of an asynchronous SalesForce batch was terminated externally, the exception was not recognized and the session appeared as normally executed

  • DI-3561: Having a line return character in a filter defined on a Salesforce datastore in Mapping unexpectedly produces a "Malformed Query exception" at execution

Version 2.0.3 (Salesforce Component)

New Features

  • DI-1252: OAuth2 - Ability to externalize whole properties through a new "Json Properties" attribute containing a JSON representation of all the OAuth2 attributes and which is automatically generated

Bug Fixes

  • DI-2921: Salesforce metadata - Fix of salesforce metadata which not supported OAuth2 nodes

Version 2.0.2 (Salesforce Component)

New Features

  • DI-2855: Load Salesforce to RDBMS and Load XML to RDBMS Templates should not be proposed when loading data from Salesforce to Hive (they are not applicable in this situation)

  • DI-1910: Templates updated - New parameter 'Cdc Subscriber' on Templates on which it was not handled yet

  • DI-1909: Templates updated - New Parameters 'Unlock Cdc Table' and 'Lock Cdc Table' to configure the behaviour of CDC tables locking