Getting data from Odoo database

[omolobe]

Hello Team,

I have a client who uses Odoo platform for 5 different businesses. I am required to provide data analytics and leverage the data from the 5 businesses into one platform. Is there anyway i can be able to connect to Odoo database

[SakshiBansal11]

Right now i'm implementing incremental load on our tables to get only new or updated records .

Above screenshot display 18th july records (old records)

and in below screenshot it displays new and latest records of 18th july ..but if i see previous records on odoo of 18th of july it will show only latest one .. there is no record of old records and even the id does not exist in odoo 

so i wanted to know how odoo works based on id column?

[Sahir_Maharaj]

Hello @omolobe,

To integrate data from Odoo into a platform for analytics, you have a few options:

1. Direct Database Connection: If you have direct access to the Odoo PostgreSQL database, you can connect to it using various data analytics tools that support PostgreSQL.

2. Odoo API: Odoo provides an XML-RPC API that can be used to access data. This method is recommended if you don't have direct access to the database or need to perform operations like creating and updating records.

Should you have any questions or further assistance, please do not hesitate to reach out to me.