Data synchronization blues - real-time data refresh without DB links or MVs?
We have a requirement to collect data from several remote systems into a data warehouse on a near real-time basis. Currently we use fast-refresh materialized views over a database link. Unfortunately, we forsee a possible scenario where direct DB links will no longer be allowed because of new security restrictions. Is anyone aware of a method of synchronizing large amounts of data (100's of GB) in near real-time (say no less frequently than every 15 minutes), and using HTTPS instead of TNS, that doesn't involve us writing and maintaining custom code to re-invent features that Oracle provides out of the box? Oh yeah: also assume that there is no admin-level trust relationship between the systems. We've considered GoldenGate, but I wasn't sure that it could work without that admin-level trust between the two systems, or that it could transmit and receive data using HTTPS.