Synchronizing Zoho CRM data into an internal database.

Synchronizing Zoho CRM data into an internal database.

So I'm trying to sync data inputted into zoho crm into a MySQL database (hosted on AWS). 

The background is this: I have a user who can make an order, or have an order made for him. So the order can be either made by:
  1. The user themselves, through an App (in which case it's entered to the DB)
  2. Or a Sales Rep on behalf of the user. in this case, the order is entered into the CRM (we also want to sync this into our DB).
We are trying to consolidate all the records in a uniform format in our DB, but it's not so clear how to do this for entries made through Zoho CRM. 

So the table would look something like this:

id
user_id
order_id
source
1
100
1
App
2
105
2
CRM

What integrations need to be made such that any entry inputted into the CRM is transferred, in real-time, to our internal database?
 
Ideally it would be something triggers on both record creations, and record edits.