Export a table from Oracle to Odoo module:

-        Export data from table in oracle and create module in odoo.

            Step by step :

1.     Create directory in oracle by script :

CREATE OR REPLACE DIRECTORY

CK_201912 AS 'E:\DATACK\2019\12';

2.      Copy package from source to Oracle database and compile:

pck_generate_module_odoo

3.      Run script to create file for odoo module, for example :

call pck_generate_module_odoo.generate (

         ‘Aircraft master',   -- module name

      'CRM_COMPANY',       -- table name in oracle

      'list of aircraft',  -- description for module

      'AIR_',              -- prefix for table in odoo 

      'CK_201912')         -- Directory for generating file in module

4.      We have got all file in directory :

Copy file to overwrite module “template” that is downloaded from github :

-        Copy Air_crm_company.csv to template/data

-        Copy data.xml to template/security

-        Copy ir.model.access.csv to template/security

-        Copy models.py to template/model

-        Copy views.xml to template/view.

Finally, we have module “template” and rename to module : crm_company.

5.     Copy to odoo server and install we have module and data from oracle will be installed in odoo:

And then we have data from oracle’s table