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
Hi All ,
Please guide on the below scenario.
Are your table column schema same?
If we understand your requirement very well, the job design should be:
tPostgresqlInput-->further processing(data transformation)-->DBoutput
tPostgresqlRow(Delete statment) \ tSendmail(job failed)
Let us know if it is OK with you.
Don't hesitate to post your issue here.
Can you post screenshot of connected component , so it will be easy to understand.
I have attached my problem scenario. I have same number of tables and column in target database(sql database) as source database(postgres) have.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
Pick up some tips and tricks with Context Variables