Objective
An FMCG client needed an automated way to update multiple product details — including images, videos, and descriptions — on the Odoo server in real time. Manual uploads were inefficient and prone to delays, making scalability difficult.

Approach
Our team developed an automated integration workflow using Talend ETL and REST APIs:
• Established a connection between the Oracle Database (source) and the Odoo server (destination).
• Configured Talend ETL jobs to detect new product entries as soon as they were created in the Oracle database.
• Utilized REST API calls to automatically push complete product details — including multimedia — to the Odoo system.

Solution Overview
This automated workflow ensured seamless, real-time synchronization between Oracle and Odoo, eliminating the need for manual uploads and ensuring the client’s product catalog remained up to date across platforms.