push a query to DB(Oracle)

Four Stars

push a query to DB(Oracle)

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.  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? 

Forteen Stars

Re: push a query to DB(Oracle)

Hi, of course - you can add any query condition into tDBInput query

-----------

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog