2

I have an Oracle DB with data in onPrem and Azure Postgresql DB in cloud. I really need data changes in Oracle to be reflected as near to real-time as possible in Azure Postgresql DB. I need data changes in Azure Postgresql DB to be reflected as near to real-time as possible in OnPrem Oracle.

See the below diagram for more info. Architecture Diagram

I am new to Azure-Postgresql. I would appreciate any suggestions / insights.

Martijn Pieters
  • 1,048,767
  • 296
  • 4,058
  • 3,343
ga7202
  • 93
  • 8
  • 1
    Oracle's solution would be Golden Gate but that generally requires additional licenses. – Justin Cave Apr 23 '21 at 11:12
  • Is it unidirectional or bi-directional?if any data insrted to azure DB will that to be synced to onPrem Oracle DB? – ga7202 Apr 23 '21 at 11:22
  • It can do heterogeneous bidirectional replication. Before Oracle bought it, it was a separate company that was focused on real-time replication between heterogeneous data sources. – Justin Cave Apr 23 '21 at 11:23
  • Any azure service which can perform sync beween onprem Oracle DB to Azure postgre and vice versa. – ga7202 Apr 23 '21 at 13:57
  • 1
    @ganthota, per my experience, you can create a pipeline to copy/sync the data between on-premise database and Azure Postgresql DB with [Data Factory](https://learn.microsoft.com/en-us/azure/data-factory/introduction). Then create a schedule trigger to run the pipeline every 5 mins. That's the closest way to data sync. – Leon Yue Apr 26 '21 at 05:40
  • Hi @ganthota, If my answer is helpful for you, hope you can accept it as answer. This can be beneficial to other community members. Thank you. – Leon Yue Apr 27 '21 at 00:51
  • I started doing POC on your answer. Once its done i ll accept it. – ga7202 Apr 28 '21 at 10:54
  • @ga7202 could you please advise how you finally achieved this bi-directional synch? – Jacob Sep 07 '22 at 04:19

1 Answers1

3

Just for now, there isn't a directly way to sync the data between on-premise Oracle database and Azure PostgreSQL database. You need use other ETL ways.

Per my experience, you can think about use Data Factory.It's used to transfer the data to achieve the data sync. You could follow this way:

  1. Create a pipeline to copy the data from on-premise Oracle to Azure PostgreSQL.
  2. Create a schedule trigger to run the pipeline, we can set the execution every 5 mins.

For on-premise dataset, you also need self-hosted integration runtime.

Ref the tutorials:

  1. Copy data from and to Oracle by using Azure Data Factory
  2. Copy and transform data in Azure Database for PostgreSQL by using Azure Data Factory

You need to think about the cost and if it's acceptable to you.

Leon Yue
  • 15,693
  • 1
  • 11
  • 23