Skip to main content

Qlik

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
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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
137 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.
137 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?

137 Views
0 Likes