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
retrieve results of a custom sql query from a database connection
-
- Posts: 2
- Joined: Mon May 07, 2018 11:14 am
-
- Posts: 231
- Joined: Thu Feb 22, 2007 5:33 pm
- Contact:
Re: retrieve results of a custom sql query from a database connection
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
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
PATSTAT Support Team
EPO - Vienna
patstat @ epo.org
EPO - Vienna
patstat @ epo.org
Re: retrieve results of a custom sql query from a database connection
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,
I don't have any experience with Talend myself, but this link might help you:
https://help.talend.com/reader/Dx4Xf8yk ... zg9k_R4d6w
Regards,
-
- Posts: 1
- Joined: Tue Oct 16, 2018 3:03 pm
Re: retrieve results of a custom sql query from a database connection
here sql tutorial welookups https://www.welookups.com/sql/default.html
Re: retrieve results of a custom sql query from a database connection
Hello i got your point and i am damn sure that the link will sought your Sql Query.
You will get very much knowledge and your query will be resolved
https://www.janbasktraining.com/blog/se ... erdate=&q=
You will get very much knowledge and your query will be resolved
https://www.janbasktraining.com/blog/se ... erdate=&q=