Skip to Content
Menu
This question has been flagged
1 Reply
1561 Views

Hi everyone,

We're looking for a way to write data to an external database each time a record is created.

- I tried setting up Zapier to add a trigger each time a record is created, but Zapier doesn't seem to be compatible with Odoo.sh

- Then explored the possibility of connecting to the Odoo instance via the XML-RPC API, but I guess with this option I should be querying the Odoo instance in an infinite loop to check for new records?

- Trying now to just edit the Python code of the model to add a small script that sends the data to the external database each time a record is created. Is it possible to edit the source code of a model created with Studio on Odoo.sh?

Thanks!

Avatar
Discard

Any record or a specific type of record?

Author

Hi Oliver, this is for a specific type of record

Best Answer

Would not db replication solve this more easily?

###

The process of copying data from a PostgreSQL database server to another server is called PostgreSQL Replication. The source database server is usually called the Master server, whereas the database server receiving the copied data is called the Replica server.

Avatar
Discard
Author

Hi Kim, that will definitely solve the problem. Can this be done with Odoo.sh?

Related Posts Replies Views Activity
1
Dec 24
35
1
Jun 19
3475
2
Aug 24
391
1
Apr 19
3375
0
Dec 24
37