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