Database DataWarehousing (MOSC)

MOSC Banner

Data synchronization blues - real-time data refresh without DB links or MVs?

edited Oct 31, 2019 4:50AM in Database DataWarehousing (MOSC) 7 commentsAnswered

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center