Page 1 of 1

retrieve results of a custom sql query from a database connection

Posted: Sat Sep 08, 2018 7:18 am
by sarahjohns388
Hi,

I want to be able to retrieve the result set of a complex sql query from a mysql database. The query joins many tables and includes custom where clauses to limit the resultset.

I used multiple tMysqlinput components as input into a tMap and this then outputs to a single tMysqlOutput. The tMap does the mappings and joins (not able to add additional where clauses).

However when I run this job, I notice that for each input component, ALL of the data is retrieved from the database before pipe-lining to the tMap.

I actually only want to get back the resultset of the query, is this possibly? I have been using the talend reference from my instructor
This is using TMDMCE-Studio-All-r50363-V4.1.1
Thanks in advance

Re: retrieve results of a custom sql query from a database connection

Posted: Fri Sep 14, 2018 4:58 pm
by EPO / PATSTAT Support
I have no experience with TALEND myself.
And I am not sure that here you will get a prompt response here - but I hope somebody could prove me wrong. This forum is about PATSTAT data and not so much about ETL tools like TALEND.

I think you might get a faster answer to your question at a specialized forum like .https://www.talendforge.org/forum/

Martin

Re: retrieve results of a custom sql query from a database connection

Posted: Wed Sep 19, 2018 9:14 am
by Fr3dY
Hi Sarah,

I don't have any experience with Talend myself, but this link might help you:
https://help.talend.com/reader/Dx4Xf8yk ... zg9k_R4d6w





Regards,

Re: retrieve results of a custom sql query from a database connection

Posted: Tue Oct 16, 2018 3:05 pm
by aditya5670
here sql tutorial welookups https://www.welookups.com/sql/default.html