In this article
This article describes the principal changes of Salesforce Templates.
This article is dedicated to Stambia DI S17, S18 and S19.
templates.salesforce.2020-04-28
Add the ability to specify an alternate temporary file name
Salesforce Integration and Load Template have been updated to be able to customize the path of the temporary file created while loading data from or to Salesforce.
This offers the ability to change this temporary location which defaults to Runtime's temporary folder.
To customize the temporary file path, you can therefore now:
- Use the new "Out File Name" parameter which has been added to Integration Template, when you are sending data into Salesforce
- Use the "In file Name" parameter of the Load Template when you are loading data from Salesforce
Note:
When setting the "Out File Name" parameter, the exchange file will be located at another place than default. Therefore, be careful if you are retrieving next the response of the Salesforce Integration Template in a target database in your Mapping. In this case 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.
templates.salesforce.2019-04-17
Replicator Salesforce
Salesforce Replicator now supports using technology specific loaders.
A new parameter named "Load Method" has been added to enable specific loading.
Refer to parameter documentation for further information.
Prerequisites:
- Stambia DI Designer S19.0.18 or higher
- templates.generic.2019-04-17 or higher
templates.salesforce.2019-01-10
Load Salesforce to Rdbms / Replicator Salesforce to Rdbms
New parameter 'SForce Chunk Size' which is used to define Chunk size which should be transmitted to Salesforce when extracting Salesforce data with Bulk Mode.
Chunk size is used by Salesforce to automatically calculates a number of batches based on the value specified by analyzing data to be extracted and splitting it into multiples batches.
This can be useful when you are retrieving a large set of data to avoid experiencing timeouts errors from Salesforce, as extraction will be performed in multiple batches.
Prerequisites:
- Salesforce Connector 1.1.3 or higher
Load Salesforce to Rdbms / Replicator Salesforce to Rdbms / Integration Rdbms to Salesforce
All Salesforce Templates now support 'Disable Session Logout' parameter which can be specified in Metadata since Salesforce Connector 1.1.3.
Templates will retrieve automatically the value specified for this parameter in Metadata.
Note also that this Metadata parameter can be overridden on Replicator Template.
Prerequisites:
- Salesforce Connector 1.1.3 or higher
templates.salesforce.2018-09-28
Integration Rdbms to Salesforce
- New parameter 'Ignore Field Keyword'.
- When the keyword specified in this parameter is encountered in data, the field is not sent to Salesforce.
Prerequisites:
- Salesforce Connector 1.1.1 or higher
Load Salesforce to Rdbms
- New parameter 'Clean Invalid Characters'.
- When using Bulk Mode, if this parameter is enabled invalid characters such as 0x1a will be removed from the retrieved data, avoiding errors when such characters are encountered. We advise to correct Salesforce source data when it's possible instead of using this parameter, as it can impact performances.
- New parameter 'SForce Bulk Concurrency Mode' to define the concurrency mode to be used when retrieving data.
- New parameter 'Sforce Bulk Await Pollint' to specify the amount of time to wait between each job status check.
- New parameter 'SForce Bulk Await Timeout' to specify the timeout for the Salesforce job. If the job des not finish before the timeout is reached the Runtime will interrupt it and throw an error.
Prerequisites:
- Salesforce Connector 1.1.1 or higher
Replicator Salesforce to Rdbms
- New parameter 'Clean Invalid Characters'.
- When using Bulk Mode, if this parameter is enabled invalid characters such as 0x1a will be removed from the retrieved data, avoiding errors when such characters are encountered. We advise to correct Salesforce source data when it's possible instead of using this parameter, as it can impact performances.
- New parameter 'Bulk Mode' to enable Salesforce Bulk mode when retrieving data.
- New parameter 'SForce Bulk Concurrency Mode' to define the concurrency mode to be used when retrieving data.
- New parameter 'Sforce Bulk Await Pollint' to specify the amount of time to wait between each job status check.
- New parameter 'SForce Bulk Await Timeout' to specify the timeout for the Salesforce job. If the job des not finish before the timeout is reached the Runtime will interrupt it and throw an error.
Prerequisites:
- Salesforce Connector 1.1.1 or higher