When to use Golden Gate?
I would like you to go through the difference between Oracle Golden Gate and Dell SharePlex.
SharePlex is a replication tool from Dell Software. It is comparatively older and is the closest competitor to Oracle GoldenGate in terms of features it provides for database replication needs. It was originally made for Oracle database replication needs and now supports a range of heterogeneous environments too. One of the biggest difference between SharePlex and Golden Gate is:
"Golden Gate is a true heterogeneous player that supports most of the popular database environments while SharePlex is limited to few popular databases only"
I would like you to go through the difference between Oracle Golden Gate and Oracle Streams. Here are the best links for same: