Talend - no output from the tSalesForceInput component

Question

I am new to Talend and I have a very simple task of bringing in a Salesforce "contact" table into the database. To begin with testing, I only have the tSalesforceInput and tLogRow components (as per screenshot - left activated sub job) and I am only selecting "accountId" in the SOQL.

"SELECT AccountId
 FROM contact
 WHERE AccountId != null
 LIMIT 1000"

This returns a log output of 1000 AccountIds fine (as in screenshot - below).

I then introduced the tConvertType component (as per screenshot - right activated sub job) and I lost all output (log output returns 1000 rows with null values). I did not introduce any datatype casting in the convert component yet.

Would really appreciate some inputs on what could be happening. Thanks!

NBaliga · Accepted Answer · 2021-07-02 17:54:46Z

1

I was actually making a mistake of not selecting the "cast" method in the tConvertType component properties. I selected "Auto Cast" here and then in the "Edit schema" option, changed datatypes to what I want. Newbie mistakes :)

answered Jul 2, 2021 at 17:54

NBaliga

631 silver badge6 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Talend - no output from the tSalesForceInput component

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related