Tricks to Import Huge Amount of Data Into Odoo in Seconds
Regularly import million of external records FAST!
What you will learn
Techniques to import external data into Odoo fast
Using XMLRPC Standard
Using Direct SQL
Using Stored Procedure PL/PGSQL
Automating the Import Process
Filtering Record to Import
Why take this course?
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 !