https://community.qlik.com/t5/Talend-Studio/push-a-query-to-DB-Oracle/m-p/2287548#M61121 <P>I am reading from an Oracle database with a basic filter e.g. year =2019. If I use the Talend db component with a Tmap, it reads all records in(across a network) and takes forever. I know the query at the db is very fast.&nbsp; I'd like Talend to send the query to the database and bring in the records as they meet the criteris. How would this be accomplished?&nbsp;</P> Sat, 16 Nov 2024 05:57:00 GMT Anonymous 2024-11-16T05:57:00Z https://community.qlik.com/t5/Talend-Studio/push-a-query-to-DB-Oracle/m-p/2287548#M61121 <P>I am reading from an Oracle database with a basic filter e.g. year =2019. If I use the Talend db component with a Tmap, it reads all records in(across a network) and takes forever. I know the query at the db is very fast.&nbsp; I'd like Talend to send the query to the database and bring in the records as they meet the criteris. How would this be accomplished?&nbsp;</P> Sat, 16 Nov 2024 05:57:00 GMT https://community.qlik.com/t5/Talend-Studio/push-a-query-to-DB-Oracle/m-p/2287548#M61121 Anonymous 2024-11-16T05:57:00Z https://community.qlik.com/t5/Talend-Studio/push-a-query-to-DB-Oracle/m-p/2287549#M61122 <P>Hi, of course - you can add any query condition into tDBInput query</P> Wed, 01 May 2019 23:16:01 GMT https://community.qlik.com/t5/Talend-Studio/push-a-query-to-DB-Oracle/m-p/2287549#M61122 vapukov 2019-05-01T23:16:01Z