Best way to sync data between instances?

[EJ13]

Hi all,

I have two prod instances, and I need to make sure that the user tables on both remain in sync. How would I go about doing this? I am aware of Instance Data Replication, but we don't have a subscription to it so I'm looking for an alternative. Thank you!

[Uncle Rob]

Something called Instance Data Replication has been out for a while.  You could ask your rep about it.

[Shivalika · Accepted solution]

Hello @EJ13 

1)You may either create a scheduled import from your one instance to other which pulls the data from one to other daily. 

2)You can create a REST Message with endpoint as your second instance and in "POST" method you can create the same user in target instance also. This "Rest message" will trigger via a "BR every time there is an insert in sys_user" table.

Both are good options. 

Kindly mark my answer as helpful and accept solution if it helped you in anyway. This will help me be recognized for the efforts and also move this questions from unsolved to solved bucket. 

Regards,

Shivalika 

My LinkedIn - https://www.linkedin.com/in/shivalika-gupta-540346194

My youtube - https://youtube.com/playlist?list=PLsHuNzTdkE5Cn4PyS7HdV0Vg8JsfdgQlA&si=0WynLcOwNeEISQCY

[Dr Atul G- LNG]

Hi @EJ13 

Data replication is a good option, but as you said you don't have a subscription, then API is good option, create rest API and sycn the data.

https://youtu.be/Pqf49CBoOoI

[Shivalika]

Hello @EJ13 

Please confirm if you checked my answer. Kindly mark my answer as helpful and accept solution if it helped you in anyway. This will help me be recognized for my efforts and also it can move from unsolved bucket to solved bucket. 

Regards, 

Shivalika 

My LinkedIn - https://www.linkedin.com/in/shivalika-gupta-540346194

My youtube - https://youtube.com/playlist?list=PLsHuNzTdkE5Cn4PyS7HdV0Vg8JsfdgQlA&si=0WynLcOwNeE