Tricks to Import Huge Amount of Data Into Odoo in Seconds

Tricks to Import Huge Amount of Data Into Odoo in Seconds

Do you have Odoo implementation cases to regularly import a huge amount of data from external data source like MS SQL, Oracle, MySQL, etc? I meant, very huge, like million of invoices or journal entries record per day ?

Using the common standard way, the Odoo's XMLRPC and ORM, this process can take hours, if not timeout, while we are taking a few cups of coffee as Odoo suggests :)

This course explains in detail about techniques to improve the data import performance, starting from data source query, processing in Python, and processing in Odoo Database (PostgreSQL) to achieve a drastic performance increase, that was previously taking more than 10 hours to only seconds! Yes, seconds.. how can it be ? Is that possible ? 

YES

And we have implemented this technique in many implementation cases where Odoo's default mechanism is no more capable to handle that million of records per day!

Enjoy !

Regularly import million of external records FAST!

Url: View Details

What you will learn

• Techniques to import external data into Odoo fast
• Using XMLRPC Standard
• Using Direct SQL

Rating: 4.25

Level: Intermediate Level

Duration: 3.5 hours

Instructor: Akhmad Daniel Sembiring