Advanced Odoo Connectivity - SQL Server
Learn how to connect to a SQL Server database and then import that data into a running Odoo instance.
This video explores advanced Odoo Connectivity using the Odoo API and Win32 libraries to connect directly to SQL Server databases. If you plan to migrate systems to Odoo the ability to easily import and sync data with legacy systems is vital. In this video you learn how to connect to a SQL Server database and then import that data into a running Odoo instance. This video is for those who have already completed Mastering Odoo 9 Development - Technical Fundamentals.
- Introduction: Advanced data integration with Odoo and SQL Server
- Installing python 2.7 libraries in Windows and Windows Python Tools
- Importing the Win32com.client library and xmlrpclib for Odoo
- Testing our connections to the Odoo and external database connectivity
- Using the search_read to access record sets in Odoo
- Installing the external database test data AdventureWorks
- Using an ADODB.Connection to access SQL Server databases from Python
- Using ADO record sets to easily access remote SQL data in realtime
- Creating records in Odoo in real-time from remote records in MS SQL Server
- Develop strategies for syncing Odoo data with a remote SQL Server
- Potential use cases for integrating remote systems with Odoo
INTEGRATING ODOO - IMPORTING AND SYNCHRONIZING DATA
There are a lot of compelling reasons to have the ability to integrate Odoo with other systems. First and foremost it provides a skilled integrator with the ability to seamlessly integrate Odoo into enterprise environments with a variety of legacy systems. It provides you great flexibility in importing and syncing critical data with Odoo.
WHAT DATABASES CAN ODOO CONNECT WITH?
The best news is that you can connect to practically any database with Odoo. In this video we use a powerful library that allows you to not just connect to remote databases but also provides easy to use record set utilities for navigating the data. This avoids having to handle messy CSV files and write code that can be quite difficult to read without lots of commenting.
WHO IS THIS VIDEO FOR AND WHAT DO I NEED TO KNOW?
This is an advanced Odoo video aimed at Odoo integrators and developers that wish to connect Odoo with legacy systems or migrate other systems into Odoo. It's for those who need more power and flexibility than the simple CSV file import provides. To get the most out of this Odoo course you must already understand the basics of Odoo's XML-RPC API and how to write basic Python code.
Greg Moss started working with personal computers at 12 years old. At age 15, he wrote his first paid business application, a loan management application for First American Acceptance Corporation. A few months later Greg developed a statistical application to process surveys for John A Logan College. Now more than 30 years later, Greg has produced hundreds of commercial applications and training courses, and has been involved in numerous enterprise application projects.
In addition to completing degrees in Business Administration and Information Systems Design, Greg is a Certified Information Systems Auditor, a Six Sigma Black Belt, and holds an Information Assurance Certification from Carnegie Mellon University. In addition to his successful consulting practice, Greg has worked in positions as a Chief Information Officer (CIO), Chief Executive Officer (CEO), and excels in delivering technology-enabled growth to companies. He is an experienced digital marketer and focuses on real-world results and solutions.
Greg is the founder of First Class Ventures, LLC and OdooClass.com. Over the past 8 years Greg has produced over 200 video courses covering business application development and game design.
Greg is the author of Working with Odoo, Working with Odoo 10, Working with Odoo 11, Working with Odoo 12, and Learn Odoo.