Data sync Azure and on premise

MikeZheng-3371 46

Hello,

I need to sync the data between Azure (mongoDB) and on premise (Oracle), some sync need to be done in real time, some sync can be done hourly or daily. What is the best approach for me to those data sync? Is there good document related to this topic?

1 answer

Oury Ba-MSFT 20,006 Reputation points Microsoft Employee

2022-05-23T22:01:58.77+00:00

Hi @MikeZheng-3371 Thank you for posting your question o Microsoft Q&A and for using Azure services.
My understanding is that you are looking to sync your on prem oracle db data with your Azure Mongo db on cloud and wants your sync to be done hourly or daily.

Options to migrate your on-premises or cloud data to Azure Cosmos DB
Copy data from or to MongoDB using Azure Data Factory or Synapse Analytics

Those are the docs with guidance. You’re going to need to denormalize the data, azure data factory is probably going to be your best bet.
Are you familiar with Data Factory.?

Regards,
Oury
Please sign in to rate this answer.
MikeZheng-3371 46 Reputation points

2022-05-25T12:29:22.943+00:00

Is there any other tool can be used for real time sync, including simultaneously and several minutes delay? Azure Data Factory and Synapse Analytics are good for batch processing with larger delays, are they?

Oury Ba-MSFT 20,006 Reputation points Microsoft Employee

2022-05-26T23:07:20.983+00:00

@MikeZheng-3371 You are right!
Azure Data Factory and Synapse are good for batch processing. Tha larger delays depends on the amount of data. I just got informed that oracle is in the road map and that we are currently supporting SAP, Cosmos DB and SQL server if you want to sync on prem data to Cloud using ADF or Synapse.

Regards,
Oury

MikeZheng-3371 46 Reputation points

2022-05-27T11:41:12.423+00:00

Is there any other tool can be used for real time sync, including simultaneously and several minutes delay?

Oury Ba-MSFT 20,006 Reputation points Microsoft Employee

2022-05-31T21:11:43.897+00:00

@MikeZheng-3371 Sorry for the late reply. I was able to verify this internally with the team. It is not possible to sync on prem oracle with Azure Cosmos DB on cloud? Oracle is on the road map. We only support SAP, Cosmos DB, SQL Server 2022.

Regards,
Oury

Oury Ba-MSFT 20,006 Reputation points Microsoft Employee

2022-06-01T20:00:43.217+00:00

@MikeZheng-3371 Sorry for the late reply. I was able to verify this internally with the team. It is not possible to sync on prem oracle with Azure Cosmos DB on cloud? Oracle is on the road map. We only support SAP, Cosmos DB, SQL Server 2022.

Regards,
Oury
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Data sync Azure and on premise

1 answer

Your answer