I have a web application like a ERP based on NodeJs. What I want is that when my client update the value of certain field (like a particular product), the same value is then updated in his website (example: e-commerce) automatically.
The tricky part is that i don't own his website database, and i don't have prior knowledge about the database structure, tables, schemas and etc... And my clients do not have technical knowledge, so, i don't want them to have to keep describing the database and last but not least, can be ANY e-commerce type website.
The first part of the application, will simulate the contracting of the service, where the customer informs the routes (in his website) and "possibly" some API Keys. In this part of the project time is not a restriction, if the method takes days to map the database, copy/sync, that is [login to view URL] it needs to be automatic.
That said, now with the customer already using the application, everything needs to works smoothly, and every each product arriving or leaving in the ERP system, needs to represent similar movement in his e-commerce website.
My ERP takes input of diferente plataforms, mobile, web... So needs to be like a independent API or a microservice.
If you have any sugestion, or think you need something more or something less to develop a solution similar to the one described above, just let me know.