topic Re: Read multiple sql queries in text or excel file in Talend Studio

Read multiple sql queries in text or excel file

BNP — Mon, 16 Mar 2020 18:38:39 GMT

Hi ,

I want to read multiple sql queries in text or excel.file.retrieve the data from Database using tflowtoiterate can someone help me

nivedhitha — Mon, 16 Mar 2020 18:45:06 GMT

@BNP , sure but what is the current job design and where exactly do you need help with?

On a high level the design has to be like

Parent Job ---- tFileExcelInput -> tFlowToIterate -> tRunJob(child job)

-Pass the query to the child job as a context variable (any any other data from the excel that the database load needs)

Child Job ----- tDbInput -> tDbOutput

Child job has context variables to hold values being passed by the parent job

BNP — Mon, 16 Mar 2020 18:53:51 GMT

Instead of running child job. Can we use global variables?.

manodwhb — Tue, 17 Mar 2020 02:52:16 GMT

@BNP , Yes you can use the global variables of tFlowtoIterate. and your job design should be like below.

tFileExcelInput -> tFlowToIterate --iterate-- tDbInput -> tDbOutput

BNP — Tue, 17 Mar 2020 17:10:41 GMT

Hi,

Thank you for replied.

I have save file name as SQL Statement, and i mention schema as Statement, Query.

In tDBinput table field and Query what should enter. i have attached error images.

Ex:

(String)globalMap.get("row.ColName")

in row.colname, what should enter.

Thank you

manodwhb — Wed, 18 Mar 2020 03:45:09 GMT

Hi, you need to we the global variable in tdbinput . are queries are select staments?