topic How to pass MYSQL queries in oracle component to get the values by using talend in Talend Studio

How to pass MYSQL queries in oracle component to get the values by using talend

AR1695207745 — Fri, 15 Nov 2024 21:23:25 GMT

How to pass MYSQL queries in oracle component to get the values by using Talend

Re: How to pass MYSQL queries in oracle component to get the values by using talend

Anonymous — Mon, 25 Sep 2023 01:04:28 GMT

Hello,

We suppose you would like to pass a sql query result set to a job and

you could store the result of query to a context variable, and use this variable in oracle component.

For example:

tMysqlInput1--main--tJavaRow

onsubjobok

tOracleInput--main--tLogRow

on tJavaRow:

context.data=input_row.data;

Elaborating your case with an example with input and expected output values will be preferred.

Best regards

Sabrina

Re: How to pass MYSQL queries in oracle component to get the values by using talend

AR1695207745 — Mon, 25 Sep 2023 11:19:33 GMT

I have 10 reference id in Mysql database table (tMysqlinput) in that i have to take certain reference id to check whether the reference id's are present in the Oracle database(tOracleinput) and get the values in the table format and join with that output values in Oracle .😊