topic Re: Delta Insert from Oracle to MySQL, ETL/Jasper in Talend Studio

Delta Insert from Oracle to MySQL, ETL/Jasper

Anonymous — Sat, 16 Nov 2024 13:21:30 GMT

Hi,
i?m brand new at the JasperETL / Talend and not very familiar.
I like to develop a delta insert at a MySQL DB?s from a Oracle DB?s.
So the date was separate from the Oracle DB?s and import to the MySql.
But if the dataset are in the MySQL it doesn?t import the old dataset.
If the Changetimestamp new on the Oracle dataset the changed dataset must run in the MySQL at an new dataset.
I hope you can understand my description.
1000 thx for your support
Wolfgang

Re: Delta Insert from Oracle to MySQL, ETL/Jasper

Anonymous — Wed, 14 Jul 2010 07:49:51 GMT

Hi,
is there nowbody that hat any idear???
I cant belive!!

Re: Delta Insert from Oracle to MySQL, ETL/Jasper

Anonymous — Wed, 14 Jul 2010 08:04:47 GMT

Hi
You can use the data action 'insert or update', set Changetimestamp column as key column, if I don't understand you well, please give us an exmaple with some records.
Best regards
Shong

Re: Delta Insert from Oracle to MySQL, ETL/Jasper

Anonymous — Wed, 14 Jul 2010 09:59:10 GMT

Hi Shong,
i?m import with tOracleInput (with a SQL inside) direct to tMysqlOutput. With no transforming and so on.
Oracle Table:
CID (String)
CGD (Date dd.MM.yyyy?T?HH:mm:ss)
CED (Date dd.MM.yyyy?T?HH:mm:ss)
Termin (Date)
Seite (String)
MySQL Table:
CID (String)
CGD (Date dd.MM.yyyy?T?HH:mm:ss)
CED (Date dd.MM.yyyy?T?HH:mm:ss)
Termin (Date)
Seite (String)
So the Import job must run every 1 min. and if a new CID import the whole dataset from Oracle to MySQL.
But if the CID, CGD and CED same like at the MySQL db no insert.
And if the CID, CGD same and the CED dive rent to the MySQL table it must import the whole Dataset as a new dataset.
And so I need a connection to the Oracle and the MySQL db to make a timestamp filter.
I hope this description will give you a help.
Regards Wolfgang