Query from different databases

[Anonymous]

Hi all,
there is a way in Talend Open Studio to write a query (in query builder) using tables from different databases or to see and edit the tMap process as a query, it's possible?
thank you very much!
vikr

[Anonymous]

Actually I think I should do a FULL OUTER JOIN between the tables instead of two left join, but probably I must write the code to do this.
Or could I solve this problem from Talend Open Studio IDE?
thanks
vikr

[Anonymous]

Hi
Here is job:
tFileInputDelimited_1and tFileInputDelimited_2 do a left join.
tFileInputDelimited_3 and tFileInputDelimited_4 do an inner join and get the unmatched rows.
tFileInputDelimited_1=tFileInputDelimited_4:
16;11111;Mary
17;22222;Elise
18;44444;Eric
19;55555;Shong
tFileInputDelimited_2=tFileInputDelimited_3:
1;mmmmm;Mary
2;eeeee;Elise
3;ccccc;Catly
4;ddddd;Shong
5;fffff;Plegall
Result:

Starting job formerge at 14:32 25/02/2008.
.--+-----+-----+-------.
|      tLogRow_1       |
|=-+-----+-----+------=|
|id|code1|code2|name   |
|=-+-----+-----+------=|
|1 |11111|mmmmm|Mary   |
|2 |22222|eeeee|Elise  |
|3 |44444|null |Eric   |
|4 |55555|ddddd|Shong  |
|5 |null |ccccc|Catly  |
|6 |null |fffff|Plegall|
'--+-----+-----+-------'
Job formerge ended at 14:32 25/02/2008. 

[Anonymous]

Hi Shong,
yes, you are rigth
now it's working!
Thank you very much
regards
vikr

[_AnonymousUser]

Thank you very much

[_AnonymousUser]

hello
can i compare data from 2 different databases(oracle and sql server)?
plz if yes how?

[Anonymous]

hi khalidinformatic,
Yes you can get data from two different databases using the respective components toracleinput (for data from oracle database) and tmsmsqlinput (for data from sql server) and then join/compare them in the tmap.