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


Calling Talend Open Studio Users

The first 100 community members completing the Open Studio survey win a $10 gift voucher.

Start the survey

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

Put Massive Amounts of Data to Work

Learn how to make your data more available, reduce costs and cut your build time

Watch Now

How OTTO Utilizes Big Data to Deliver Personalized Experiences

Read about OTTO's experiences with Big Data and Personalized Experiences

Blog

Talend Integration with Databricks

Take a look at this video about Talend Integration with Databricks

Watch Now