This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(112.00000000000001, 96%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESN%3C/text%3E%3C/svg%3E)
I am looking for real time data synchronization with 1-2 seconds latency between Azure Cosmos DB(Mongo DB API) and DB2 database without direct connection with on-premise database. What are the ways to achieve this scenario?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(172.8, 70%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMM%3C/text%3E%3C/svg%3E)
Hello @swapnil nagpure ,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet .In case if you have any resolution please do share that same with the community as it can be helpful to others . Otherwise, will respond back with the more details and we will try to help .
Thanks
Martin
Hi @MartinJaffer-MSFT
Please find the reply below
Hello @swapnil nagpure and welcome to Microsoft Q&A.
I understand you want to Sync Cosmos (Mongo) with DB2, with Cosmos doing the pushing. What I don't understand is what you mean by without direct connection with on-premise database.
What kind of connection did you have in mind?
When I said 'without direct connection with on-premise database' I meant we cannot establish DB2 connection directly we have to do it using some Gateway or using some other service. But that's part is not that much important. The real problem for me is real time synchronization. ADF is good solution for syncing but it don't provide real time sync.
So I think what you are looking for is "Change streams" which seems similar to the Change Feed in SQL. @swapnil nagpure
By itself, Data Factory does not know when a change is made in Cosmos Mongo. This means it cannot do appropriate pulls. Data Factory may not be the right tool for real-time synchronization. However if you can hook up an Event Trigger to Cosmos, then you could make real-time work depending upon volume. This might require a custom event.
Change Feed Design Patterns
Cosmos Change Feed
Change Feed in Mongo