Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Note: You may notice some temporary visual or styling issues in the Community. Our vendor is actively investigating.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
mani1304
Creator
Creator
‎2019-12-19 01:53 PM

Salesforce inset slow

Hi,
I am loading data into Salesforce object using tsalesforceoutput component using retrieved id option checked because I need Salesforce id for that purpose but it's very slow may be because it's loading one by one in Salesforce due to batch size option got disabled after selecting retrieve id. Any suggestions to do faster the performance. Data is around 100-150k and have 4-5 columns to insert.

Labels (2)
Labels
324 Views
0 Likes
2 Replies
TRF
Champion II
Champion II
‎2019-12-20 01:22 AM

Try to bulkify your job using tSalesforceOutputBulkExec component instead of tSalesforceOutput.
324 Views
0 Likes
mani1304
Creator
Creator
‎2019-12-23 08:54 AM
Author

Thanks. I am using bulk, but can you tell if there is any limit for tsalesforceoutput component for faster processing with retreive id check?

324 Views
0 Likes