Golden Gate
Golden Gate - OS User Permissions on *nix - DBA vs ETL Admin
dmann — Mon, 11/14/2011 - 13:11
Seems like Golden Gate is following me around. I used their tools in 2005 to replicate from OLTP databases to a central reporting database for my previous employer. Now that Oracle bought them the buzz in my current company is to leave Oracle's multiple and complicated incarnations of replication technologies in the dust and try moving forward with GG. Fine with me, I like the product, not a fan of the licensing as I think Oracle has been on the lagging side of vendor supplied replication tools, but hey what do I know, I just arrange zeroes and ones for a living.
Need to audit changes? Can't change source database at all? This may work...
dmann — Mon, 04/12/2010 - 11:42
If you want to record copies of changed records on a target system you can do this with Golden Gate Software and not incur much in the way of source side resource drain.
