Please I need help in this new kind of integration I need to do for my work and this is my fist time .... any hits can help me
I have to integrate between 2 tables into 2 different databases, the first database Db1 has the tabe name T1 and I need to syncronize every tranzaction happned in T1 to replicated in T2 and not vise versa .... plus not all the data in T1 only some selected columns to be replicated to T2 columns (T2 in Db 2 is alredly exisit in te database ) ....
Using which tool or technology? Streams, GoldenGate, some third party product?
It's relatively simple to do in Streams and GoldenGate.
With GoldenGate, the TABLE parameter in the extract could used COLS (to grab the columns you want) or COLSEXCEPT (to exclude the columns you do not want). And if for certain rows, you can filter (to get those) using a WHERE clause.