Daily Incremental of copy of data to redshift

Four Stars

Daily Incremental of copy of data to redshift

Hello all,
My question could sound silly to experts here but I am complete newbie at talend and java so please pardon my ignorance and guide me the way to  complete my desired task
I have a table source table in  mysql rds and I want to copy the table on daily basis into redshift
Can some one tell which talend components to use to perform daily inserts from rds table to redshift database
Any help would be appreciated 
regards
Four Stars

Re: Daily Incremental of copy of data to redshift

Hello Ankit,
You could use below shown Redshift / Amazon Mysql rds connectors for your job.
Create a job with "Amazon Mysql Input component" as a input by specifying your table name and "Redshift output component" in your job output / target table and perform your daily schedule.

Important URL's for component functionalities: 
Redshift components for Talend:  https://help.talend.com/search/all?query=tRedshiftBulkExec
Amazon MySql rds components for Talend:
https://help.talend.com/search/all?query=tAmazonMysqlConnection&content-lang=en