topic Re: How to extract data from SQL Server and process row by row in Talend Studio

How to extract data from SQL Server and process row by row

Anonymous — Sat, 16 Nov 2024 04:20:48 GMT

Hi, all! Talend newbie here. I have data in an SQL Server database which I want to extract and process row by row. For each row, I want to perform a different action depending on the value of one field in the row (the same field each time). My current job so far has the following steps:

tMSSQLInput

main

tFlowToIterate

iterate

tJava

However, I now want to connect from tJava to tWriteJSONField using the runif connector but Talend won't allow that. Is there a way to do this, or a better way using different components? I'm not sure whether it should be tJava, tJavaRow, or something else altogether.

TIA,

Nick

Re: How to extract data from SQL Server and process row by row

Anonymous — Fri, 18 Oct 2019 05:31:35 GMT

Hi
tWriteJsonField requires an input component, so you can use tFixedFlowInput to generate the input data before tWriteJsonField.
eg
tMSSQLInput-main(row1)-->tFlowToIterate--iterate--tJava--oncomponentok--tFixedFlowInput--main--tWriteJsonField...
on tFixedFlowInput, you can get the input data which is extracted on tMssqlInput with expression like:

(String)globalMap.get("row1.columnName")

Regards
Shong

Re: How to extract data from SQL Server and process row by row

Anonymous — Fri, 18 Oct 2019 23:29:31 GMT

Many thanks, worked perfectly!