Delta Insert from Oracle to MySQL, ETL/Jasper

One Star

Delta Insert from Oracle to MySQL, ETL/Jasper

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
One Star

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

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

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

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
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

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

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

15TH OCTOBER, COUNTY HALL, LONDON

Join us at the Community Lounge.

Register Now

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

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

APIs for Dummies

View this on-demand webinar about APIs....

Watch Now