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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
aleksb
Contributor
Contributor

SalesForce - Bulk Import use existing connection

Hi,
I have a Salesforce bulk import job, it works fine, apart from connecting to Salesforce. Just to clarify, I can connect using Metadata->Salesforce->Connector, and I can connect when typing connection details in component properties ( tSalesforceBulkExec), but when dropping the connection from metadata into workspace to be reused, it does not work.
It shows in dropdown selection ( use existing connection ), but when running the job, I am getting '0'' ( zero ) as connection return.
We are using Talend Platform
Any clues?
Thanks
Labels (3)
3 Replies
Anonymous
Not applicable

Which version of Talend Platform product are you using? You meant the job works fine and it insert data to salesforce if you create the connection on the component, but no data are inserted into salesforce if you using an existing connection?
Best regards
Shong
aleksb
Contributor
Contributor
Author

Hi Shong,
Thank you for reply. Here are the Talend details:
Talend Platform for Data Services
Version: 5.6.2
Build id: 20150508_1414
From the screen shots, when using connection details directly in the component, works fine, but if I try to use existing connection - it fails, with this error:
Exception in component tSalesforceOutput_1
java.lang.RuntimeException: Get null connection from tSalesforceConnection_1
    at bulkimport.smsintocrm_0_1.SMSintoCRM.tFileInputDelimited_1Process
No idea how to fix. Any guideline is appreciated.
Thanks
CRTtech
Contributor
Contributor

Exception in component tSalesforceOutput_1
java.lang.RuntimeException: Get null connection from tSalesforceConnection_1
    at bulkimport.smsintocrm_0_1.SMSintoCRM.tFileInputDelimited_1Process
No idea how to fix. Any guideline is appreciated.
Thanks

Did you get this resolved? If you connect it without using the same connection it might work.
(Although this is an old thread, it's nice to locate when Googling so I'm replying 0683p000009MA9p.png )