Four Stars

How to archive(Move) data from postgres(Postgres 9.3) database to SQL database using TOS Data integration Tool(7.x)

Hi All,

 

I am new to Talend Tool. 

I have a one scenario , where I need to archive data from postgres database to SQL database.

Scenario Description:  I have Postgres(postgres V9.3 ) database  as a my main database. In my main database(Postgres) I want to archive data from some of the tables like 3 out of 10 tables . That tables data i want to import into SQL database.

Now , Suppose I want to run a select query on 3 tables( 3 out of 10 tables) . Result of that select query , want to insert into sql database. And then I want to run a delete query , which will delete data permanently from that 3 tables , if above select and insert query was successful,if above job failed it should send a mail. I have attached flow diagram

 

Please guide I am new to Taled DI Tool. Help will be appreciate.

 

Thanks and Regards

Suresh Dewasi

1 REPLY
Four Stars

Re: How to archive(Move) data from postgres(Postgres 9.3) database to SQL database using TOS Data integration Tool(7.x)

Hi All ,

 

Please guide on the below scenario.

 

Regards

Suresh