Replicat db on premise to bucket google storage

User_OVSOU

Goodmorning everyone,

we have to create a real time data replica from an oracle db on premise to a Google bucket through the Golden Gate 19 product (about 40 million movements per day). Our idea is:

- to use the “File Writer Handler” on the replicat side to produce the text files;

- to use the Command Event Handler to transfer these text files on google buckets.

Is this a right way for our purpose?

I also ask you, if there are other kind of handler, which are not owned by third parties (example Fuse), which can be used and can be configured in the replication process to allow production of replica’s files directly into Google's storage bucket.

LexmanLexman-Oracle

Hi

You may use Goldengate Bigdata adapters for writing files to Google cloud bucket.

See below Documentation for available handlers

https://docs.oracle.com/en/middleware/goldengate/big-data/21.1/gadbd/using-google-cloud-storage-event-handler.html#GUID-68016710-E1D8-4DC5-9C8C-3DC8B842BD15