Learn more
 

Query Odoo Data in MySQL Workbench


Create a virtual MySQL database for Odoo data in CData Connect (or Connect Server) and work with live Odoo data in MySQL Workbench.

MySQL Workbench allows users to administer MySQL environments and gain better visibility into databases. When paired with CData Connect (on-premise or Connect Server), you get live access to Odoo data as if it were a MySQL database. This article shows how to create a virtual database for Odoo in Connect and work with live Odoo data in MySQL Workbench.

About Odoo Data Integration

Accessing and integrating live data from Odoo has never been easier with CData. Customers rely on CData connectivity to:

  • Access live data from both Odoo API 8.0+ and Odoo.sh Cloud ERP.
  • Extend the native Odoo features with intelligent handling of many-to-one, one-to-many, and many-to-many data properties. CData's connectivity solutions also intelligently handle complex data properties within Odoo. In addition to columns with simple values like text and dates, there are also columns that contain multiple values on each row. The driver decodes these kinds of values differently, depending upon the type of column the value comes from:
    • Many-to-one columns are references to a single row within another model. Within CData solutions, many-to-one columns are represented as integers, whose value is the ID to which they refer in the other model.
    • Many-to-many columns are references to many rows within another model. Within CData solutions, many-to-many columns are represented as text containing a comma-separated list of integers. Each value in that list is the ID of a row that is being referenced.
    • One-to-many columns are references to many rows within another model - they are similar to many-to-many columns (comma-separated lists of integers), except that each row in the referenced model must belong to only one in the main model.
  • Use SQL stored procedures to call server-side RFCs within Odoo.

Users frequently integrate Odoo with analytics tools such as Power BI and Qlik Sense, and leverage our tools to replicate Odoo data to databases or data warehouses.


Getting Started


Create a Virtual MySQL Database for Odoo Data

CData Connect uses a straightforward, point-and-click interface to connect to data sources and generate APIs.

  1. Login to Connect and click Connections.
  2. Select "Odoo" from Available Data Sources.
  3. Enter the necessary authentication properties to connect to Odoo.

    To connect, set the Url to a valid Odoo site, User and Password to the connection details of the user you are connecting with, and Database to the Odoo database.

  4. Click Save Changes
  5. Click Privileges -> Add and add the new user (or an existing user) with the appropriate permissions.

With the virtual database created, you are ready to connect to Odoo from MySQL Workbench.

Query Odoo from MySQL Workbench

The steps below outline connecting to the virtual Odoo database in Connect from MySQL Workbench and issuing basic queries to work with live Odoo data.

Connect to Odoo through Connect

  1. In MySQL Workbench, click to add a new MySQL connection.
  2. Name the connection (CData Connect).
  3. Set the Hostname, Port, and Username parameters to connect to the SQL Gateway.
  4. Click Store in Vault to set and store the password.
  5. Click Test Connection to ensure the connection is configured properly and click OK.

Query Odoo Data

  1. Open the connection you just created (CData Connect).
  2. Click File -> New Query Tab.
  3. Write a SQL query to retrieve Odoo data, like SELECT * FROM odoodb.res_users;

With access to live Odoo data from MySQL Workbench, you can easily query and update Odoo, just like you would a MySQL database. Request a demo of the CData Connect and start working with Odoo just like a MySQL database today.

Ready to get started?

Learn more or sign up for a free trial:

CData Connect Server

In this article

Related articles