Tutorialspoint

Tricks to Import Huge Amount of Data Into Odoo in Seconds

Regularly import million of external records FAST!

Course Description

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

Using the common standard way, 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, which 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 millions of records per day!

Enjoy!

Who this course is for:

  • Odoo Developer
  • Odoo Consultant
  • Odoo Implementor
  • Odoo Official Partner

Goals

  • 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

Prerequisites

  • Odoo Addon Fundamental
  • Odoo XMLRPC Fundamental
  • Python Language
  • SQL Fundamental
Show More

Curriculum

  • Introduction
    00:43
    Preview
  • Download Resources
  • Background
    03:15
  • Case Study
    02:38
    Preview
  • Restore Sample Database
    03:38
    Preview
  • Datasource Analysis
    02:02
    Preview
  • Datasource Mapping
    02:10
  • Initial Specification
    00:50
Tutorialspoint
Tutorialspoint
Tutorialspoint
Tutorialspoint
Tutorialspoint
Tutorialspoint
Tutorialspoint
Feedbacks
  • No Feedbacks Posted Yet..!
Tricks to Import Huge Amount of Data Into Odoo in Seconds
This Course Includes
  • 3 hours
  • 44 Lectures
  • Completion Certificate Sample Certificate
  • Lifetime Access Yes
  • Language English
  • 30-Days Money Back Guarantee

Sample Certificate

Sample certificate

Use your certification to make a career change or to advance in your current career. Salaries are among the highest in the world.

We have 30 Million registered users and counting who have advanced their careers with us.

X

Sample Certificate

Talk to us

1800-202-0515