|
SSIS Salesforce Destination
|
 
|
|
SSIS Salesforce Destination can be used to load large amount of data from any source to Salesforce.com without any programming. You can use simple drag and drop mapping to perform Bulk Insert/Upsert/Update and Delete operations.
|
| Property Name | Description | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| Operation | Action you like to perform
|
||||||||||
| AssignmentRuleId | ID of AssignmentRule you want to fire after new Lead or Case is created. This option is only valid for object type Lead and Case. To fire default assignment rule set UseDefaultAssignmentRule=true. To find out AssignmentRule ID, navigate to Assignment Rule page and get ID from URL (e.g. 01Q610000008e5x). For more information check this link https://help.salesforce.com/articleView?id=editing_assignment_rules.htm | ||||||||||
| UseDefaultAssignmentRule | If you want to fire default Assignment rule after Case, Lead or Account, set this option to true. Either AssignmentRuleID or this option can be used. If you set this option to true and also specify AssignmentRuleID property then it may throw error | ||||||||||
| UpsertKeyField | Key field based on which you want to perform Upsert action. This can be Id, External ID or IdLookup field type. | ||||||||||
| EnableBulkApiMode | Enable BULK API mode for large amount of data load. This mode may be slower for smaller set of data but if you have large amount of data then choose this mode to speedup data loading. | ||||||||||
| MaxRowsPerJob | Maximum rows per job. This option is useful to avoid memory related errors when EnableBulkApiMode=true. Reduce or increase this limit as per you need. For example if you getting OutOfMemory error then reduce this count. | ||||||||||
| ConcurrencyMode | When you set EnableBulkApiMode=true by default all batches are executed in parallel mode on salesforce side, this might cause issue in some cases due to row locking. If you get error about row locks then try to change this to Serial mode see it helps. This option is ignored if you set BulkApiVersion=V2 (V1 API doesn't support this yet).
|
||||||||||
| BulkApiVersion | Bulk API Version to use for data processing. API V2 is very different than V1 so test performance with each version and use the one fits your need. V2 is better if you facing Locking issue. Default is v1.
|
||||||||||
| LoggingMode | LoggingMode determines how much information is logged during Package Execution. Set Logging mode to Debugging for maximum log.
|
||||||||||
| PrefixTimestamp | When you enable this property it will prefix timestamp before Log messages. | ||||||||||
| DoNotCreateOutputs | Enable / Disable Response Output. Checking this option can remove unwanted warnings about unused Columns and many times speedup performance so if output is not needed set this option to True so its removed. | ||||||||||
| TableName | Target object name where you want like to write data. | ||||||||||
| BatchSize | How many rows you want to send in each request.. This setting is ignored when EnableBulkApiMode=true. In BulkApi V1 mode batch size is fixed at 10000 rows per batch. In V2 we go by MaxRowsPerJob settings. | ||||||||||
| IgnoreFieldsIfInputNull | Set this option to True if you wish to ignore fields if input value is NULL. By default target field is set to NULL if input value is NULL. | ||||||||||
| FieldsToSetNullIfInputNull | Comma separated CRM entity field names which you like to set as NULL when input value is NULL. This option is ignored if IgnoreFieldsIfInputNull is not set to True. | ||||||||||
| EnableParallelProcessing | Enables sending requests using multiple threads to speed up processing. Try to adjust MaxParallelThreads property to test performance gain. This property is ignored if you EnableBulkMode=true. | ||||||||||
| MaxParallelThreads | Max Parallel Threads to use to process requests. This property is only valid if you set EnableParallelProcessing=True. Valid values are 1 to 40. This property is ignored if you EnableBulkMode=true. |
|
SSIS PowerPack v2.9 released (Upsert Destination, Salesforce BULK API and more…)What’s New In this release we focused on mainly providing high quality and super fast Upsert Destination (Bulk Update, Insert and Delete / Merge) for SQL Server. We also added Salesforce BULK API support for Salesforce Destination. Full Notes: https://zappysys.com/onlinehelp/ssis-powerpack/scr/release-notes.htm Version 2.9.0.10210 [Feb 08, 2019] New Features/Improvements NEW: Amazon S3 CSV File Source, FTP, Azure – […] |
|
Load data in Salesforce using SSIS Insert, Upsert, Delete, UpdateIntroduction In this article we’re going to focus on load data in Salesforce using SSIS (Bulk Insert, Update, Delete and Upsert). If you like to know how to read from Salesforce then refer to previous post here. For Demo purpose we will use AdventuresWorks sample database as our source but you can use your own […] |
