Update to the ODBC Connector with Odoo
Расположение: Martin's / Vitality - 03.10.2019, 11:30 - 03.10.2019, 11:50 (Europe/Brussels) (20 минут)
Update to the ODBC Connector with Odoo
Lukas Minder
Lukas Minder

35 years old, Swiss, Bachelor of Arts in Business & Economics, broad experience in retail business operations (sales, ecommerce, omnichannel) and business analysis (ERP, POS). Started to work for brain-tec in May 2019 as project manager / consultant for Odoo implementations.


Target Audience: Consultants and developers who are interested in connecting Odoo with other systems via Open Database Connectivity (ODBC). 

Key Learnings: Reminder/update to the ODBC connector and the various options of how to apply it. 

Value to the audience: An easy way to integrate Odoo in a landscape with peripheral systems that provide ODBC interfacing. It's a smart approach to introduce Odoo in a complex system architecture that cannot be replaced totally by Odoo in a first step. Structure of the talk:

What's ODBC and what you will learn?

  • An easy way to integrate Odoo in a landscape with peripheral systems that provide ODBC interfacing

  • Automated transfer between Odoo and other external databases as MS SQL, Firebird, etc.

  • Asynchronous data transfer (read from external, write to external)

  • Update or create complex record sets in Odoo

  • No need for separate imports of complex data structure as Parent-Child-relations are imported “on-the-fly”

  • On-the-fly data wrapping, e.g. 0 > male, 1 > female; Stk > product.product_uom

  • The connector is applicable on every module

  • Use cases made by Brain-tec till today

    • e.g. Employees with contracts, skills

    • e.g. Company structure

    • e.g. MS Navision financial debit/credit accounts mapped into Odoo project management for cost analysis

    • e.g. Automated stock moves / balancing in Inventory with Firebird db

News: 

  • Migrated to V11

  • Unique key changes in Navision can now be handled so the same record is updated and not a new one is created

  • User Interface is more convenient

  • Integrated documentation for help/assistance

  • The error handling has been improved: the display of import errors in GUI and not only on log level